Adding max(value)+1 in new row, can this be a problem?...

How can I insert a row for each day within a date range?...

Adding a column description...

SQL Join on Nearest less than date...

What is the best way to create and populate a numbers table?...

How to count number of records per month over a time period...

SQL server identity column values start at 0 instead of 1...

Can I search stored procedure results?...

How to determine total number of open/active connections in ms sql server 2005...

Measure the time it takes to execute a t-sql query...

SQL Transaction Error: The current transaction cannot be committed and cannot support operations tha...

Get all child records given a parent id in a self referencing table...

Is there a way to pause or wait for a few moments from within a script?...

SQL Server GUID sort algorithm. Why?...

SQL Subtract exactly a year...

SQL, How to Concatenate results?...

How to use DATEDIFF to return year, month and day?...

Insert multiple values by using Dynamic SQL from ASP.NET application...

Create GUID of Custom Format...

SQL Server: IN ('asd') not working when column is NTEXT...

Particular query causes ADO Recordset to fail with E_FAIL...

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio...

How to SELECT * INTO [tmp table] without declare table?...

SQL Server Agent Jobs: How to execute a job step without executing the entire job...

SQL update query using joins...

How to insert multiple records and get the identity value?...

Add empty row to query results if no results found...

How to set the default schema of a database in SQL Server 2005?...

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL...

Selecting most recent date between two columns...