Transact-SQL (TSQL) queries

new theme date 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 Prepare data for numerate logins exercise 2008-07-31 Create tally table in TSQL 2008-08-02 Create function that returns tally table of a given size 2011-01-09 Numerate logins records exercise 2008-07-31 Procedure that splits character string to words 2011-03-24 TSQL: Alter Table Name and Rename Column 2011-04-19 Record Numerator with ROW_NUMBER() OR Identity(1,1) 2011-05-02 Backup SQLserver database using TSQL 2011-09-10 Related themes:   TSQL/ASP     Spatial SQL   pages:   1    2

sqlexamples.info