Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

How to add composite primary key to table

How to Replace Multiple Characters in SQL?

In MS SQL Server, is there a way to "atomically" increment a column being used as a counter?

SQL Join on Nearest less than date

How to change the primary key to be non-clustered?

Use SQL to filter the results of a stored procedure

Is too many Left Joins a code smell?

Select SQL results grouped by weeks

How do I increase the maximum allowed attachment size for email sent using msdb.dbo.sp_send_dbmail in Microsoft SQL Server 2005/2008

Incorrect syntax near the keyword 'with'...previous statement must be terminated with a semicolon

How can I get all the database names in a sql server instance using tsql?

sql-server-2005 tsql

Retrieving last record in each group from database - SQL Server 2005/2008

How to undo a SQL Server UPDATE query?

Cannot find the user '', because it does not exist or you do not have permission

IF UPDATE() in SQL server trigger

1 SET statement for multiple variables like declare statement

sql sql-server-2005

How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?

In SQL Server 2005, can I do a cascade delete without setting the property on my tables?

Is it possible to execute a text file from SQL query?

How to check that there is transaction that is not yet committed in SQL Server 2005?