home
Transact-SQL (TSQL) queries




pages:   1    2

Query that retrieves last invoice made by sales-person 2007-09-19
Update Join syntax in TSQL 2005-10-26
Find missing number using Left Outer Join 2007-10-05
Create primary and foreign keys 2009-09-17
Update calculated value using subquery 2007-10-18
Update calculated value using TEMP table 2007-10-18
Update calculated value using TABLE variable 2007-10-18
Update calculated value using indexed view 2007-10-18
Simple Scalar UDF (User Defined Function) 2007-09-11
Using UDF function inside JOIN 2007-10-02
Common Table Expressions (CTE) in TSQL 2007-10-02
Multiple Common Table Expressions 2007-11-04
Recursive retrieval of data using CTE 2007-11-04
Using CURSOR in stored procedure (1) 2006-01-18
Check string input for possible sql injection attempt 2005-11-19
Example of DELETE trigger 2005-03-28
Example of UPDATE trigger 2005-03-28
Calculate next birthday 2006-10-16
EXISTS operator 2005-03-28
User defined function that returns biggest of two numbers 2010-09-16
Query and update data distribution statistics. Part 1 2008-07-14
6 ideas than can help to improve Index efficiency 2012-12-09
Create tally table in TSQL 2008-08-02
Create function that returns tally table of a given size 2011-01-09
Using ROW_NUMBER() function with PARTITION BY 2012-03-19
Numerate logins records exercise 2008-07-31
Procedure that splits character string to words 2011-03-24
Backup SQLserver database using TSQL 2011-09-10
SQL 2012. Using Window Function for calculated column 2012-09-05
Remove duplicate values using PARTITION BY and CTE Query 2012-11-18
Load XML files to SQLServer table 2016-02-23
Manage unique token values using random numbers 2016-08-05

pages:   1    2

Related themes:
  TSQL/ASP  
  Spatial SQL  



sqlexamples.info