<< Finding code in SQL Server | SQL Search™ >>

T-SQL: Challenges

by Joe Hunter 21. May 2010 09:49

Been looking for something like this for a long time!Jacob Sebastian has put together a series of T-SQL challlenges for sql developers

Check them out here

Tags: t-sql

SQL Server

T-SQL: Check if database existsTo check if a database exists, use the DB_ID() function:IF db_id('AdventureWorks') IS NOT NULLPrint...T-SQL: SUSER_IDFound this function very useful today for uniquely naming tempDB tables based on users login: SELEC...T-SQL: Updated extended property for a tableHandy piece of code for updating extended property for a table: Click here to download code

T-SQL: Challenges

Advertisement

Tag cloud

Page List