T-SQL: SUSER_ID

by Joe Hunter 9. March 2010 16:23

Found this function very useful today for uniquely naming tempDB tables based on users login:

SELECT SUSER_ID()

T-SQL: Updated extended property for a tableHandy piece of code for updating extended property for a table: Click here to download codeT-SQL: Check if database existsTo check if a database exists, use the DB_ID() function:IF db_id('AdventureWorks') IS NOT NULLPrint...T-SQL: Change column type ALTER TABLE MAIN ALTER COLUMN [natFileID] NVARCHAR(30) NULL ...