Sql Server Articles (246) - Page 2

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

246 records found.
 
Neerajprasadsharma
Beginners Guide: Foreign Key in SQL Server 
Last updated on: 13 May 2017 07:11:15 AM by Neerajprasadsharma | Views: 2594 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
Learn what is foreign key in SQL Server, what is the need to have a foreign key and how to create it
Neerajprasadsharma
Beginners Guide: Group By In SQL Server 
Last updated on: 11 May 2017 01:12:40 PM by Neerajprasadsharma | Views: 1780 | Category: Sql Server |
Learn the basics about group by and aggregate functions in SQL Server
Neerajprasadsharma
Beginners guide: How to Sort Results In SQL Server 
Last updated on: 10 May 2017 01:12:39 PM by Neerajprasadsharma | Views: 2225 | Category: Sql Server |
Learn the basics of sorting in SQL Server
Neerajprasadsharma
Beginners guide: How to use And & OR Operator in SQL Server 
Last updated on: 09 May 2017 02:12:40 PM by Neerajprasadsharma | Views: 1720 | Category: Sql Server |
Learn the basics of And & OR operator in SQL Server
Neerajprasadsharma
How to create Auto Increment table in SQL Server 
Last updated on: 07 May 2017 03:17:48 PM by Neerajprasadsharma | Views: 5245 | Category: Sql Server |
Learn basics of identity column in SQL Server
Neerajprasadsharma
How to copy Table Structure Without Data in SQL Server 
Last updated on: 06 May 2017 04:11:37 PM by Neerajprasadsharma | Views: 10446 | Category: Sql Server |
find the trick to copy table structure from another existing table.
Neerajprasadsharma
How to Create Alter And Drop Check Constraint In SQL Server with Examples 
Last updated on: 02 May 2017 11:48:44 AM by Neerajprasadsharma | Views: 3453 | Category: Sql Server |
Learn what is check constraint and how to use it in SQL Server
  • Neerajprasadsharma
    How to create a table with default value in SQL Server 
    Last updated on: 02 May 2017 06:44:36 AM by Neerajprasadsharma | Views: 31591 | Category: Sql Server |
    Back to Basics series: Default Values in SQL Server.
    Neerajprasadsharma
    How To Create Primary Key In SQL Server 
    Last updated on: 29 Apr 2017 06:20:29 AM by Neerajprasadsharma | Views: 2304 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    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.
    Rajnilari2015
    Use of Patindex and Parsename To bring Unstructured Record into Structure format 
    Last updated on: 22 Mar 2017 11:10:12 PM by Rajnilari2015 | Views: 1972 | Category: Sql Server |
    In this article we will learn the use of PATINDEX and PARSENAME to extract relevant information from unstructured data.
    Rajnilari2015
    Convert Words To Decimal Number using TSQL in SET Based Way 
    Last updated on: 15 Feb 2017 10:24:39 PM by Rajnilari2015 | Views: 1625 | Category: Sql Server |
    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.
    Rajnilari2015
    Convert Decimal Number To Words using TSQL in SET Based Way 
    Last updated on: 15 Feb 2017 09:46:22 PM by Rajnilari2015 | Views: 3620 | Category: Sql Server |
    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.
    Rajnilari2015
    Applicability Of Cross Apply with STRING_SPLIT in SQL Server 
    Last updated on: 15 Feb 2017 08:04:53 AM by Rajnilari2015 | Views: 11772 | Category: 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.
    Rajnilari2015
    Convert Words To Number using TSQL in SET Based Way 
    Last updated on: 14 Feb 2017 11:44:06 PM by Rajnilari2015 | Views: 1392 | Category: Sql Server |
    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.
    Rajnilari2015
    Convert Number To Words using TSQL in SET Based Way 
    Last updated on: 14 Feb 2017 11:11:22 PM by Rajnilari2015 | Views: 1945 | Category: Sql Server |
    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.