Add a column with a default value to an existing table in SQL Server

Add a column with a default value to an existing table in SQL Server

sql sql-server sql-server-2005 sql-server-2000

sql-server

Check if table exists in SQL Server

sql-server tsql sql-server-2005 sql-server-2000

sql-server

How to Join to first row

sql sql-server tsql sql-server-2000

sql-server

How do I generate a random number for each row in a T-SQL select?

sql-server tsql sql-server-2000

sql-server

Find index of last occurrence of a sub-string using T-SQL

sql-server string tsql search sql-server-2000

sql-server

How to get the first and last date of the current year?

sql sql-server sql-server-2000

sql-server

Is there a way to persist a variable across a go?

sql sql-server sql-server-2008 sql-server-2012 sql-server-2000

sql-server

Grant execute permission for a user on all stored procedures in database?

sql sql-server sql-server-2000

sql-server

Get structure of temp table (like generate sql script) and clear temp table for current instance

sql-server tsql sql-server-2000

sql-server

How to fix the embedded text qualifier issue while exporting data to CSV flat file?

sql-server ssis sql-server-2000 sql-server-2012

sql-server

SQL Server 2000: How to exit a stored procedure?

sql-server tsql stored-procedures sql-server-2000 control-flow

sql-server

How can I insert binary file data into a binary SQL field using a simple insert statement?

sql-server tsql sql-server-2000

sql-server

Get the time of a datetime using T-SQL?

sql-server tsql datetime sql-server-2000

sql-server

ORDER BY DATE showing NULLS first then most recent dates

sql-server sql-server-2000

sql-server

Is there a way to get a list of all current temporary tables in SQL Server?

sql sql-server sql-server-2000 temp-tables

sql-server