SQL samples and examples

You can find valuable .NET resources including Articles, Software tools, book reviews, blogs, links to good articles and much more.

You can make money by posting resources here !. Also, we offer several gifts to contributing members.

Total 556 resources found. Post Resource

Resources » Code Snippets » SQL

Show By Status: New Submissions Pending Deleted Approved

Title	Resource Type	Author	Post/Response Date
How to determine First Day of the week From Week Number and Year in SQL Server?	Code Snippets	Viji RAJKUMAR	04 Nov 2009
Create script for each Store Procedure and save each script into Seperate SQL File	Code Snippets	Lakhan Pal	04 Nov 2009
Store Procedure to Generate Create Table Script	Code Snippets	Lakhan Pal	04 Nov 2009
Comparing two tables Rows	Code Snippets	Melchior	29 Oct 2009
Getting multiple row values in a single cell separated by comma`s in sql	Code Snippets	ravi	28 Oct 2009
Finding a text in a Stored Procedure & User Defined Function	Code Snippets	Melchior	28 Oct 2009
How to use a Table Variable in T-SQL	Code Snippets	Ramaraj R	27 Oct 2009
Select nth Maximum value without using RANK / MAX	Code Snippets	Ramaraj R	27 Oct 2009
How to get integer value from float data	Code Snippets	Melchior	26 Oct 2009
How to Execute Stored Procedure	Code Snippets	Shunmuganathan M	26 Oct 2009
SQL, Select values as CSV in output paramter	Code Snippets	hitesh	20 Oct 2009
How to run DOS command within SQL Stored procedure using master..xp_cmdshell (4)	Code Snippets	hitesh	20 Oct 2009
How to get the nth highest value from the database table using SQL (4)	Code Snippets	Kunal	16 Oct 2009
<h2>Difference between Rank() and Dense_Rank() in SQL </h2>	Code Snippets	Kunal	14 Oct 2009
<h2>Using Dense_Rank in SQL server 2005</h2>	Code Snippets	Kunal	14 Oct 2009
Date Format in SQL SERVER 2005	Code Snippets	santosh	12 Oct 2009
Go Back to the Parent Report in SSRS (1)	Code Snippets	Jolly Trivedi	11 Oct 2009
To find keywords in SQLServer Functions & stored Procedure	Code Snippets	Srikanth Reddy	08 Oct 2009
Change Database Name-Sql	Code Snippets	priyaravi	07 Oct 2009
Store Procedure to be Used in Custom Pagging	Code Snippets	Lakhan Pal	26 Sep 2009
Passing Multiple Values to Stored Procedure Parameter (2)	Code Snippets	Praveen	24 Sep 2009
Sql Replace Function	Code Snippets	satya	18 Sep 2009
Select Total Number of records in the Database. (2)	Code Snippets	Mohan	17 Sep 2009
Randomly selecting row from database (1)	Code Snippets	satya	17 Sep 2009
Get Current Month Last Date [SQL]: (1)	Code Snippets	B. Gopal Surya Prakash	17 Sep 2009
Recursion in SQL (1)	Code Snippets	Shunmuganathan M	17 Sep 2009
Insert bulk amount of data (1)	Code Snippets	Shunmuganathan M	17 Sep 2009
Dynamic PIVOT - SQL Server (1)	Code Snippets	Pandian S	17 Sep 2009
Recursion in SQL 2005	Code Snippets	Sameer Sayani	16 Sep 2009
Parse XML Data in SQL Server 2005 without using OPENXML Method	Code Snippets	Lakhan Pal	15 Sep 2009
How to set default value for existing datetime column in SQL Server	Code Snippets	hitesh	10 Sep 2009
Trigonometric functions in ms sql	Code Snippets	Programmer	06 Sep 2009
To Unlock Particular User in Sql Server	Code Snippets	Praveen	04 Sep 2009
Passing table name as parameter in Stored Procedure	Code Snippets	Hygeena	04 Sep 2009
Update using CASE statement (2)	Code Snippets	satya	02 Sep 2009
Create XML FROM SQL Server Using Explicit (4)	Code Snippets	Lakhan Pal	01 Sep 2009
Go To Statement (5)	Code Snippets	Rajesh.Dharmakkan	01 Sep 2009
How to clean log file od a SQL server Database	Code Snippets	Manoranjan Sahoo	26 Aug 2009
Calculate Distance using Latitude and Longtitude	Code Snippets	Mohan	24 Aug 2009
Second Highest and Lowest Salary using SQL Query (7)	Code Snippets	Shunmuganathan M	24 Aug 2009
Magic tables in SQL Server (4)	Code Snippets	Shunmuganathan M	24 Aug 2009
Temporary Tables (2)	Code Snippets	satya	23 Aug 2009
How to find next upcoming birthdays after 15 days using sqlserver?	Code Snippets	Syed Shakeer Hussain	23 Aug 2009
Sql Transaction	Code Snippets	Shunmuganathan M	20 Aug 2009
Using coalesce to build comma separated values as results from SQL Server (6)	Code Snippets	Vadivel Mohanakrishnan	18 Aug 2009
Tables' name with record count - SQL Server (2)	Code Snippets	Pandian S	17 Aug 2009
SQL User defined Function to remove leading zeros (4)	Code Snippets	Viji RAJKUMAR	14 Aug 2009
Import data directly from excel (5)	Code Snippets	Shivshanker Cheral	14 Aug 2009
Bulk Insert using XML Data - SQL Server	Code Snippets	srinath	13 Aug 2009
Copy a table and that content into another table	Code Snippets	Mohanakrishnan	12 Aug 2009

Next Results

Post Resource & Earn money, gifts and more...

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use