New posts in sql-server

How do I obtain a list of all schemas in a Sql Server database

Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)

Why "Begin Transaction" before "Insert Query" locks the entire table?

TransactSQL to run another TransactSQL script

How to detect if a string contains at least a number?

Handling date in SQL Server

Is there a way to not use square brackets in SQL Server?

Import and Export Wizard with Identity Column

TSQL DATETIME ISO 8601

How do I pass value to a stored procedure parameter in OLE DB Source component?

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

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

SQL Server IF EXISTS THEN 1 ELSE 2

Becoming a DBA, what do I need to know?

Transpose rows and columns with no aggregate

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

Invalid Column Name using Dynamic SQL

How to add xml encoding <?xml version="1.0" encoding="UTF-8"?> to xml Output in SQL Server

Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?

A way to extract from a DateTime value data without seconds