Sql Server Articles (246) - Page 2

Beginners Guide: Foreign Key in SQL Server 

Learn what is foreign key in SQL Server, what is the need to have a foreign key and how to create it

Beginners Guide: Group By In SQL Server 

Learn the basics about group by and aggregate functions in SQL Server

Beginners guide: How to Sort Results In SQL Server 

Learn the basics of sorting in SQL Server

Beginners guide: How to use And & OR Operator in SQL Server 

Learn the basics of And & OR operator in SQL Server

How to create Auto Increment table in SQL Server 

Learn basics of identity column in SQL Server

How to copy Table Structure Without Data in SQL Server 

find the trick to copy table structure from another existing table.

How to Create Alter And Drop Check Constraint In SQL Server with Examples 

Learn what is check constraint and how to use it in SQL Server

How to create a table with default value in SQL Server 

Back to Basics series: Default Values in SQL Server.

How To Create Primary Key In SQL Server 

Learn what is the importance of primary key, why we should use it and how to create Alter and drop the primary key in SQL Server.

Use of Patindex and Parsename To bring Unstructured Record into Structure format 

In this article we will learn the use of PATINDEX and PARSENAME to extract relevant information from unstructured data.

Convert Words To Decimal Number using TSQL in SET Based Way 

Let's say we have One Hundred Thirty Four and Nineteen. We have to convert the words in Decimal Number such that, the desire output will be 134.19. In this article, we will look into the conversion of the same using TSQL in SET Based Way.

Convert Decimal Number To Words using TSQL in SET Based Way 

Let's say we have given a number 145.49. We have to convert the number in words such that, the desire output will be One Hundred Fourty Five and Fourty Nine. In this article, we will look into the conversion of the same using TSQL in SET Based Way.

Applicability Of Cross Apply with STRING_SPLIT in SQL Server 

SQL Server 2016, has introduced the STRING_SPLIT function.This function splits the string using specified delimiter. SQL Server 2005 introduced the APPLY operator which is use to join a table to a table-valued function.The CROSS APPLY operator returns only those rows from left table expression if that matches with right table expression. In this article, we will present the applicability Of Cross Apply with STRING_SPLIT by providing some examples.

Convert Words To Number using TSQL in SET Based Way 

Let's say we have One Hundred Thirty Four. We have to convert the words in number such that, the desire output will be 134. In this article, we will look into the conversion of the same using TSQL in SET Based Way.

Convert Number To Words using TSQL in SET Based Way 

Let's say we have given a number 145. We have to convert the number in words such that, the desire output will be One Hundred Thrirty Four. In this article, we will look into the conversion of the same using TSQL in SET Based Way.