New posts in sql-server

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?

How to transform a MSSQL CTE query to MySQL?

SQL Server datetime LIKE select?

What happens to an uncommitted transaction when the connection is closed?

SQL Server sp_msforeachtable usage to select only those tables which meet some condition

Trying to only return distinct ID entries from a table where all values of a certain column must be matched

Select the next greatest value from a column

Change Notification with Sql Server 2008

There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key

Calling sp_start_job from a stored procedure

SQL Server 2008 default schema not being respected?

SQL Server: Top competitor with at least one full scoring submission

How to delete MSSQL database using sqlcmd

What is PAGEIOLATCH_SH wait type in SQL Server?

Need a datetime column in SQL Server that automatically updates when the record is modified

Constraint for only one record marked as default

SQL WHERE clause matching values with trailing spaces

SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

What is the difference between using a cross join and putting a comma between the two tables?

SqlBulkCopy Insert with Identity Column