All Tsql Solutions on Gang of Coders

Total of 620 Tsql Solutions

How can I remove duplicate rows?

Sql Server Tsql Duplicates

Check if table exists in SQL Server

Sql Server Tsql Sql Server-2005 Sql Server-2000

Altering a column: null to not null

Sql Server Tsql Null Alter Table Alter Column

SQL Server - Best way to get identity of inserted row?

Sql Sql Server Tsql

What is a stored procedure?

Sql Sql Server Tsql Stored Procedures

Fastest way to delete all the data in a large table

Sql Server Tsql

How do I sort a VARCHAR column in SQL server that contains numbers?

Using "GO" within a transaction

.Net Sql Sql Server Tsql Transactions

SQL Server equivalent to Oracle's NULLS FIRST?

Sql Sql Server Sql Server-2005 Tsql

SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?

Sql Server Tsql Sql Server-2008 User Defined-Functions User Defined-Types

SQL Server - How to lock a table until a stored procedure finishes

Sql Sql Server Tsql Stored Procedures Locking

How to retrieve records for last 30 minutes in MS SQL?

Sql Sql Server Tsql

Use transactions for select statements?

Sql Server Tsql Stored Procedures

How to include BIT type column in SELECT part with out including it on the GROUP BY in T-SQL?

Sql Tsql Group By Aggregate

Why SingleOrDefault result TOP(2) in SQL?

Entity Framework Tsql

SET versus SELECT when assigning variables?

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

Is there a way to SELECT and UPDATE rows at the same time?

Sql Sql Server Tsql Sql Server-2008

Get dates from a week number in T-SQL

Sql Server Tsql Date

Get the last day of the month in SQL

Sql Sql Server Tsql

C# SQL Top as parameter

Sql Sql Server Tsql ado.net

Alter user defined type in SQL Server

Sql Sql Server Tsql

Determine a table's primary key using TSQL

Sql Sql Server Tsql Primary Key

SQL - How do I get only the numbers after the decimal?

Sql Sql Server Tsql

Return value from exec(@sql)

Sql Sql Server Sql Server-2005 Tsql

Create Table from View

CROSS APPLY vs OUTER APPLY speed difference

Sql Sql Server Performance Tsql

Selecting a Record With MAX Value

Tsql Aggregate Functions

T-sql - determine if value is integer

Sql Server Tsql Casting Integer Isnumeric

How to calculate age in T-SQL with years, months, and days

Comparing two bitmasks in SQL to see if any of the bits match

Sql Sql Server Tsql Bitmask

SQL: Update a row and returning a column value with 1 query

C#Sql Server Tsql ado.net

SQL Server check case-sensitivity?

Sql Sql Server Tsql Case Sensitive

IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

Sql Sql Server Sql Server-2005 Tsql

What is the difference between ";" and "GO" in T-SQL?

Sql Sql Server Sql Server-2008 Tsql

How to check if a database exists in SQL Server?

Sql Server Database Tsql

Convert SQL Server result set into string

Sql Sql Server Sql Server-2005 Tsql

When should I not use a semicolon?

Set IDENTITY_INSERT ON is not working

Sql Server Sql Server-2008 Tsql

Time part of a DateTime Field in SQL

Sql Sql Server Sql Server-2008 Tsql Datetime

Format number as percent in MS SQL Server

Sql Server Tsql Percentage

Determine row size for table

Sql Server Tsql

SELECT DISTINCT on one column

Sql Server Tsql

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

Sql Sql Server Sql Server-2005 Tsql

Determine what user created objects in SQL Server

Sql Sql Server-2005 Tsql

SQL: Combine Select count(*) from multiple tables

Sql Sql Server Tsql

Unable to create index because of duplicate that doesn't exist?

Sql Server-2005 Tsql Indexing Unique Index

T-SQL How to select only Second row from a table?

Sql Server Tsql

What's the SQL national character (NCHAR) datatype really for?

Sql Sql Server Oracle Tsql Nvarchar

Is it possible to create a temporary table in a View and drop it after select?

Sql Server Tsql

T-SQL Conditional Order By

Sql Sql Server Tsql

how to get 2 digits after decimal point in tsql?

Sql Server Tsql Formatting

XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *'

T-SQL: Deleting all duplicate rows but keeping one

Sql Sql Server Tsql

NOT LIKE and LIKE not returning opposite result

Sql Sql Server Tsql Sql Like

When should you use full-text indexing?

Sql Sql Server Tsql Indexing Full Text-Search

How can I determine the status of a job?

Sql Sql Server-2005 Tsql Stored Procedures

Using comparison operators in SELECT clause of T-SQL query

Sql Sql Server Sql Server-2008 Tsql Comparison Operators

Get the unique constraint columns list (in TSQL)?

Sql Server Tsql Metadata Constraints

TSQL to Map User to Database

Sql Server Tsql

How can I INSERT data into two tables simultaneously in SQL Server?

Sql Sql Server Tsql Insert Foreign Keys

SELECT INTO USING UNION QUERY

Sql Sql Server Tsql Union Derived Table

Know relationships between all the tables of database in SQL Server

Sql Sql Server Database Tsql

Setting two scalar variables in one SELECT statement?

Sql Sql Server Tsql

What is the size of a image field content in SQL Server?

Sql Server Tsql Datalength

unable to drop and create database in sql server

Sql Sql Server-2008 Tsql

SQL Server SELECT INTO @variable?

Sql Sql Server Tsql Sql Server-2008

Turning a Comma Separated string into individual rows

Sql Server Csv Tsql Split

Return multiple values from a SQL Server function

Tsql User Defined-Functions

Using a cursor with dynamic SQL in a stored procedure

Tsql Stored Procedures Dynamic Sql Database Cursor

To add server using sp_addlinkedserver

Sql Server Tsql

Create a view with ORDER BY clause

Sql Server Database Tsql View Sql Server-2008-R2

T-SQL split string based on delimiter

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

Find a value anywhere in a database

Sql Server Tsql

How to get a date in YYYY-MM-DD format from a TSQL datetime field?

Sql Server Tsql

How do I move a table into a schema in T-SQL

Sql Server Sql Server-2008 Tsql Schema Sql Server-2016

How to return multiple values in one column (T-SQL)?

Sql Sql Server Sql Server-2005 Tsql

Counting the number of deleted rows in a SQL Server stored procedure

Sql Server Tsql Audit Sql Delete

Passing List<> to SQL Stored Procedure

C#Sql Sql Server Tsql Stored Procedures

Dynamic SQL results into temp table in SQL Stored procedure

Sql Server Tsql Dynamic Sql

Test Column exists, Add Column, and Update Column

Sql Server Tsql Ddl

How can I programmatically check (parse) the validity of a TSQL statement?

C#.Net Sql Server Tsql ado.net

How do I use T-SQL's Case/When?

T-SQL: Selecting Column Based on MAX(Other Column)

Sql Sql Server Tsql Greatest N-per-Group

Why do you create a View in a database?

Sql Sql Server Database Tsql

Counting DISTINCT over multiple columns

Sql Sql Server Performance Tsql Query Optimization

IF EXISTS in T-SQL

Sql Server Tsql Exists

How to get calendar Quarter from a date in TSQL

Sql Sql Server Tsql Sql Server-2005

Syntax of for-loop in SQL Server

Sql Sql Server Loops Tsql Syntax

EXEC sp_executesql with multiple parameters

Sql Server Tsql Stored Procedures Sp Executesql

Why do I get "A cursor with the name already exists"?

Sql Sql Server Tsql Database Cursor

Sort by minimum value of two columns

Sql Sql Server Tsql Sorting Min

Compare a date string to datetime in SQL Server?

Sql Server Database Tsql Datetime

SQL Server 2005: T-SQL to temporarily disable a trigger

Sql Server Sql Server-2005 Tsql

Insert row in table for each id in another table

Can I use multiple "with"?

Sql Tsql Sql Server-2008

SQL Server error on update command - "A severe error occurred on the current command"

Sql Server Sql Server-2005 Tsql

What are the differences between T-SQL, SQL Server and SQL

Sql Sql Server Tsql

SQL Server: Index columns used in like?

Sql Server Tsql Indexing

How do I compare two columns for equality in SQL Server?

Sql Sql Server Tsql

Is there an "IF EXISTS" test for a linked server?

Sql Server Tsql Linked Server

Duplicating a TABLE using Microsoft SQL Server Management

Sql Sql Server Tsql Ssms

Return row of every n'th record

Tsql Sql Server-2008

how to rename column name with T-SQL

Sql Server-2008 Tsql

Drop default constraint on a column in TSQL

Sql Sql Server Database Tsql

How to debug stored procedures with print statements?

Sql Server Tsql Stored Procedures

NULL values inside NOT IN clause

Sql Sql Server Tsql Null Notin

How to set multiple values inside an if else statement?

Sql Sql Server Tsql

How do I escape a single quote in SQL Server?

Sql Sql Server Tsql Delimiter Single Quotes

What are the use cases for selecting CHAR over VARCHAR in SQL?

Is there a way to loop through a table variable in TSQL without using a cursor?

Sql Server Tsql Loops

How can I escape square brackets in a LIKE clause?

Sql Server Tsql Escaping Character Sql Like

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

Sql Sql Server Tsql Sql Server-2008 Sql Server-2008-R2

Create a date from day month and year with T-SQL

Sql Sql Server Sql Server-2005 Tsql

How do I drop a foreign key constraint only if it exists in sql server?

Sql Sql Server Sql Server-2005 Tsql

Correct use of transactions in SQL Server

Sql Sql Server Database Tsql Transactions

Generate class from database table

C#Sql Sql Server Tsql

How can I group by date time column without taking time into consideration

Sql Sql Server Tsql Sql Server-2008

Check if a string contains a substring in SQL Server 2005, using a stored procedure

Sql Server String Tsql Stored Procedures Sql Server-2005

How do you return the column names of a table?

Sql Sql Server Tsql

Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?

Sql Sql Server Tsql Subquery Common Table-Expression

Need to list all triggers in SQL Server database with table name and table's schema

Sql Sql Server Database Tsql Triggers

Check if a row exists, otherwise insert

Sql Sql Server Sql Server-2008 Tsql

Function to Calculate Median in SQL Server

Sql Server Tsql Aggregate Functions Median

How to update Identity Column in SQL Server?

Sql Sql Server Tsql Sql Server-2008

How do I create a foreign key in SQL Server?

Sql Sql Server Tsql

When to use Common Table Expression (CTE)

Sql Sql Server Tsql Common Table-Expression

SQL RANK() versus ROW_NUMBER()

Sql Sql Server Tsql

When should I use semicolons in SQL Server?

Sql Server Tsql

How to write a foreach in SQL Server?

Sql Server Tsql

Why use a READ UNCOMMITTED isolation level?

Sql Server Tsql Isolation Level

How do I flush the PRINT buffer in TSQL?

Sql Server Tsql Printing

T-SQL CASE Clause: How to specify WHEN NULL

When should I use CROSS APPLY over INNER JOIN?

Sql Sql Server Performance Tsql Cross Apply

I want to use CASE statement to update some records in sql server 2005

Sql Sql Server Tsql Sql Update

How do I format a number with commas in T-SQL?

Sql Server Tsql

How do you view ALL text from an ntext or nvarchar(max) in SSMS?

Sql Server Sql Server-2008 Tsql Ssms

SQL Server dynamic PIVOT query?

Sql Sql Server Tsql Pivot

Use variable with TOP in select statement in SQL Server without making it dynamic

Sql Sql Server Sql Server-2005 Tsql

How to calculate percentage with a SQL statement

Sql Sql Server Tsql

How do I get list of all tables in a database using TSQL?

Sql Server Tsql Database Table

Convert Month Number to Month Name Function in SQL

Sql Sql Server Tsql Sql Server-2005

How can a LEFT OUTER JOIN return more records than exist in the left table?

Sql Sql Server Sql Server-2005 Tsql

How to update two tables in one statement in SQL Server 2005?

Sql Sql Server Sql Server-2005 Tsql

SQL: IF clause within WHERE clause

Sql Sql Server Tsql

Extracting hours from a DateTime (SQL Server 2005)

Sql Tsql Datetime Sql Server-2005 Hour

Changing the maximum length of a varchar column?

Sql Sql Server Sql Server-2008 Tsql Varchar

How to wait for 2 seconds?

Sql Server Sql Server-2008 Tsql

How to get Time from DateTime format in SQL?

Sql Server Tsql Sql Server-2005 Datetime

Recover unsaved SQL query scripts

Sql Sql Server Tsql Sql Server-2012 Ssms

SQL variable to hold list of integers

Sql Server List Tsql Variables Reporting Services

How do I drop a foreign key in SQL Server?

Sql Server Tsql

Creating an index on a table variable

Sql Sql Server Tsql Indexing Table Variable

Exclude a column using SELECT * [except columnA] FROM tableA?

Sql Sql Server Tsql

Function vs. Stored Procedure in SQL Server

Sql Sql Server Tsql Stored Procedures Sql Function

Change Schema Name Of Table In SQL

Sql Sql Server Tsql Schema

How do you truncate all tables in a database using TSQL?

Sql Server Tsql

Hidden Features of SQL Server

Sql Server Tsql

How to drop SQL default constraint without knowing its name?

Sql Sql Server Tsql

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

Sql Sql Server Tsql Exists

Getting the minimum of two values in SQL

Tsql Sql Server

Referring to a Column Alias in a WHERE Clause

Sql Sql Server Tsql Sql Server-2005

Truncate (not round) decimal places in SQL Server

Sql Sql Server Tsql Rounding

Update a table using JOIN in SQL Server?

Sql Server Tsql Join Sql Update

Most efficient T-SQL way to pad a varchar on the left to a certain length?

Sql Sql Server Tsql

How do I escape a percentage sign in T-SQL?

Sql Server Tsql

is it possible to select EXISTS directly as a bit?

Sql Sql Server Tsql

In SQL, how can you "group by" in ranges?

Sql Sql Server Tsql

How to calculate age (in years) based on Date of Birth and getDate()

Sql Sql Server Tsql

Can you create nested WITH clauses for Common Table Expressions?

Sql Sql Server Tsql Nested Common Table-Expression

How to group time by hour or by 10 minutes

Sql Sql Server-2008 Tsql Group By

Sql Server string to date conversion

Sql Server Tsql Datetime Sql Server-2005 String to-Datetime

Multi-statement Table Valued Function vs Inline Table Valued Function

Sql Sql Server Sql Server-2008 Tsql User Defined-Functions

How can I get column names from a table in SQL Server?

Sql Sql Server Sql Server-2008 Tsql

How can foreign key constraints be temporarily disabled using T-SQL?

Sql Server Tsql Foreign Keys Constraints

How can I list all foreign keys referencing a given table in SQL Server?

Sql Sql Server Tsql

How to Join to first row

Sql Sql Server Tsql Sql Server-2000

How important is the order of columns in indexes?

Sql Sql Server Sql Server-2005 Tsql Indexing

SQL Server String or binary data would be truncated

Sql Server Tsql Sql Server-2005 Migration Data Migration

SQL JOIN vs IN performance?

Sql Sql Server Performance Tsql

Keeping it simple and how to do multiple CTE in a query

Sql Server Tsql Common Table-Expression

Is SQL or even TSQL Turing Complete?

Sql Tsql Programming Languages Language Features

Alter column, add default constraint

Sql Server Sql Server-2008 Tsql Alter Table Alter Column

How do I remove the first characters of a specific column in a table?

Sql Sql Server String Tsql

How do I UPDATE from a SELECT in SQL Server?

Sql Sql Server Tsql Select Sql Update

Should I use != or <> for not equal in T-SQL?

Sql Sql Server Tsql

A table name as a variable

Sql Sql Server Tsql Variable Names Tablename

How to get sp_executesql result into a variable?

Tsql Dynamic Sql

How can I use optional parameters in a T-SQL stored procedure?

Tsql Optional Parameters

DateTime2 vs DateTime in SQL Server

Sql Sql Server Tsql Datetime Datetime2

How to check existence of user-define table type in SQL Server 2008?

Sql Sql Server Sql Server-2008 Tsql User Defined-Types

How to ALTER multiple columns at once in SQL Server

Sql Server Tsql Alter Column

Insert Update trigger how to determine if insert or update

Sql Server Tsql Triggers

Count work days between two dates

Combining INSERT INTO and WITH/CTE

Tsql Insert Common Table-Expression

How to drop a table if it exists?

Sql Server Tsql

CROSS JOIN vs INNER JOIN in SQL

Sql Sql Server Sql Server-2008 Tsql Cross Join

Better techniques for trimming leading zeros in SQL Server?

Sql Sql Server Sql Server-2005 Tsql String

Getting only Month and Year from SQL DATE

Sql Sql Server Tsql

How to generate a range of numbers between two numbers?

Sql Sql Server Tsql Sql Server-2008

Calculate a Running Total in SQL Server

Sql Sql Server Tsql Cumulative Sum

How do I escape double quotes in attributes in an XML String in T-SQL?

Xml Tsql Escaping

Difference between CTE and SubQuery?

Sql Sql Server Tsql Subquery Common Table-Expression

IndexOf function in T-SQL

Sql Sql Server Tsql String

Pass Array Parameter in SqlCommand

T-SQL - function with default parameters

Tsql Function Default Parameters

Remove the last character in a string in T-SQL?

Sql Sql Server Tsql

How do I make a composite key with SQL Server Management Studio?

Sql Sql Server Tsql Ssms Key

Count number of records returned by group by

Sql Server Tsql Count Group By

SQL update query using joins

Sql Sql Server Tsql Sql Server-2005 Sql Update

Imply bit with constant 1 or 0 in SQL Server

Sql Sql Server Tsql Bit

GRANT EXECUTE to all stored procedures

Sql Sql Server Tsql Sql Server-2008 Permissions

T-SQL split string

Sql Sql Server Tsql Sql Server-2008 Split

SQL "between" not inclusive

Sql Sql Server Sql Server-2008 Tsql Date

Compare DATETIME and DATE ignoring time portion

Sql Sql Server Tsql Sql Server-2008 Datetime Conversion

How to identify all stored procedures referring a particular table

Sql Tsql Sql Server-2005

How do you count the number of occurrences of a certain substring in a SQL varchar?

Sql Server Tsql

TSQL Pivot without aggregate function

Sql Sql Server Tsql Pivot Pivot without-Aggregate

Define variable to use with IN operator (T-SQL)

Linq to Sql: Multiple left outer joins

vb.net Linq Linq to-Sql Tsql Left Join

SQL Server equivalent to MySQL enum data type?

Sql Sql Server Tsql Sql Server-2008 Types

How do I create a unique constraint that also allows nulls?

Sql Server Tsql

How to change identity column values programmatically?

Sql Server Sql Server-2005 Tsql Identity Sql Server-2005-Express

How to report an error from a SQL Server user-defined function

Sql Sql Server Tsql Sql Server-2008 User Defined-Functions

WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT

Sql Sql Server Tsql Check Constraints

What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?

Sql Server Database Tsql Collation

SQL "select where not in subquery" returns no results

Sql Sql Server Tsql

Reference alias (calculated in SELECT) in WHERE clause

Sql Sql Server Tsql

Remove Identity from a column in a table

Sql Sql Server Tsql

Alter Table Add Column Syntax

Sql Sql Server Tsql Ddl

What is SYSNAME data type in SQL Server?

Sql Sql Server Tsql Types

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

Sql Server String Tsql Search Sql Server-2000

Get top 1 row of each group

Sql Sql Server Tsql Sql Server-2005 Greatest N-per-Group

Incorrect syntax near ')' calling stored procedure with GETDATE

Sql Server Tsql Getdate

SQL Server Output Clause into a scalar variable

Sql Server Tsql

SQL Server : Columns to Rows

Sql Sql Server Tsql Unpivot

Differences between MySQL and SQL Server

Mysql Sql Server Tsql

Check if table exists and if it doesn't exist, create it in SQL Server 2008

Sql Sql Server Tsql Sql Server-2008-R2

T-SQL stored procedure that accepts multiple Id values

Sql Server Tsql Stored Procedures

SQL : BETWEEN vs <= and >=

Sql Sql Server Tsql Where Between

Formatting Numbers by padding with leading zeros in SQL Server

Sql Sql Server Tsql String Formatting

INSERT INTO vs SELECT INTO

Sql Server Tsql Sql Server-2008

How do you copy a record in a SQL table but swap out the unique id of the new row?

Sql Sql Server Sql Server-2005 Tsql

What does collation mean?

Sql Sql Server-2005 Tsql Mysql

How to count instances of character in SQL Column

Sql String Tsql Count Symbols

How can I convert bigint (UNIX timestamp) to datetime in SQL Server?

Sql Sql Server Tsql Datetime Unix Timestamp

How to select all records from one table that do not exist in another table?

Sql Sql Server Tsql

SQL Server - Create a copy of a database table and place it in the same database?

Sql Sql Server-2008 Tsql Sql Server-2008-R2

Unpivot with column name

Sql Sql Server Sql Server-2008 Tsql Unpivot

T-SQL: Opposite to string concatenation - how to split string into multiple records

Sql Server Sql Server-2005 Tsql

What is a "batch", and why is GO used?

Base64 encoding in SQL Server 2005 T-SQL

Sql Server-2005 Tsql Encoding Base64

Split function equivalent in T-SQL?

Sql Sql Server Tsql Sql Server-2008

Can I create a One-Time-Use Function in a Script or Stored Procedure?

Sql Sql Server Sql Server-2005 Tsql Scripting

Is there a ternary conditional operator in T-SQL?

Sql Server Tsql

SQL Server ':setvar' Error

Sql Sql Server Tsql

Dynamic Sorting within SQL Stored Procedures

Sql Tsql Stored Procedures Sorting

SQL Server Regular expressions in T-SQL

Sql Server Regex Tsql

Getting result of dynamic SQL into a variable for sql-server

Sql Sql Server Sql Server-2005 Tsql Dynamic Sql

Delete all the records

Tsql Sql Server-2008 Sql Delete Sql Truncate

Best way to work with transactions in MS SQL Server Management Studio

Sql Tsql Transactions

How much size "Null" value takes in SQL Server

Sql Server Tsql Sql Server-2005 Null

SQL Server: Maximum character length of object names

Sql Server Sql Server-2008 Tsql

How do I find a default constraint using INFORMATION_SCHEMA?

Sql Sql Server Tsql Information Schema

Is the NOLOCK (Sql Server hint) bad practice?

Sql Sql Server Tsql Sql Server-2008 Nolock

PadLeft function in T-SQL

SQL Server: Examples of PIVOTing String data

Sql Server Tsql Pivot

How do you check what version of SQL Server for a database using TSQL?

Sql Server Database Tsql

How do I delete from multiple tables using INNER JOIN in SQL server

Sql Sql Server Tsql

IDENTITY_INSERT is set to OFF - How to turn it ON?

Sql Sql Server Tsql

How to select only the first rows for each unique value of a column?

Sql Sql Server Tsql Select Unique

SQL Server 2008: How to query all databases sizes?

Sql Sql Server Tsql Sql Server-2008-R2

What is the Oracle equivalent of SQL Server's IsNull() function?

Sql Server Oracle Tsql Plsql

T-SQL query to show table definition?

Sql Server Tsql

How to truncate string using SQL server

Sql Server Tsql

OR is not supported with CASE Statement in SQL Server

Sql Sql Server Tsql Case Case When

How to assign an exec result to a sql variable?

Sql Sql Server Tsql Stored Procedures

Avoid duplicates in INSERT INTO SELECT query in SQL Server

Sql Sql Server Tsql Sql Insert

Parse JSON in TSQL

Sql Server Tsql Json

Simple way to transpose columns and rows in SQL?

Sql Sql Server Tsql Pivot

How do you list the primary key of a SQL Server table?

Sql Sql Server Tsql

Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

Sql Server Tsql Sql Server-2005 Insert

How to print VARCHAR(MAX) using Print Statement?

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

Multiple INSERT statements vs. single INSERT with multiple VALUES

Sql Sql Server Performance Sql Server-2008 Tsql

T-SQL datetime rounded to nearest minute and nearest hours with using functions

Sql Sql Server Tsql Sql Server-2008

TSQL - Cast string to integer or return default value

Datatype for storing ip address in SQL Server

Sql Server Tsql Sql Server-2005 Types Ip Address

Is having an 'OR' in an INNER JOIN condition a bad idea?

Sql Sql Server Sql Server-2008 Tsql Inner Join

Replace duplicate spaces with a single space in T-SQL

Sql Server Tsql

Best approach to remove time part of datetime in SQL Server

Sql Sql Server Tsql Datetime Date

varbinary to string on SQL Server

Sql Sql Server Sql Server-2005 Tsql

SQL Server: Get data for only the past year

Sql Sql Server Database Tsql

How To Create Table with Identity Column

Sql Sql Server Tsql

How to take last four characters from a varchar?

Sql Sql Server-2008 Tsql

Use of Begin / End Blocks and the Go keyword in SQL Server?

Sql Server Tsql Language Features

Which SQL query is faster? Filter on Join criteria or Where clause?

Sql Sql Server Tsql Sql Server-2008

Generate MD5 hash string with T-SQL

Sql Server Tsql Sql Server-2008

How to Concatenate Numbers and Strings to Format Numbers in T-SQL?

Return rows in random order

Sql Sql Server Tsql

unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

Sql Sql Server Tsql Sql Server-Data-Tools

alternatives to REPLACE on a text or ntext datatype

Sql Sql Server Tsql

How to force a SQL Server 2008 database to go Offline

Sql Sql Server Tsql Sql Server-2008

Export database schema into SQL file

Sql Sql Server Database Tsql Export

How to group by month from Date field using sql

Sql Sql Server Tsql

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

Sql Server Sql Server-2005 Tsql Truncate Foreign Keys

Generating random strings with T-SQL

Sql Tsql Random

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Sql Server Tsql Datetime

Aggregate function in an SQL update query?

Sql Sql Server Tsql

Return a value if no rows are found in Microsoft tSQL

Add Foreign Key relationship between two Databases

Sql Sql Server Tsql Foreign Keys

Is there StartsWith or Contains in t sql with variables?

Sql Sql Server-2008 Tsql

COALESCE Function in TSQL

Sql Sql Server Sql Server-2008 Tsql

sql primary key and index

Sql Sql Server Tsql Indexing Primary Key

Partition Function COUNT() OVER possible using DISTINCT

Sql Sql Server Tsql Sql Server-2008-R2 Sql Server-2014

How do you determine what SQL Tables have an identity column programmatically

Sql Server Tsql Metadata Identity Column

Replace Default Null Values Returned From Left Outer Join

Mysql Sql Sql Server Tsql Sql Server-2008

How do I use the CONCAT function in SQL Server 2008 R2?

Sql Server Sql Server-2008 Tsql

Current executing procedure name

Sql Server Sql Server-2008 Tsql Stored Procedures

Selecting COUNT(*) with DISTINCT

Sql Sql Server Sql Server-2005 Tsql

T-SQL: Selecting rows to delete via joins

What is the significance of 1/1/1753 in SQL Server?

Sql Server Tsql Datetime Localization Internationalization

Using RegEx in SQL Server

Sql Server Regex Sql Server-2008 Tsql

How do I drop a function if it already exists?

Tsql Sql Server-2000

How do I split a string so I can access item x?

Sql Sql Server Tsql Split

In SQL Server, what does "SET ANSI_NULLS ON" mean?

Sql Tsql Stored Procedures

How to convert a datetime to string in T-SQL

Sql Server Tsql

How to get current instance name from T-SQL

Sql Sql Server Tsql Sql Server-2008r2-Express

What is the maximum number of characters that nvarchar(MAX) will hold?

Sql Server Tsql

Storing DateTime (UTC) vs. storing DateTimeOffset

Sql Sql Server Tsql Sql Server-2008 Datetimeoffset

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

Sql Sql Server Tsql Sql Server-2008 Full Text-Search

TSQL - How to use GO inside of a BEGIN .. END block?

Sql Sql Server Tsql Sql Server-2008

A strange operation problem in SQL Server: -100/-100*10 = 0

Sql Sql Server Tsql Operator Precedence

Removing leading zeroes from a field in a SQL statement

Sql Sql Server Tsql

What is PAGEIOLATCH_SH wait type in SQL Server?

Sql Server Tsql Optimization

Declaring a default constraint when creating a table

Tsql Sql Server-2000 Default Constraints

Pad a string with leading zeros so it's 3 characters long in SQL Server 2008

Sql Server Tsql

Cannot execute script: Insufficient memory to continue the execution of the program

Sql Tsql Sql Server-2012

INSERT vs INSERT INTO

Sql Sql Server Tsql

Get first day of week in SQL Server

Sql Server Tsql Sql Server-2008 Date

Calculating distance between two points (Latitude, Longitude)

Sql Sql Server Tsql Math Sql Server-2008-R2

Is it possible to specify condition in Count()?

Sql Sql Server Tsql

What's the best way to select the minimum value from several columns?

Sql Sql Server Tsql Sql Server-2005 Min

SQL Row_Number() function in Where Clause

Sql Sql Server Tsql Analytic Functions

Maximum size for a SQL Server Query? IN clause? Is there a Better Approach

Sql Sql Server Tsql Limits

Delete duplicate records in SQL Server?

Sql Tsql Duplicates Delete Row

How can I have multiple common table expressions in a single SELECT statement?

Sql Sql Server Sql Server-2008 Tsql Common Table-Expression

SQL Server table creation date query

Sql Sql Server Tsql Sql Server-2005

Remove trailing zeros from decimal in SQL Server

Sql Tsql Sql Server-2008 Formatting Decimal

MS SQL compare dates?

Sql Server Tsql Sql Server-2008 Date

How to check if a column exists in a SQL Server table

Sql Server Sql Server-2008 Tsql Sql Server-2012 Sql Server-2016

How to return only the Date from a SQL Server DateTime datatype

Sql Sql Server Tsql Date Datetime

Listing information about all database files in SQL Server

Sql Server Sql Server-2008 Tsql Database Management

How do I fetch multiple columns for use in a cursor loop?

Tsql Sql Server-2005

String.Format like functionality in T-SQL?

Search for one value in any column of any table inside a database

Convert multiple rows into one with comma as separator

Confused about UPDLOCK, HOLDLOCK

Sql Server Tsql Sql Server-2008 Concurrency Locking

T-SQL: Looping through an array of known values

Sql Sql Server Tsql

WHERE clause on SQL Server "Text" data type

Sql Server Sql Server-2005 Tsql

Printing integer variable and string on same line in SQL

Sql Sql Server Tsql

Is there a way to make a TSQL variable constant?

Sql Server Tsql

T-SQL get SELECTed value of stored procedure

Tsql Stored Procedures Select

Declare Variable for a Query String

Sql Sql Server Sql Server-2005 Tsql Dynamic Sql

Levenshtein distance in T-SQL

Tsql Edit Distance Levenshtein Distance

How to convert Seconds to HH:MM:SS using T-SQL

Select columns from result set of stored procedure

Sql Server Tsql Select Stored Procedures

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

Sql Sql Server Tsql Dynamic Sql

T-SQL and the WHERE LIKE %Parameter% clause

Sql Sql Server-2008 Tsql

Equivalent of Oracle's RowID in SQL Server

Sql Sql Server Tsql Rowid Row Number

is there an advantage to varchar(500) over varchar(8000)?

Sql Sql Server Tsql

How to rethrow the same exception in SQL Server

Sql Sql Server Database Tsql Exception

Applying the MIN aggregate function to a BIT field

Sql Sql Server Tsql

Maximum size of a varchar(max) variable

Sql Server Tsql

Replace a newline in TSQL

Update query using Subquery in Sql Server

Sql Sql Server Tsql Sql Update

How to calculate difference in hours (decimal) between two dates in SQL Server?

Sql Server Tsql Datetime Decimal

SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

Sql Sql Server Tsql

How to insert default values in SQL table?

SQL Server: What are batching statements (i.e. using "GO") good for?

Sql Server Tsql

SQL MAX of multiple columns?

Sql Sql Server Tsql

how can I Update top 100 records in sql server

Sql Sql Server Tsql Sql Update

Random record from a database table (T-SQL)

Sql Server Tsql Random

Sequence vs identity

Sql Sql Server Tsql Sql Server-2012

Why does Sql Server keep executing after raiserror when xact_abort is on?

Sql Sql Server Tsql

Getting list of tables, and fields in each, in a database

Subquery using Exists 1 or Exists *

Sql Sql Server Tsql

Database Naming Conventions by Microsoft?

Sql Sql Server Tsql

T-SQL string replace in Update

String Tsql Replace

FULL OUTER JOIN vs. FULL JOIN

Sql Sql Server-2008 Tsql Join

How can I get the number of records affected by a stored procedure?

Sql Sql Server Oracle Tsql Plsql

TSQL: How to convert local time to UTC? (SQL Server 2008)

Sql Server Tsql Sql Server-2008 Timezone Utc

Get the records of last month in SQL server

Sql Sql Server Tsql

SQL Server ORDER BY date and nulls last

Sql Server Sql Server-2005 Tsql

Simple DateTime sql query

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

What is the meaning of the prefix N in T-SQL statements and when should I use it?

Sql Sql Server Tsql

Understanding SQL Server LOCKS on SELECT queries

Sql Server Tsql Linq to-Sql

Understanding PIVOT function in T-SQL

Sql Server Sql Server-2008 Tsql Pivot

Why use Select Top 100 Percent?

Sql Sql Server Tsql

How to parse string into date?

Tsql Sql Server-2005

How to compare datetime with only date in SQL Server

Sql Sql Server Tsql Datetime

What is the use of GO in SQL Server Management Studio & Transact SQL?

Sql Server Tsql Ssms

Generate SQL Create Scripts for existing tables with Query

Sql Sql Server Tsql

How do you update a DateTime field in T-SQL?

Sql Sql Server Tsql Types

Do clustered indexes have to be unique?

Sql Database Tsql Sql Server-2008 Clustered Index

How to view the stored procedure code in SQL Server Management Studio

Sql Server Tsql Ssms

T-SQL loop over query results

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

Sql Server Tsql Left Join Outer Join

Inserting multiple rows in a single SQL query?

Sql Sql Server Tsql Insert

Use of SqlParameter in SQL LIKE clause not working

C#Sql Server Tsql ado.net Sql Like

Perform insert for each row taken from a select?

Sql Sql Server-2008 Tsql Insert

SQL Server 2008 Empty String vs. Space

Sql Server Sql Server-2008 Tsql String Length Datalength

SELECT FOR UPDATE with SQL Server

Sql Sql Server Sql Server-2005 Tsql Read Committed-Snapshot

Can you explain the use of sys.sp_addextendedproperty in the following code?

Sql Server Tsql Sql Server-2008 Extended Properties

Why not use varchar(max)?

Sql Tsql Sql Server-2008 Varcharmax

Select query to remove non-numeric characters

Tsql Sql Server-2008-R2 Substring Patindex

Combine multiple results in a subquery into a single comma-separated value

Sql Server Tsql Join

Boolean 'NOT' in T-SQL not working on 'bit' datatype?

Sql Sql Server Tsql Boolean Operations

SQL Server SELECT into existing table

Sql Sql Server Tsql Stored Procedures

Command for adding a default constraint

Sql Sql Server Tsql Default Constraint

How do I get just the date when using MSSQL GetDate()?

Sql Sql Server Tsql Date Datetime

Does T-SQL have an aggregate function to concatenate strings?

Sql Server Sql Server-2005 Tsql Group By Aggregate Functions

SQL Views - no variables?

Convert a SQL Server datetime to a shorter date format

Sql Server Tsql Datetime

ORDER BY items must appear in the select list if SELECT DISTINCT is specified

Sql Sql Server Tsql

How to compare values which may both be null in T-SQL

Sql Sql Server Tsql Stored Procedures

SQL Server: Difference between PARTITION BY and GROUP BY

Sql Server Tsql Aggregate Functions Window Functions

Get Multiple Values in SQL Server Cursor

Sql Sql Server Tsql Database Cursor

Escape a string in SQL Server so that it is safe to use in LIKE expression

Sql Server Tsql Stored Procedures Sql Like

What should be the best way to store a percent value in SQL-Server?

Sql Sql Server Tsql Types

Inserting rows into a table with one IDENTITY column only

Sql Sql Server Tsql Stored Procedures

How to set a default value for an existing column

Sql Server Sql Server-2008 Tsql Default Value

Select statement to find duplicates on certain fields

Sql Sql Server Tsql Sql Server-2008

select unique rows based on single distinct column

Sql Server Tsql

Why is 199.96 - 0 = 200 in SQL?

Sql Server Tsql Precision Sql Server-2016 Sqldatatypes

SELECT INTO a table variable in T-SQL

Sql Server Tsql Insert Table Variable

Select a Column in SQL not in Group By

Sql Sql Server-2008 Tsql Greatest N-per-Group

PRINT statement in T-SQL

Sql Server Tsql

What is the T-SQL To grant read and write access to tables in a database in SQL Server?

Sql Server Tsql

How do I return the SQL data types from my query?

Sql Sql Server Tsql Sql Server-2008

Index Key Column VS Index Included Column

Sql Server-2005 Tsql

remove duplicates from sql union

How can I include null values in a MIN or MAX?

Sql Sql Server Tsql

How to assign a select result to a variable?

Tsql Database Cursor

Create a SQL query to retrieve most recent records

Sql Tsql Derived Table

How to find column names for all tables in all databases in SQL Server

Sql Sql Server Tsql Database Schema

Can I add a not null column without DEFAULT value

Sql Sql Server Sql Server-2005 Tsql

Add column to table and then update it inside transaction

Sql Sql Server Tsql Transactions Alter Table

TABLOCK vs TABLOCKX

Sql Server Tsql

Is there a combination of "LIKE" and "IN" in SQL?

Sql Sql Server Oracle Tsql Plsql

How do I perform a GROUP BY on an aliased column in SQL Server?

Sql Sql Server Tsql Syntax

How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

Sql Server-2005 Tsql Collation

Should every SQL Server foreign key have a matching index?

Sql Sql Server Tsql

How to do SQL Like % in Linq?

.Net Linq Tsql Linq to-Entities Sql Like

Using ISNULL vs using COALESCE for checking a specific condition?

Sql Tsql Coalesce Isnull

Is varchar(MAX) always preferable?

Sql Sql Server Tsql

Update records in table from CTE

Sql Sql Server Tsql Common Table-Expression

How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?

Sql Server Security Tsql Sql Injection Sanitization

Comma separated results in SQL

Sql Server Sql Server-2008 Tsql

Determine SQL Server Database Size

Sql Server Tsql

Add row to query result using select

Sql Sql Server Tsql Select Insert

Fuzzy matching using T-SQL

Sql Server Tsql Fuzzy Search

How to flip bit fields in T-SQL?

Sql Sql Server Tsql

Selecting data from two different servers in SQL Server

Sql Sql Server Tsql

SQL Server Invalid Column name after adding new column

Sql Sql Server Sql Server-2008 Tsql Sql Server-2005

Insert results of a stored procedure into a temporary table

Sql Sql Server Sql Server-2005 Tsql Stored Procedures

How do I perform an IF...THEN in an SQL SELECT?

Sql Sql Server Tsql If Statement Case

Insert multiple values using INSERT INTO (SQL Server 2005)

Sql Sql Server Sql Server-2005 Tsql

How to drop all stored procedures at once in SQL Server database?

Sql Sql Server Tsql

SQL Server: combining multiple rows into one row

Sql Server Sql Server-2008 Tsql

How to use RANK() in SQL Server

Sql Server Tsql

Conditional WHERE clause in SQL Server

Sql Sql Server Sql Server-2008 Tsql Where Clause

Truncate/Clear table variable in SQL Server 2008

Sql Sql Server Tsql

Most efficient way in SQL Server to get date from date+time?

Sql Sql Server Tsql

TSQL How do you output PRINT in a user defined function?

Tsql User Defined-Functions

What do you do in SQL Server to CREATE OR ALTER?

Sql Sql Server Tsql

SQL Server PRINT SELECT (Print a select query result)?

Sql Server Tsql Select Query

Only inserting a row if it's not already there

Sql Sql Server Tsql Concurrency Locking

Why can't I use "create schema" in a begin/end block in SQL Management Studio?

Sql Sql Server Tsql

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

Sql Server Tsql Sql Server-2000

Select a column if other column is null

Sql Sql Server Tsql

SQL query, if value is null then return 1

Sleep Command in T-SQL?

Sql Server Tsql Asynchronous Sleep

Floor a date in SQL server

Sql Server Tsql

Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE

Mysql Sql Server Tsql

T-SQL Substring - Last 3 Characters

Sql Sql Server Sql Server-2005 Tsql

Get 2 Digit Number For The Month

Sql Sql Server Sql Server-2008 Tsql

How to set variable from a SQL query?

Sql Sql Server Tsql

SQL Server 2000: How to exit a stored procedure?

Sql Server Tsql Stored Procedures Sql Server-2000 Control Flow

Why is RAISERROR misspelled? Or is it not?

TransactSQL to run another TransactSQL script

Sql Sql Server Tsql Sql Server-2008

Understanding the differences between CUBE and ROLLUP

Sql Sql Server Sql Server-2008 Tsql

List of all index & index columns in SQL Server DB

Sql Server Tsql Indexing Reverse Engineering

What is the difference between SQL, PL-SQL and T-SQL?

TSQL DATETIME ISO 8601

Sql Sql Server Tsql Datetime

How to escape underscore character in PATINDEX pattern argument?

Sql Server Regex Tsql Escaping Sql Like

Limit on the WHERE col IN (...) condition

Sql Sql Server Tsql

Can I loop through a table variable in T-SQL?

Sql Sql Server Tsql Database Cursor Table Variable

Syntax for INSERTing into a table with no values?

Sql Sql Server Tsql Insert

What is the equivalent of 'describe table' in SQL Server?

Sql Sql Server Tsql

How can I select the first day of a month in SQL?

Sql Sql Server Tsql Sql Server-2008 Datetime

How to execute Table valued function

Sql Sql Server Sql Server-2008 Tsql

T-SQL: How to Select Values in Value List that are NOT IN the Table?

Sql Sql Server Tsql

SQL Query with NOT LIKE IN

Sql Sql Server-2008 Tsql

How to send email from SQL Server?

Sql Sql Server Tsql Sp Send-Dbmail

Query to list all stored procedures

Sql Server Tsql

How do you change the datatype of a column in SQL Server?

Sql Server Tsql Type Conversion Alter Table

SQL query to select dates between two dates

Sql Sql Server Tsql Datetime Sql Server-2005

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

Sql Server Tsql Sql Server-2000

Can I Comma Delimit Multiple Rows Into One Column?

Sql Sql Server Sql Server-2008 Tsql

Rename SQL Azure database?

Tsql Azure Azure Sql-Database Rename

SQL MERGE statement to update data

Sql Server-2008 Tsql

SQL Left Join first match only

Sql Sql Server Tsql Join Greatest N-per-Group

T-SQL Throw Exception

Sql Server Tsql Throw

SQL Server replace, remove all after certain character

Sql Sql Server Tsql Replace

SQL Server remove milliseconds from datetime

Sql Server Tsql

What's the right way to compare an NTEXT column with a constant value?

Sql Sql Server Tsql Ntext

Find non-ASCII characters in varchar columns using SQL Server

Sql Server Tsql Sql Server-2005 Non Ascii-Characters

How do I find a stored procedure containing <text>?

Sql Server Sql Server-2008 Tsql Stored Procedures

TRIM is not a recognized built-in function name

Sql Sql Server Tsql

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

Sql Server Tsql Sql Server-2000

How do you drop a default value or similar constraint in T-SQL?

Sql Tsql Constraints Default

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

Sql Sql Server Tsql

Get the time of a datetime using T-SQL?

Sql Server Tsql Datetime Sql Server-2000

Update rows from another table

How to return a incremental group number per group in SQL

Sql Sql Server Tsql Group By

how to know status of currently running jobs

Sql Server Sql Server-2008 Tsql Sql Agent

ROW_NUMBER Without ORDER BY

Sql Sql Server Tsql Window Functions

Passing a varchar full of comma delimited values to a SQL Server IN function

Sql Sql Server Tsql Sql In

Concatenating Column Values into a Comma-Separated List

Sql Server Tsql

Get size of all tables in database

Sql Server Tsql

Find all tables containing column with specified name - MS SQL Server

Sql Sql Server Tsql System Tables

How can I do an UPDATE statement with JOIN in SQL Server?

Sql Sql Server Tsql Sql Server-2005 Sql Update

What represents a double in sql server?

C#Sql Sql Server Sql Server-2005 Tsql

Compare dates in T-SQL, ignoring the time part

Sql Sql Server Sql Server-2005 Tsql

CTE error: "Types don't match between the anchor and the recursive part"

Sql Sql Server Tsql Common Table-Expression

Can an INNER JOIN offer better performance than EXISTS

Sql Sql Server Sql Server-2005 Performance Tsql

Remove certain characters from a string

Sql Server Tsql

Search and replace part of string in database

Sql Sql Server Tsql

How do you drop a default value from a column in a table?

Sql Server-2005 Tsql

Convert varchar into datetime in SQL Server

Sql Sql Server Sql Server-2008 Tsql Type Conversion

How do I exclude Weekend days in a SQL Server query?

Sql Server Tsql Date Weekend

How do you add a computed column to a Table?

How do I get the month and day with leading 0's in SQL? (e.g. 9 => 09)

Temporary table in SQL server causing ' There is already an object named' error

Sql Sql Server Tsql Temp Tables

How can I change NULL to 0 when getting a single value from a SQL function?

Sql Tsql Null Sum

T-SQL Cast versus Convert

Sql Sql Server Database Tsql

How do I obtain a Query Execution Plan in SQL Server?

Sql Sql Server Performance Tsql Sql Execution-Plan

How to set value to variable using 'execute' in t-sql?

Sql Server Tsql

What is the use of WITH TIES keyword in SELECT statement in SQL Queries?

Sql Server Tsql

SQL Server 2005 Using DateAdd to add a day to a date

Sql Sql Server Tsql Date Dateadd

How to get N rows starting from row M from sorted table in T-SQL

How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?

Sql Sql Server Tsql

Check if string doesn't contain another string

Sql Server Tsql String

Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?

Sql Server Tsql Join Sql

Pros & Cons of TRUNCATE vs DELETE FROM

Sql Server Sql Server-2008 Tsql Sql Delete Truncate

SET NOCOUNT ON usage

Sql Sql Server Tsql ado.net Concurrency

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

Sql Sql Server Tsql Alter

Why no windowed functions in where clauses?

Sql Sql Server Tsql Window Functions

What kind of datatype should one use to store hashes?

Sql Sql Server Sql Server-2008 Tsql

Parameter Sniffing (or Spoofing) in SQL Server

Sql Server Tsql Sql Server-2005 Parameter Spoofing

Scheduled run of stored procedure on SQL server

Sql Server Tsql

Boolean Expressions in SQL Select list

Sql Unit Testing Tsql Expression Assert

What is this hacker trying to do?

Sql Server Windows Tsql Security Sql Injection

Check if a varchar is a number (TSQL)

Tsql Numerical Methods

Common Table Expression, why semicolon?

Sql Sql Server Tsql Sql Server-2008 Common Table-Expression

SQL Server: Isolation level leaks across pooled connections

Sql Server Tsql ado.net Transactions Transactionscope

SQL Server FOR EACH Loop

Sql Sql Server Tsql

How to add plus one (+1) to a SQL Server column in a SQL Query

Sql Sql Server Tsql

@@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity

Sql Sql Server Tsql Identity Output Clause

T-SQL STOP or ABORT command in SQL Server

Sql Sql Server Tsql Sql Scripts

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

Sql Server Sql Server-2005 Tsql User Defined-Functions

Count based on condition in SQL Server

Sql Sql Server Tsql

How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?

Sql Sql Server Tsql Sql Server-2008-R2 Ansi Sql

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

Sql Sql Server Tsql Ssis

Altering column size in SQL Server

Sql Sql Server Database Tsql Alter Table

Count the Number of Tables in a SQL Server Database

Sql Server Tsql Count Sql Server-2012 Database Table

DateTimeOffset.Now in T-SQL

Sql Sql Server Tsql Sql Server-2008 Datetime

Column name or number of supplied values does not match table definition

Sql Sql Server Sql Server-2005 Tsql

Can there be constraints with the same name in a DB?

Sql Sql Server Sql Server-2005 Tsql Constraints

DROP...CREATE vs ALTER

Sql Sql Server Tsql

Doing a join across two databases with different collations on SQL Server and getting an error

Sql Server Tsql Collation

Convert Xml to Table SQL Server

Sql Xml Sql Server-2008 Tsql Sql Server-2005

sql set variable using COUNT

Sql Server Tsql

SQL Server: check whether a Trigger is Enabled or Disabled?

Sql Server Sql Server-2008 Tsql Triggers

How to pass an array into a SQL Server stored procedure

C#Sql Server Tsql Stored Procedures

Using IF ELSE statement based on Count to execute different Insert statements

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

SQL Server : Arithmetic overflow error converting expression to data type int

Sql Sql Server Tsql

Not equal <> != operator on NULL

Sql Sql Server Tsql Null

How get the T-SQL code to find duplicates?

Sql Server-2005 Tsql Ssms

How to stop SQLServer writing extraneous stuff eg (1 rows affected)

Sql Server Tsql

Generate a resultset of incrementing dates in TSQL

Sql Sql Server Database Sql Server-2005 Tsql

How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

Sql Server Tsql Compatibility

How to convert a "dd/mm/yyyy" string to datetime in SQL Server?

Tsql String Datetime

Check for empty GUID in SQL

Sql Server Tsql

TSQL: Get Last Queries Ran

Sql Tsql History

Get MAX value of a BIT column

Sql Sql Server Tsql Sql Server-2008 Stored Procedures

What is the T-SQL syntax to connect to another SQL Server?

Sql Server Tsql Stored Procedures Ssms

How to get difference between two rows for a column field?

Sql Sql Server Tsql Sql Server-2005

Delete all rows in table

Sql Server Tsql

SQL Server - current user name

Sql Server Tsql

T-SQL XOR Operator

Sql Server Tsql Xor

How to get just the date part of getdate()?

Sql Server Tsql

Difference between scalar, table-valued, and aggregate functions in SQL server?

Sql Server Function Tsql Aggregate Functions Sqlclr

How to update and order by using ms sql

Sql Sql Server Tsql Sql Order-By Sql Update

How do I create a comma-separated list using a SQL query?

Sql Sql Server Tsql String Aggregation

What characters are valid in an SQL Server database name?

Sql Server Tsql Identifier

good/doesn't matter/bad to include Primary Key in covering index?

Sql Server Tsql

T-SQL How to grant role to user

Sql Server Sql Server-2008 Tsql

tsql returning a table from a function or store procedure

Sql Server Tsql

Which sql server data type best represents a double in C#?

C#Sql Sql Server Tsql Double

How to write "not in ()" sql query using join

Sql Sql Server Tsql Notin

How to check if a stored procedure exists before creating it

Sql Sql Server Tsql Stored Procedures

T-SQL, updating more than one variable in a single select

Sql Sql Server Tsql

Delete duplicate records from a SQL table without a primary key

Sql Sql Server-2005 Tsql Duplicate Removal

What does =* mean?

Sql Sql Server Database Tsql

Generate Dates between date ranges

Sql Sql Server Tsql Sql Server-2008 Range

Cannot create index on view 'View_Table_Name' because the view is not schema bound

Sql Server Tsql View Indexing

Unique key vs. unique index on SQL Server 2008

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

Calculate running total / running balance

Sql Server Tsql Cumulative Sum

Convert date to YYYYMM format

Sql Sql Server Tsql

Scope of temporary tables in SQL Server

Sql Sql Server Tsql Sql Server-2012