Transact-SQL (TSQL) queries

views theme date Generate Sales reports using TSQL (1) 2006-07-15 Generate Sales reports using TSQL (2) 2006-07-15 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 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 Procedure with error handler (SQLserver 2000 syntax) 2007-04-28 Procedure with error handler (SQLserver 2005 syntax) 2007-04-28 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 Use TRUNCATE TABLE instead of DELETE 2005-10-07 How collation settings influence queries 2005-10-07 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 Insert random number to id column using Rand() function 2008-05-25 Query and update data distribution statistics. Part 1 2008-07-14 Prepare data for numerate logins exercise 2008-07-31 Numerate logins records exercise 2008-07-31 Related themes:   TSQL/ASP     Spatial SQL

sqlexamples.info