Gang Of Coders
Home
About Us
Contact Us
All Sql Server Solutions on Gang of Coders
Total of 1672 Sql Server 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
SSMS version 18 – no Database Diagrams
Sql Server
Ssms
Ssms 18
How to easily edit SQL XML column in SQL Management Studio
Sql
Sql Server
Xml
Fastest way to delete all the data in a large table
Sql Server
Tsql
T-SQL: Round to nearest 15 minute interval
Sql
Sql Server
Datetime
Using "GO" within a transaction
.Net
Sql
Sql Server
Tsql
Transactions
SQL Server IF NOT EXISTS Usage?
Sql
Sql Server
Stored Procedures
SQL Server equivalent to Oracle's NULLS FIRST?
Sql
Sql Server
Sql Server-2005
Tsql
Pass table as parameter into sql server UDF
Sql
Sql Server
Sql Server-2005
Parameters
User Defined-Functions
Scripting SQL Server permissions
Sql Server
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
Isolation Level - Serializable. When should I use this?
Sql Server
How to delete rows in tables that contain foreign keys to other tables
Sql
Sql Server
Sql Server-2008
SQL Server - How to lock a table until a stored procedure finishes
Sql
Sql Server
Tsql
Stored Procedures
Locking
Is there any difference between IS NULL and =NULL
Sql
Sql Server
Sql Server-2005
How can I check if an SQL result contains a newline character?
Sql
Sql Server
Ssms
Checking an input param if not Null and using it in where in SQL Server
Sql Server
Sql Server-2008
Null
Where Clause
Coalesce
How to retrieve records for last 30 minutes in MS SQL?
Sql
Sql Server
Tsql
Cannot use special principal dbo: Error 15405
Sql Server
How to select date without time in SQL
Sql
Sql Server
Sql Server-2005
When should I use a table variable vs temporary table in sql server?
Sql Server
Temp Tables
Table Variable
Client Statistics table (Microsoft SQL Server Management Studio)
Sql
Sql Server
Sql Server-2008
Ssms
Use transactions for select statements?
Sql Server
Tsql
Stored Procedures
How to migrate a PostgreSQL database into a SQLServer one?
Sql Server
Database
Postgresql
Migration
Assign result of dynamic sql to variable
Sql Server
String
Explicitly drop temp table or let SQL Server handle it
Sql Server
Sql Server-2008-R2
Change primary key column in SQL Server
Sql
Sql Server
Database
Shared Hosting
How to list files inside a folder with SQL Server
Sql
Sql Server
CTE Recursion to get tree hierarchy
Sql Server
Common Table-Expression
Why is "close existing connections to destination database" grayed out on SQL Server 2012 Management Studio?
Sql Server
Database
Sql Server-2012
Ssms
Database Restore
Multiple SQL statements in one roundtrip using Dapper.NET
C#
Sql
.Net
Sql Server
Dapper
How can I resolve the "Table 'dbo.Foo' already exists." error when the table does not exist?
Sql Server
Ssms
How to get DATE from DATETIME Column in SQL?
Sql
Sql Server
Date
Datetime
Format SQL in SQL Server Management Studio
Sql Server
Formatting
Ssms
SET versus SELECT when assigning variables?
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Convert Rows to columns using 'Pivot' in SQL Server
Sql
Sql Server
Pivot
Pivot Table
Is there an Entity Framework 7 Database-First POCO Generator?
C#
Sql Server
asp.net Core
Entity Framework-Core
Sql Server 2005 how to change dbo login name
Sql Server
Sql Server-2005
Security
Active Directory
Why is 30 the default length for VARCHAR when using CAST?
Sql
Sql Server
Casting
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
Singular or plural database table names?
Sql
Mysql
Sql Server
Get the last day of the month in SQL
Sql
Sql Server
Tsql
How to Ignore "Duplicate Key" error in T-SQL (SQL Server)
Sql
Sql Server
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 Management Studio won't recognize a table exists after scripted create
Sql
Sql Server
Ssms
Sql Query to list all views in an SQL Server 2005 database
Sql
Sql Server
Metadata
How can I solve "Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong."?
Sql
Sql Server
Round *UP* to the nearest 100 in SQL Server
Sql Server
Math
Rounding
SQL - How do I get only the numbers after the decimal?
Sql
Sql Server
Tsql
ADO.NET - The Size property has an invalid size of 0
C#
Sql Server
ado.net
Reset AutoIncrement in SQL Server after Delete
Sql Server
Auto Increment
Delete Row
How to check if a Constraint exists in Sql server?
Sql Server
Information Schema
System Tables
How to connect to SQL Server database from JavaScript in the browser?
Javascript
Sql Server
Database Connection
Return value from exec(@sql)
Sql
Sql Server
Sql Server-2005
Tsql
Order by descending date - month, day and year
Sql
Sql Server
CROSS APPLY vs OUTER APPLY speed difference
Sql
Sql Server
Performance
Tsql
What is the purpose of PAD_INDEX in this SQL Server constraint?
Sql
Sql Server
Indexing
Delete data with foreign key in SQL Server table
Sql Server
T-sql - determine if value is integer
Sql Server
Tsql
Casting
Integer
Isnumeric
Check for file exists or not in sql server?
Sql
Sql Server
Sql Server-2008
How to replace (null) values with 0 output in PIVOT
Sql
Sql Server
Pivot
EF Exception: String or binary data would be truncated. The statement has been terminated.?
C#
Sql Server
Entity Framework
Exception
configurationManager does not exist in the namespace System.Configuration
C#
Sql Server
Visual Studio-2005
Drop primary key using script in SQL Server database
Sql Server
Sql Server-2008
Sql Server-2005
Adding named foreign key constraints in a SQL Create statement
Sql
Sql Server
Postgresql
Constraints
Create Table
There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
Sql
Sql Server
Key
Candidate
How to fix a collation conflict in a SQL Server query?
Sql Server
Database
Collation
Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?
Sql Server
Ssms
Sql Server-2014
Ssms 2014
EF 6.1 Unique Nullable Index
C#
Sql Server
Entity Framework
Ef Code-First
Why does Dapper's .Execute(...) return an int?
C#
Sql Server
Dapper
What is the difference between a primary key and a surrogate key?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Sql Server-2012
Why is EF generating SQL queries with unnecessary null-checks?
C#
Sql Server
Entity Framework
Create Local SQL Server database
Sql
Sql Server
Comparing two bitmasks in SQL to see if any of the bits match
Sql
Sql Server
Tsql
Bitmask
Can I connect to SQL Server using Windows Authentication from Java EE webapp?
Java
Sql Server
Tomcat
Jdbc
Jakarta Ee
What is a free tool to compare two SQL Server Databases?
Sql Server
How to choose returned column name in a SELECT FOR XML query?
Sql
Sql Server
Xml
Sql Server-2005
What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
Sql Server
Database
Visual Studio-2008
Sql Server-Ce
How do I shrink my SQL Server Database?
Sql Server
Database
Shrink
Msde2000
SQL: Update a row and returning a column value with 1 query
C#
Sql Server
Tsql
ado.net
How to find slowest queries
Sql Server
Sql Server-2005
Profiling
SQL Server truncation and 8192 limitation
Sql Server
Truncation
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
How can I truncate a datetime in SQL Server?
Sql Server
Sql Server-2008
Datetime
Truncate
Difference between "read commited" and "repeatable read"
Sql
Sql Server
Isolation Level
SQL Server: Add seconds to a datetime field?
Sql
Sql Server
Convert SQL Server result set into string
Sql
Sql Server
Sql Server-2005
Tsql
ASP.NET MVC 3 - Unable to find the requested .Net Framework Data Provider
C#
Sql Server
asp.net Mvc-3
Visual Web-Developer
Dataprovider
Why does SQL Server keep creating a DF constraint?
Sql
Sql Server
Sql Server-2008
"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP
Php
Sql Server
Sql Server-2005
Freetds
Unixodbc
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
How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?
Sql Server
Ssms
Sql Server-2008
Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
Sql Server
Azure
Remote Access
Ports
How to Identify port number of SQL server
Sql
Sql Server
Conversion failed when converting from a character string to uniqueidentifier - Two GUIDs
Sql Server
Sql Server-2012
how to call scalar function in sql server 2008
Sql
Sql Server
Format number as percent in MS SQL Server
Sql Server
Tsql
Percentage
How to add LocalDB to Visual Studio 2015 Community's SQL Server Object Explorer?
Sql Server
Visual Studio-2015
Localdb
What are some ways of accessing Microsoft SQL Server from Linux?
Sql Server
How can I combine multiple rows into a comma-delimited list in SQL Server 2005?
Sql
Sql Server
List
Function
Concatenation
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
SQL: Combine Select count(*) from multiple tables
Sql
Sql Server
Tsql
Is there a difference between a SELECT statement inside a transaction and one that is outside of it?
Sql
Sql Server
Select
Transactions
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
SQL Server: Attach incorrect version 661
Sql Server
copy a database within SQL Server Express?
Sql Server
Sql Server-Express
SQL Server GUID sort algorithm. Why?
Sql Server
Sql Server-2005
Sql Server-2008
Sorting
Is it possible to create a temporary table in a View and drop it after select?
Sql Server
Tsql
Restore SQL Server DB without transaction log
Sql Server
Restore
Transaction Log
How to close existing connections to a DB
Sql
Sql Server
What are the differences between a clustered and a non-clustered index?
Sql Server
Indexing
Clustered Index
Non Clustered-Index
SQL Server compare results of two queries that should be identical
Sql Server
Sql Server-2005
SQL Server converting varbinary to string
Sql
Sql Server
String
Varbinary
How to run multiple SQL commands in a single SQL connection?
C#
Sql Server
ado.net
Sqlconnection
Sqlcommand
T-SQL Conditional Order By
Sql
Sql Server
Tsql
how to get 2 digits after decimal point in tsql?
Sql Server
Tsql
Formatting
JPA - How to set string column to varchar(max) in DDL
Java
Sql Server
Hibernate
Jpa
Ddl
My Select SUM query returns null. It should return 0
Sql
Sql Server
Invalid use side-effecting operator Insert within a function
Sql
Sql Server
Sql Server-2008
How to make CREATE OR REPLACE VIEW work in SQL Server?
Sql
Sql Server
View
Porting
How to simulate DEADLOCK on SQL Server?
Sql
Sql Server
Concurrency
Deadlock
SQL Server : login success but "The database [dbName] is not accessible. (ObjectExplorer)"
Sql Server
Login
SQL Server: Query fast, but slow from procedure
Sql Server
Performance
Stored Procedures
SQL Server Text type vs. varchar data type
Sql Server
Text
Varchar
Sqldatatypes
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
SQL Server 2005 - Export table programmatically (run a .sql file to rebuild it)
Sql
Sql Server
Sql Server-2005
Database Table
When should you use full-text indexing?
Sql
Sql Server
Tsql
Indexing
Full Text-Search
Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"
Sql
Sql Server
Sql Server-2005
Optimization
Sql Execution-Plan
Reusing SqlCommand?
C#
.Net
Sql Server
Copy Data from a table in one Database to another separate database
Sql
Sql Server
Update primary key value using entity framework
.Net
Sql Server
vb.net
Entity Framework
Using comparison operators in SELECT clause of T-SQL query
Sql
Sql Server
Sql Server-2008
Tsql
Comparison Operators
How do I connect to a SQL Server 2008 database using JDBC?
Java
Sql Server
Sql Server-2008
Jdbc
Get the unique constraint columns list (in TSQL)?
Sql Server
Tsql
Metadata
Constraints
Database design for invoices, invoice lines & revisions
Sql Server
Database Design
Invoices
TSQL to Map User to Database
Sql Server
Tsql
stored procedures with sqlAlchemy
Python
Sql Server
Stored Procedures
Sqlalchemy
How can I INSERT data into two tables simultaneously in SQL Server?
Sql
Sql Server
Tsql
Insert
Foreign Keys
How to solve "unable to switch the encoding" error when inserting XML into SQL Server
.Net
Sql Server
Xml
Utf 8
Utf 16
SELECT INTO USING UNION QUERY
Sql
Sql Server
Tsql
Union
Derived Table
SQL Server Query: Fast with Literal but Slow with Variable
Sql Server
Performance
Sql Server-2008
How to view transaction logs in SQL Server 2008
Sql Server
Transaction Log
Difference between JOIN and INNER JOIN
Sql
Sql Server
Join
Inner Join
What do Clustered and Non-Clustered index actually mean?
Sql Server
Performance
Indexing
Clustered Index
Non Clustered-Index
What is the PostgreSQL equivalent for ISNULL()
Sql Server
Postgresql
Null
Combining ORDER BY AND UNION in SQL Server
Sql
Sql Server
Sql Order-By
Union All
JDBC SQLServerException: "This driver is not configured for integrated authentication."
Java
Sql Server
Jdbc
Mssql Jdbc
Smartfoxserver
SQL performance on LEFT OUTER JOIN vs NOT EXISTS
Sql
Sql Server
CASE IN statement with multiple values
Sql
Sql Server
Sql Server-2005
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
How to convert integer to decimal in SQL Server query?
Sql
Sql Server
Type Conversion
What is difference between != and <> in sql server
Sql
Sql Server
Operators
List names of all tables in a SQL Server 2012 schema
Sql
Sql Server
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
How do I connect to SQL Server via sqlalchemy using Windows Authentication?
Python
Sql Server
Sqlalchemy
Get Entity Framework 6 use NOLOCK in its underneath SELECT statements
C#
Sql
.Net
Sql Server
Entity Framework
What is (are) difference between NOLOCK and UNCOMMITTED
Sql
Sql Server
Sql Server-2012
Locking
Isolation Level
SSIS Script Component Cannot Load Assembly Until Manually Opened
C#
Sql Server
Visual Studio
Ssis
Biml
SQL Server Random Sort
Sql Server
SQL query question: SELECT ... NOT IN
Sql
Sql Server
Is the Sql Server Unique Key also an Index?
Sql Server
Indexing
Unique Key
SSIS Excel Import Forcing Incorrect Column Type
Sql Server
Excel
Types
Ssis
Using Sql Server with Django in production
Python
Sql Server
Django
Pyodbc
Saving changes after table edit in SQL Server Management Studio
Sql
Sql Server
Ssms
Database Table
How can you represent inheritance in a database?
Sql Server
Inheritance
Database Design
Class Table-Inheritance
SQL Server add auto increment primary key to existing table
Sql Server
Sql Server-2008
Primary Key
Alter Table
How to execute a stored procedure within C# program
C#
Sql Server
Stored Procedures
How to fetch the row count for all tables in a SQL SERVER database
Sql
Sql Server
Rowcount
Create SQL Server CE database file programmatically
C#
.Net
Sql Server
Database
Sql Server-Ce
How does SQL Server treat statements inside stored procedures with respect to transactions?
Sql
Sql Server
Stored Procedures
Transactions
Is it good database design to have admin users in the same table as front-end users?
Sql
Sql Server
Database
Database Design
Data Modeling
UNION the results of multiple stored procedures
Sql
Sql Server
Stored Procedures
Union
Assign a login to a user created without login (SQL Server)
Sql Server
Sql Server-2008
How to find out what is locking my tables?
Sql
Sql Server
Sql Server-2008-R2
Locking
Query Optimization
To add server using sp_addlinkedserver
Sql Server
Tsql
Remove all spaces from a string in SQL Server
Sql Server
How to store decimal values in SQL Server?
Sql
Sql Server
Types
Decimal
Create a view with ORDER BY clause
Sql Server
Database
Tsql
View
Sql Server-2008-R2
Modify Default value in SQL Server
Sql
Sql Server
Cannot Resolve Collation Conflict
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Collation
T-SQL split string based on delimiter
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2008-R2
SSIS Excel Connection Manager failed to Connect to the Source
Sql Server
Visual Studio-2010
Visual Studio
Ssis
Sql Server-2012
Entity framework very slow to load for first time after every compilation
C#
Sql Server
Entity Framework
Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'
Sql
Sql Server
Ssms
Localdb
Find a value anywhere in a database
Sql Server
Tsql
How do you kill all current connections to a SQL Server 2005 database?
Sql Server
Sql Server-2005
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
Why is query with phone = N'1234' slower than phone = '1234'?
Sql
Sql Server
Query Performance
How to return multiple values in one column (T-SQL)?
Sql
Sql Server
Sql Server-2005
Tsql
Sql server real datatype, what is the C# equivalent?
C#
Sql Server
What is the best way to store a large amount of text in a SQL server table?
Sql Server
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
Sql Data Type for Primary Key - SQL Server?
Sql Server
Database Design
Types
How do you add a NOT NULL Column to a large table in SQL Server?
Sql Server
How to change a column without dropping a table in SQL 2008
Sql Server
Sql Server-2008
Column Types
What is the difference between Unique Key and Index with IsUnique=Yes?
Sql Server
Database
Dynamic SQL results into temp table in SQL Stored procedure
Sql Server
Tsql
Dynamic Sql
What is the best column type for URL?
Sql Server
Url
Column Types
Can I save an 'Object' in a SQL Server database?
C#
Sql Server
Sql Server-2005
ado.net
In SQL Server, how can I find everywhere a column is referenced?
Sql Server
Sql Server-2008
Why can't indexed views have a MAX() aggregate?
Sql Server
View
Indexing
Aggregate
Can a database table be without a primary key?
Mysql
Sql Server
Database
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
T-SQL: Selecting Column Based on MAX(Other Column)
Sql
Sql Server
Tsql
Greatest N-per-Group
Fastest way to update 120 Million records
Sql
Sql Server
Sql Server-2005
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
How to check for Is not Null And Is not Empty string in SQL server?
Sql
Sql Server
SQL Server INLINE IF ELSE
Sql Server
If Statement
SQL Server giving logins(users) db_owner access to database
Sql
Sql Server
Database
IF EXISTS in T-SQL
Sql Server
Tsql
Exists
Can't change table design in SQL Server 2008
Sql
Sql Server
Sql Server-2008
Count records for every month in a year
Sql
Sql Server
Sql Server-2008
SQL Server Convert Varchar to Datetime
Sql
Sql Server
Datetime
Formatting
Varchar
How to get calendar Quarter from a date in TSQL
Sql
Sql Server
Tsql
Sql Server-2005
How do I set a column in SQL Server to varchar(max) using ASP.net EF Codefirst Data Annotations?
C#
Sql Server
Entity Framework
Ef Code-First
Handling inheritance with overriding efficiently
Sql
Sql Server
Sql Server-2008
Tree
Select count(*) from result query
Sql
Sql Server
Select
Split string and take last element
Sql
Sql Server
Url
Split
How to use a CTE statement in a table-valued function in SQL Server
Sql Server
Sql Server-2008-R2
Common Table-Expression
View or Temporary Table - which to use in MS SQL Server?
Sql
Sql Server
View
Temp Tables
How to cast datetime to datetimeoffset?
Sql Server
Internationalization
Sql Server-2008-R2
Syntax of for-loop in SQL Server
Sql
Sql Server
Loops
Tsql
Syntax
Postgres Case Sensitivity
Sql
Sql Server
Postgresql
SQL server 2012. Exception: attempted to read or write protected memory (MS.VS.OLE.Interop)
Sql Server
Exception
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
How to view the roles and permissions granted to any database user in Azure SQL server instance?
Sql Server
Azure
Azure Sql-Database
Azure Sql
How to alter column nvarchar length without drop
Sql
Sql Server
Ssms
How do I unit test persistence?
Sql Server
Unit Testing
Tdd
How do you get leading wildcard full-text searches to work in SQL Server?
Sql Server
Full Text-Search
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
How to set a default row for a query that returns no rows?
Sql
Sql Server
INNER JOIN vs LEFT JOIN performance in SQL Server
Sql
Sql Server
Performance
error, string or binary data would be truncated when trying to insert
Sql
Sql Server
How can I do a BEFORE UPDATED trigger with sql server?
Sql
Sql Server
Database
Triggers
Sql Server-Express
SQL Server error on update command - "A severe error occurred on the current command"
Sql Server
Sql Server-2005
Tsql
Why can't I put a constraint on nvarchar(max)?
Sql Server
Sql Server-2005
SQL Server giving arithmetic overflow when calculating avg
Sql Server
Types
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
How to insert a blob into a database using sql server management studio
Sql
Sql Server
Sql Server-2005
Blob
How to declare a variable in SQL Server and use it in the same Stored Procedure
Sql Server
Stored Procedures
Local Variables
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
SQL Server: should I use information_schema tables over sys tables?
Sql
Sql Server
Sql Server-2008
Stored Procedures
Metadata
Find a string by searching all stored procs in SQL Server Management Studio 2008
Sql Server
Ssms
SQL Server stops loading assembly
.Net
Sql Server
Logging
Sql Server-2008-R2
Sqlclr
Opening a SQL Server .bak file (Not restoring!)
Sql Server
Sql Server-2008
Backup
Restore
SQL Server - find nth occurrence in a string
Sql Server
What does "ORDER BY (SELECT NULL)" mean?
Sql Server
Select
Sql Order-By
Drop default constraint on a column in TSQL
Sql
Sql Server
Database
Tsql
Add unique constraint in SQL Server 2008 GUI?
Sql
Sql Server
Ssms
Sql Server-2008
How to debug stored procedures with print statements?
Sql Server
Tsql
Stored Procedures
SQL list of all the user defined functions in a database
Sql Server
Sql Server-2008-R2
SQL Query to find the last day of the month
Sql Server
Sql Server-2005
Date
Datetime
SQL - Difference between COALESCE and ISNULL?
Sql
Sql Server
Custom order by in SQL server like P, A, L, H
Sql
Sql Server
Sql Order-By
Update Top 1 record in table sql server
Sql Server
Sql Server-2008
How to install localdb separately?
Sql
Sql Server
Localdb
SQL Server 2012 installation Reporting Services Catalog error
Sql
Sql Server
Visual Studio-2012
Sql Server-2012
SQL Server 2008 R2 Stuck in Single User Mode
Sql
Sql Server
Database
Sql Server-2008
Database Deployment
Using Excel VBA to run SQL query
Sql
Sql Server
Vba
Excel
NULL values inside NOT IN clause
Sql
Sql Server
Tsql
Null
Notin
How do I set a column value to NULL in SQL Server Management Studio?
Sql
Sql Server
Ssms
SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
Java
Sql Server
Linux
Ssl
Jdbc
How to set multiple values inside an if else statement?
Sql
Sql Server
Tsql
SQL Server User Mapping Error 15023
Sql
Sql Server
How do I escape a single quote in SQL Server?
Sql
Sql Server
Tsql
Delimiter
Single Quotes
Is there a way to loop through a table variable in TSQL without using a cursor?
Sql Server
Tsql
Loops
How do I list all the columns in a table?
Sql
Mysql
Sql Server
Database
Oracle
SQL Case Sensitive String Compare
Sql
Sql Server
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
What's the best practice for primary keys in tables?
Sql
Sql Server
Database
Relational
What makes a SQL statement sargable?
Sql Server
Performance
What does ON [PRIMARY] mean?
Sql
Sql Server
Database
Database Design
INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server
Sql
Sql Server
Sql Server-2005
Foreign Keys
How can I select from list of values in SQL Server
Sql Server
Select Query
Create a date from day month and year with T-SQL
Sql
Sql Server
Sql Server-2005
Tsql
How to deal with SQL column names that look like SQL keywords?
Sql
Sql Server
SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
Sql
Sql Server
Database
Sql Server-2005
Custom Data-Type
Storing JSON in database vs. having a new column for each key
Mysql
Sql
Sql Server
Database
Optimization
What are the pros and cons to keeping SQL in Stored Procs versus Code
C#
Sql
Sql Server
Stored Procedures
How do I drop a foreign key constraint only if it exists in sql server?
Sql
Sql Server
Sql Server-2005
Tsql
How can I backup a remote SQL Server database to a local drive?
Sql
Sql Server
Backup
Correct use of transactions in SQL Server
Sql
Sql Server
Database
Tsql
Transactions
Generate class from database table
C#
Sql
Sql Server
Tsql
Unique constraint on multiple columns
Sql Server
Sql Server-2008
Ssms
Removing the remembered login and password list in SQL Server Management Studio
Sql Server
Security
Login
Ssms
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 import a large MS SQL .sql file?
Sql
Sql Server
Import
SQL update from one Table to another based on a ID match
Sql
Sql Server
Select
Join
Sql Update
Convert Datetime column from UTC to local time in select statement
Sql
Sql Server
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
"Prevent saving changes that require the table to be re-created" negative effects
Sql Server
Sql Server-2008
Database Design
Sql Server-2005
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
Import .bak file to a database in SQL server
Sql Server
Database Restore
What is the maximum characters for the NVARCHAR(MAX)?
Sql Server
Sql Server-2008
Sql Server-2005
How to update Identity Column in SQL Server?
Sql
Sql Server
Tsql
Sql Server-2008
How can I solve a connection pool problem between ASP.NET and SQL Server?
.Net
asp.net
Sql Server
Sql Server-2005
LIKE vs CONTAINS on SQL Server
Sql Server
Performance
Contains
Sql Like
SQL Server Configuration Manager not found
Sql Server
Sql Server-2008
Sql Server-2012
Sql Server-Config-Manager
How to write UPDATE SQL with Table alias in SQL Server 2008?
Sql
Sql Server
Sql Server-2008
Sql Update
Alias
SQL Server. How to refresh the intellisense?
Sql Server
Sql Server-2008
Ssms
How to get the connection String from a database
C#
Sql Server
Visual Studio
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Sql
Sql Server
Database
Foreign Keys
Parameterize an SQL IN clause
Sql
Sql Server
Parameters
How do I create a foreign key in SQL Server?
Sql
Sql Server
Tsql
Add IIS 7 AppPool Identities as SQL Server Logons
Sql Server
Iis 7
When to use Common Table Expression (CTE)
Sql
Sql Server
Tsql
Common Table-Expression
SQL RANK() versus ROW_NUMBER()
Sql
Sql Server
Tsql
Find a string by searching all tables in SQL Server
Sql
Sql Server
Search
When should I use semicolons in SQL Server?
Sql Server
Tsql
SQL Server Management Studio, how to get execution time down to milliseconds
Sql Server
Ssms
Sql Server-2008
Does MS SQL Server's "between" include the range boundaries?
Sql
Sql Server
Between
How to drop all tables in a SQL Server database?
Sql Server
Sql Server-2008
Ssms
Sp Msforeachtable
How to write a foreach in SQL Server?
Sql Server
Tsql
Why use a READ UNCOMMITTED isolation level?
Sql Server
Tsql
Isolation Level
Select top 10 records for each category
Sql
Sql Server
Sql Server-2005
Greatest N-per-Group
How do I flush the PRINT buffer in TSQL?
Sql Server
Tsql
Printing
SQL Server query to find all permissions/access for all users in a database
Sql Server
Sql Server-2005
Sql Server-2008
Exit single-user mode
Sql Server
Sql Server-2008-R2
What are the main performance differences between varchar and nvarchar SQL Server data types?
Sql Server
Sql Server-2005
Storage
Varchar
Nvarchar
What is the equivalent of bigint in C#?
C#
.Net
Sql Server
Bigint
What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
Sql
Sql Server
Identity
How can I determine installed SQL Server instances and their versions?
Sql Server
Sql Server-Express
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 to create a table from select query result in SQL Server 2008
Sql
Sql Server
Sql Server-2008
Finding duplicate rows in SQL Server
Sql
Sql Server
Duplicates
How to get script of SQL Server data?
Sql
Sql Server
Export
How do I format a number with commas in T-SQL?
Sql Server
Tsql
How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?
Sql Server
Ssms
Add primary key to existing table
Sql
Sql Server
Sql Server-2008
Constraints
Primary Key
An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
Sql Server
sql query to return differences between two tables
Sql
Sql Server
Sql Server-2008
Sql Server-2005
MSSQL Error 'The underlying provider failed on Open'
C#
Sql Server
Entity Framework
Database Connection
How do you view ALL text from an ntext or nvarchar(max) in SSMS?
Sql Server
Sql Server-2008
Tsql
Ssms
Difference between left join and right join in SQL Server
Sql
Sql Server
Join
Left Join
Right Join
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
SQL Server: What is the difference between CROSS JOIN and FULL OUTER JOIN?
Sql Server
Cross Join
Full Outer-Join
Add a column to a table, if it does not already exist
Sql Server
Add
Not Exists
Execute stored procedure with an Output parameter?
Sql Server
Stored Procedures
What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
Sql Server
Validation
Database Design
Data Modeling
Phone Number
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
Search text in stored procedure in SQL Server
Sql
Sql Server
Stored Procedures
CREATE TABLE IF NOT EXISTS equivalent in SQL Server
Sql
Sql Server
Sql Server-2008-R2
How to drop all tables from a database with one SQL query?
Sql
Sql Server
Convert Month Number to Month Name Function in SQL
Sql
Sql Server
Tsql
Sql Server-2005
Turn off constraints temporarily (MS SQL)
Sql
Sql Server
Sql Server-2005
Constraints
Entity Relationship
How to get a float result by dividing two integer values using T-SQL?
Sql Server
Sql Server-2008
Division
Rounding
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
Query to list number of records in each table in a database
Sql Server
Database
The multi-part identifier could not be bound
Sql
Sql Server
Sql Server-2005
Changing the maximum length of a varchar column?
Sql
Sql Server
Sql Server-2008
Tsql
Varchar
Import CSV file into SQL Server
Sql
Sql Server
Csv
Bulkinsert
Bulk
List the queries running on SQL Server
Sql Server
How do I execute a stored procedure once for each row returned by query?
Sql
Sql Server
Stored Procedures
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
How to combine date from one field with time from another field - MS SQL Server
Sql
Sql Server
Datetime
SQL Server - transactions roll back on error?
Sql
Sql Server
Sql Server-2005
Transactions
The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'
Sql Server
Inserting data into a temporary table
Sql
Sql Server
Temp Tables
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
What is the correct SQL type to store a .Net Timespan with values > 24:00:00?
.Net
Sql Server
Timespan
Delete a single record from Entity Framework?
C#
Sql Server
Entity Framework
Creating an index on a table variable
Sql
Sql Server
Tsql
Indexing
Table Variable
How can I clear the SQL Server query cache?
Sql Server
Caching
Storing images in SQL Server?
Sql Server
Image
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
Replacing NULL with 0 in a SQL server query
Sql
Sql Server
How do you truncate all tables in a database using TSQL?
Sql Server
Tsql
Import / Export database with SQL Server Server Management Studio
Sql Server
Import
Export
Ssms
How to get cumulative sum
Sql Server
Sql Server-2008
Modify table: How to change 'Allow Nulls' attribute from not null to allow null
Sql
Sql Server
Sql Server-2008
How to change column datatype in SQL Server database without losing data?
Sql Server
Sql Server-2008
Alter
SQL Server equivalent of MySQL's NOW()?
Sql
Sql Server
How to create Temp table with SELECT * INTO tempTable FROM CTE Query
Sql
Sql Server
Common Table-Expression
How to export all data from table to an insertable sql format?
Sql
Sql Server
Copy
Export
Ssms
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
What resources exist for Database performance-tuning?
Mysql
Sql Server
Database
Oracle
Postgresql
SQL Server Index Naming Conventions
Sql Server
Naming Conventions
Indexing
Referring to a Column Alias in a WHERE Clause
Sql
Sql Server
Tsql
Sql Server-2005
Set database from SINGLE USER mode to MULTI USER
Sql
Sql Server
What is the command to truncate a SQL Server log file?
Sql Server
Truncate
Logging
Truncate (not round) decimal places in SQL Server
Sql
Sql Server
Tsql
Rounding
What is best tool to compare two SQL Server databases (schema and data)?
Sql
Sql Server
Database
Compare
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
Best way to do nested case statement logic in SQL Server
Sql
Sql Server
Sql Server-2005
Select
Nested
How do I escape a percentage sign in T-SQL?
Sql Server
Tsql
How to alter SQL in "Edit Top 200 Rows" in SSMS 2008
Sql Server
Ssms
Sql Server-2008
is it possible to select EXISTS directly as a bit?
Sql
Sql Server
Tsql
How do I perform an insert and return inserted identity with Dapper?
C#
Sql Server
Dapper
In SQL, how can you "group by" in ranges?
Sql
Sql Server
Tsql
SQL Server 2008 can't login with newly created user
Sql Server
Authentication
Login
Ssms
How to see query history in SQL Server Management Studio
Sql Server
Logging
Ssms
What size do you use for varchar(MAX) in your parameter declaration?
C#
Sql Server
ado.net
Difference between a User and a Login in SQL Server
Sql
Sql Server
Sql Server-2005
How to calculate age (in years) based on Date of Birth and getDate()
Sql
Sql Server
Tsql
Effect of NOLOCK hint in SELECT statements
Sql
Sql Server
Locking
Using varchar(MAX) vs TEXT on SQL Server
Sql Server
Performance
Text
Varchar
Sql Types
SQL Server database backup restore on lower version
Sql Server
Can you create nested WITH clauses for Common Table Expressions?
Sql
Sql Server
Tsql
Nested
Common Table-Expression
SQL Server: Filter output of sp_who2
Sql Server
Sql Server-2016
The object 'DF__*' is dependent on column '*' - Changing int to double
Sql
Sql Server
Database
Entity Framework
Entity Framework-4
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 to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?
Sql
Sql Server
String Concatenation
How important is the order of columns in indexes?
Sql
Sql Server
Sql Server-2005
Tsql
Indexing
The SQL OVER() clause - when and why is it useful?
Sql
Sql Server
Aggregate Functions
Clause
SQL Server String or binary data would be truncated
Sql Server
Tsql
Sql Server-2005
Migration
Data Migration
SQL Server Restore Error - Access is Denied
Sql Server
Sql Server-2005
Backup
Restore
OPTION (RECOMPILE) is Always Faster; Why?
Sql
Sql Server
Sql Server-2008
Compilation
Query Hints
How do I use ROW_NUMBER()?
Sql
Sql Server
Row Number
SQL WHERE.. IN clause multiple columns
Sql Server
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
How do I copy SQL Azure database to my local development server?
Sql Server
Azure
Azure Sql-Database
Database Migration
Add unique constraint to combination of two columns
Sql
Sql Server
What is the use of the square brackets [] in sql statements?
Sql Server
Syntax
Generate table relationship diagram from existing schema (SQL Server)
Sql Server
Database
Diagram
Alter column, add default constraint
Sql Server
Sql Server-2008
Tsql
Alter Table
Alter Column
Equivalent of LIMIT and OFFSET for SQL Server?
Sql
Sql Server
Pagination
Limit
Offset
Visual Studio: ContextSwitchDeadlock
C#
Sql Server
Visual Studio
nvarchar(max) vs NText
Sql Server
Sql Server-2005
Sql Server-2008
Text
Nvarchar
Error on renaming database in SQL Server 2008 R2
Sql
Sql Server
Sql Server-2008-R2
How to check which locks are held on a table
Sql
Sql Server
Database
Performance
Sql Server-2005
Foreign key constraint may cause cycles or multiple cascade paths?
Sql
Sql Server
Constraints
How do I remove the first characters of a specific column in a table?
Sql
Sql Server
String
Tsql
What is the benefit of using "SET XACT_ABORT ON" in a stored procedure?
Sql
Sql Server
Checking if a SQL Server login already exists
Sql Server
Login
How do I UPDATE from a SELECT in SQL Server?
Sql
Sql Server
Tsql
Select
Sql Update
Add a column with a default value to an existing table in SQL Server
Sql
Sql Server
Sql Server-2005
Sql Server-2000
Reset identity seed after deleting records in SQL Server
Sql
Sql Server
Database
Sql Server-2008
Azure Sql-Database
Should I use != or <> for not equal in T-SQL?
Sql
Sql Server
Tsql
SNIReadSyncOverAsync Performance issue
.Net
Sql Server
ado.net
Dottrace
How do I check if a SQL Server text column is empty?
Sql Server
Sql Server-2005
Sqldatatypes
Notnull
Emptydatatext
How to strip all non-alphabetic characters from string in SQL Server?
Sql Server
Parsing
User Defined-Functions
Alphanumeric
Alphabetic
A table name as a variable
Sql
Sql Server
Tsql
Variable Names
Tablename
Update multiple columns in SQL
Sql
Sql Server
Sql Update
Why can't I use an alias in a DELETE statement?
Sql
Sql Server
Sql Server-Ce
Difference between database and schema
Sql Server
Database
Sql Server-2005
Database Schema
How to Select Every Row Where Column Value is NOT Distinct
Sql
Sql Server
Sql Server-2008
SQL Server loop - how do I loop through a set of records
Sql
Sql Server
Can I create a named default constraint in an add column statement in SQL Server?
Sql Server
Constraints
Alter Table
Code Maintainability
Copy data into another table
Sql
Sql Server
Sql Server-2008
DateTime2 vs DateTime in SQL Server
Sql
Sql Server
Tsql
Datetime
Datetime2
How to do a case sensitive search in WHERE clause (I'm using SQL Server)?
Sql
Sql Server
How to check existence of user-define table type in SQL Server 2008?
Sql
Sql Server
Sql Server-2008
Tsql
User Defined-Types
Conversion failed when converting date and/or time from character string while inserting datetime
Sql
Sql Server
How to find a text inside SQL Server procedures / triggers?
Sql Server
Stored Procedures
Triggers
Linked Server
Search all tables, all columns for a specific value SQL Server
Sql Server
How to ALTER multiple columns at once in SQL Server
Sql Server
Tsql
Alter Column
Select SQL Server database size
Sql
Sql Server
Sql Server-2008
Sql Server-2008-R2
Insert Update trigger how to determine if insert or update
Sql Server
Tsql
Triggers
SQL Call Stored Procedure for each Row without using a cursor
Sql
Sql Server
Stored Procedures
Database Cursor
Count(*) vs Count(1) - SQL Server
Sql
Sql Server
Performance
How to drop a table if it exists?
Sql Server
Tsql
How to select the last record of a table in SQL?
Sql
Sql Server
Sql Server-2008
How to pass table value parameters to stored procedure from .net code
C#
Sql Server
Stored Procedures
Sqlcommand
Table Valued-Parameters
CROSS JOIN vs INNER JOIN in SQL
Sql
Sql Server
Sql Server-2008
Tsql
Cross Join
Fastest way to determine if record exists
Sql
Sql Server
Performance
Select
Count
Better techniques for trimming leading zeros in SQL Server?
Sql
Sql Server
Sql Server-2005
Tsql
String
DISTINCT for only one column
Sql
Sql Server
How to get last inserted id?
C#
Sql
Sql Server
SQL Server 2005 How Create a Unique Constraint?
Sql
Sql Server
Constraints
Getting only Month and Year from SQL DATE
Sql
Sql Server
Tsql
Write a number with two decimal places SQL Server
Sql
Sql Server
Decimal
Number Formatting
Is it possible to use the SELECT INTO clause with UNION [ALL]?
Sql
Sql Server
What does "exec sp_reset_connection" mean in Sql Server Profiler?
Sql Server
Database Connection
Sql Server-Profiler
Sp Reset-Connection
sql server #region
Sql Server
Region
Optimistic vs. Pessimistic locking
Sql Server
Locking
Optimistic Locking
Pessimistic Locking
Foreign Key to multiple tables
Sql Server
Relational Database
SQL Server Operating system error 5: "5(Access is denied.)"
Sql
Sql Server
How can I change my default database in SQL Server without using MS SQL Server Management Studio?
Sql Server
Sql Server-2005
Ssms
Default Database
SQL Server SELECT LAST N Rows
Sql
Sql Server
Performance
Sql Server-2008
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
Can I use CASE statement in a JOIN condition?
Sql
Sql Server
Join
Case
Tablix: Repeat header rows on each page not working - Report Builder 3.0
Sql Server
Reporting Services
Ssrs Tablix
reportbuilder3.0
SQL DROP TABLE foreign key constraint
Sql Server
Foreign Keys
Constraints
Database Table
Drop Table
How to find current transaction level?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Isolation Level
SQL Server NOLOCK and joins
Sql
Sql Server
Nolock
LIMIT 10..20 in SQL Server
Sql
Sql Server
Pagination
Limit
Difference between CTE and SubQuery?
Sql
Sql Server
Tsql
Subquery
Common Table-Expression
IndexOf function in T-SQL
Sql
Sql Server
Tsql
String
Implement paging (skip / take) functionality with this query
Sql
Sql Server
Join
Pagination
SQL Server: Is it possible to insert into two tables at the same time?
Sql
Sql Server
Insert
Temp Tables
SQL Server: converting UniqueIdentifier to string in a case statement
Sql Server
Guid
Case
How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?
Sql Server
Sql Server-2005
Database Connectivity
How to use NULL or empty string in SQL
Sql
Sql Server
Null
Where
Foreign Key to non-primary key
Sql
Sql Server
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- Ignore case while searching for a string
Sql
Sql Server
Case Insensitive
Sql Like
Ignore Case
Multiple Indexes vs Multi-Column Indexes
Sql Server
Database
Indexing
SQL update query using joins
Sql
Sql Server
Tsql
Sql Server-2005
Sql Update
How to find foreign key dependencies in SQL Server?
.Net
Sql Server
Foreign Keys
Imply bit with constant 1 or 0 in SQL Server
Sql
Sql Server
Tsql
Bit
How do I specify "close existing connections" in sql script
Sql
Sql Server
How to drop column with constraint?
Sql Server
Sql Server-2008
GRANT EXECUTE to all stored procedures
Sql
Sql Server
Tsql
Sql Server-2008
Permissions
How can I find out what FOREIGN KEY constraint references a table in SQL Server?
Sql
Sql Server
Sql Server-2008
Insert Data Into Temp Table with Query
Sql
Sql Server
Ssms
Drop all tables whose names begin with a certain string
Sql
Sql Server
Dynamic Sql
When restoring a backup, how do I disconnect all active connections?
Sql Server
Sql Server-2005
Backup
Restore
Disconnect
Local and global temporary tables in SQL Server
Sql Server
Temp Tables
Global Temp-Tables
T-SQL split string
Sql
Sql Server
Tsql
Sql Server-2008
Split
SQL "between" not inclusive
Sql
Sql Server
Sql Server-2008
Tsql
Date
When/Why to use Cascading in SQL Server?
Sql Server
Database Design
Foreign Keys
Rdbms
Cascade
Compare DATETIME and DATE ignoring time portion
Sql
Sql Server
Tsql
Sql Server-2008
Datetime Conversion
SQL query for today's date minus two months
Sql
Sql Server
SQL-Server: Error - Exclusive access could not be obtained because the database is in use
Sql
Sql Server
Sql Server-2008
Why does NULL = NULL evaluate to false in SQL server
Sql
Sql Server
Null
'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
Sql Server
Excel
Ssis
Oledb
Aceoledb
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
Rename column SQL Server 2008
Sql
Sql Server
Sql Server-2008
Alter Table
Check if a temporary table exists and delete if it exists before creating a temporary table
Sql Server
Sql Server-2005
Temp Tables
Alter Table
How to split a comma-separated value to columns
Sql Server
Sql Server-2008
Csv
"No backupset selected to be restored" SQL Server 2012
Sql Server
Restore
Sql Server-2012
How to specify a port number in SQL Server connection string?
Sql Server
How to Execute SQL Server Stored Procedure in SQL Developer?
Sql Server
Stored Procedures
Oracle Sqldeveloper
Does Foreign Key improve query performance?
Sql
Sql Server
Performance
Indexing
Foreign Keys
SQL Server insert if not exists best practice
Sql Server
Insert Update
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 implement LIMIT with SQL Server?
Sql
Sql Server
Migration
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
Call a stored procedure with parameter in c#
C#
asp.net
Sql Server
Stored Procedures
ado.net
Why does using an Underscore character in a LIKE filter give me all the results?
Sql
Sql Server
WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
Sql
Sql Server
Tsql
Check Constraints
Can we pass parameters to a view in SQL?
Sql
Sql Server
Parameters
Parameter Passing
Views
Error in SQL script: Only one statement is allowed per batch
Sql
Sql Server
Visual Studio-2012
Dacpac
How do you effectively model inheritance in a database?
.Net
Sql Server
Oop
Inheritance
Database Design
What is a 'multi-part identifier' and why can't it be bound?
Sql
Sql Server
SQL query to group by day
Sql
Sql Server
Sql Server-2005
Group By
What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?
Sql Server
Database
Tsql
Collation
SQL SERVER: Get total days between two dates
Sql
Sql Server
Sql Server-2008
Date
How to export data as CSV format from SQL Server using sqlcmd?
Sql Server
File
Csv
Sqlcmd
Which are more performant, CTE or temporary tables?
Sql Server
Performance
Sql Server-2008
Temp Tables
Common Table-Expression
SQL Server: Get table primary key using sql query
Sql
Sql Server
What is a reasonable length limit on person "Name" fields?
Html
Sql
Sql Server
Textbox
Limit
What is the best way to auto-generate INSERT statements for a SQL Server table?
Sql Server
Ssms
Code Generation
insert a NOT NULL column to an existing table
Sql Server
Alter Table
Notnull
What are named pipes?
Sql Server
Pipe
Named Pipes
How to delete large data of table in SQL without log?
Sql Server
Sql Server-2008
Sql Optimization
Access is denied when attaching a database
Sql Server
Security
Administration
Difference between Select Unique and Select Distinct
Sql
Sql Server
SQL Server indexes - ascending or descending, what difference does it make?
Sql
Sql Server
Optimization
Indexing
SQL "select where not in subquery" returns no results
Sql
Sql Server
Tsql
A connection was successfully established with the server, but then an error occurred during the pre-login handshake
.Net
Sql Server
Sql Server-2008
ado.net
Database Connection
Reference alias (calculated in SELECT) in WHERE clause
Sql
Sql Server
Tsql
C# Equivalent of SQL Server DataTypes
C#
.Net
Sql Server
Solutions for INSERT OR UPDATE on SQL Server
Sql
Sql Server
Database
Insert
Upsert
How to trim a string in SQL Server before 2017?
Sql
Sql Server
Remove Identity from a column in a table
Sql
Sql Server
Tsql
Alter Table Add Column Syntax
Sql
Sql Server
Tsql
Ddl
How to check if a function exists in a SQL database?
Sql
Sql Server
Sql Function
What is SYSNAME data type in SQL Server?
Sql
Sql Server
Tsql
Types
Get the last inserted row ID (with SQL statement)
Sql
Sql Server
When to use SELECT ... FOR UPDATE?
Mysql
Sql
Sql Server
Transactions
Select for-Update
Case in Select Statement
Sql
Sql Server
Case
Check for changes to an SQL Server table?
Sql
Sql Server
Datatable
Rdbms
How do you open an SDF file (SQL Server Compact Edition)?
Sql Server
Sql Server-Ce
SQL Server Installation - What is the Installation Media Folder?
Sql Server
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
What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
Sql Server
Varchar
Incorrect syntax near ')' calling stored procedure with GETDATE
Sql Server
Tsql
Getdate
SQL Server Output Clause into a scalar variable
Sql Server
Tsql
Is it possible to for SQL Output clause to return a column not being inserted?
Sql
Sql Server
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
SQL Server, convert a named instance to default instance?
Sql Server
Sql Server-2005
Named Instance
T-SQL stored procedure that accepts multiple Id values
Sql Server
Tsql
Stored Procedures
Lock Escalation - What's happening here?
Sql
Sql Server
Sql Server-2008
Naming convention for unique constraint
Sql
Sql Server
Naming Conventions
Unique Constraint
Entity Framework Migrations renaming tables and columns
C#
Sql Server
Entity Framework
Entity Framework-5
Entity Framework-Migrations
What is "with (nolock)" in SQL Server?
Sql Server
Nolock
What is an MDF file?
Mdf
Sql Server
Database
File
SQL : BETWEEN vs <= and >=
Sql
Sql Server
Tsql
Where
Between
How do I drop table variables in SQL-Server? Should I even do this?
Sql
Sql Server
Table Variable
Formatting Numbers by padding with leading zeros in SQL Server
Sql
Sql Server
Tsql
String Formatting
Are GUID collisions possible?
Sql Server
Guid
How can I check if a View exists in a Database?
Sql
Sql Server
Database
Stored Procedures
View
How to connect an existing SQL Server login to an existing SQL Server database user of same name
Sql
Sql Server
How can I create a unique constraint on my column (SQL Server 2008 R2)?
Sql
Sql Server
Sql Server-2008
Unique Constraint
INSERT INTO vs SELECT INTO
Sql Server
Tsql
Sql Server-2008
What's best SQL datatype for storing JSON string?
Sql
Sql Server
Json
What is TEXTIMAGE_ON [PRIMARY]?
Sql Server
Add alternating row color to SQL Server Reporting services report
Sql Server
Reporting Services
Formatting
How to find largest objects in a SQL Server database?
Sql Server
Database
Delete all data in SQL Server database
Sql
Sql Server
Delete Row
Multi Table-Delete
The backend version is not supported to design database diagrams or tables
Sql
Sql Server
Database
Ssms
How can I query a value in SQL Server XML column
Sql
Sql Server
Xml
Xquery
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
EF5: Cannot attach the file ‘{0}' as database '{1}'
Sql Server
asp.net Mvc
Visual Studio-2012
Entity Framework-5
Localdb
"Server" vs "Data Source" in connection string
Sql Server
Connection String
Sqldatasource
Localdb
Row Offset in SQL Server
Sql
Sql Server
Disable Enable Trigger SQL server for a table
Sql Server
Triggers
SQL statement to select all rows from previous day
Sql
Sql Server
Sql Server-2005
How can I schedule a job to run a SQL query daily?
Sql
Sql Server
Database
Sql Server-2008
Sql Job
Real life example, when to use OUTER / CROSS APPLY in SQL
Sql
Sql Server
Sql Server-2008
Sql Server-2005
SQL Update with row_number()
Sql Server
Sql Server-2008-R2
Sql Update
The server principal is not able to access the database under the current security context in SQL Server MS 2012
Sql Server
Sql Server-2012
Insert all values of a table into another table in SQL
Sql
Sql Server
Sql Server-2005
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
How do you clear the SQL Server transaction log?
Sql Server
Transaction Log
How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
Sql
Sql Server
Line Breaks
SQL Server: SELECT only the rows with MAX(DATE)
Sql Server
Select
Max
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
update columns values with column of another table based on condition
Sql
Mysql
Sql Server
Oracle
How to remove not null constraint in sql server using query
Sql Server
Sql
Identity increment is jumping in SQL Server database
Sql
Sql Server
Sql Server-2012
Identity Column
BACKUP LOG cannot be performed because there is no current database backup
Sql Server
Find all table names with column name?
Sql Server
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
Appropriate datatype for holding percent values?
Sql Server
Types
Sqldatatypes
Convert HashBytes to VarChar
Sql
Sql Server
How to detect READ_COMMITTED_SNAPSHOT is enabled?
Sql Server
Isolation Level
Read Committed-Snapshot
Limitations of SQL Server Express
Sql Server
Sql Server-2008-Express
Database Diagram Support Objects cannot be Installed ... no valid owner
Sql Server
Sql Server-2008
Database Diagramming
Login failed for user 'DOMAIN\MACHINENAME$'
.Net
Sql Server
Sql Server-2005
Web Applications
Iis 6
SQL DELETE with INNER JOIN
Mysql
Sql
Sql Server
Inner Join
Sql Delete
Is there a ternary conditional operator in T-SQL?
Sql Server
Tsql
SQL Server ':setvar' Error
Sql
Sql Server
Tsql
How to get first and last day of previous month (with timestamp) in SQL Server
Sql Server
Datetime
Execute Insert command and return inserted Id in Sql
C#
Sql
Sql Server
asp.net Mvc-4
Mapping composite keys using EF code first
C#
Sql Server
Entity Framework
Entity Framework-6
SQL Server Regular expressions in T-SQL
Sql Server
Regex
Tsql
How to strip HTML tags from a string in SQL Server?
Html
Sql
Sql Server
String
Sql Server-2005
Unable to login to SQL Server + SQL Server Authentication + Error: 18456
Sql Server
Sql Server-2008
Getting result of dynamic SQL into a variable for sql-server
Sql
Sql Server
Sql Server-2005
Tsql
Dynamic Sql
Is there any difference between DECIMAL and NUMERIC in SQL Server?
Sql Server
Sqldatatypes
Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'
C#
asp.net
Sql Server
Iis
Web Services
Run all SQL files in a directory
Sql
Sql Server
Batch Processing
Do while loop in SQL Server 2008
Sql Server
Sql Server-2008
Loops
While Loop
Do While
Escape Character in SQL Server
Sql Server
Escaping
Char
Difference between datetime and timestamp in sqlserver?
Sql
Sql Server
Date
Time
How to delete the top 1000 rows from a table using Sql Server 2008?
Sql
Sql Server
Sql Delete
How to get the first and last date of the current year?
Sql
Sql Server
Sql Server-2000
How to use a variable for the database name in T-SQL?
Sql Server
SQL Server IN vs. EXISTS Performance
Sql Server
Sql Server-2005
Exists
Query Performance
Sql In
How much size "Null" value takes in SQL Server
Sql Server
Tsql
Sql Server-2005
Null
Converting Select results into Insert script - SQL Server
Sql
Sql Server
Sql Server-2008
Ssms
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
SQL Server: Database stuck in "Restoring" state
Sql Server
Backup
Restore
What is the difference between Integrated Security = True and Integrated Security = SSPI?
Sql Server
Security
Connection String
Database Security
Difference between clustered and nonclustered index
Sql Server
Database Design
Indexing
Clustered Index
Non Clustered-Index
How do I search an SQL Server database for a string?
Sql Server
Function
Search
Stored Procedures
ExecuteReader requires an open and available Connection. The connection's current state is Connecting
C#
.Net
Sql Server
ado.net
Database Connection
SQL Server Management Studio alternatives to browse/edit tables and run queries
Sql Server
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
LEN function not including trailing spaces in SQL Server
Sql Server
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
SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry
Sql
Sql Server
Sql Server-2012
Identity
SQL: capitalize first letter only
Sql
Sql Server
Favourite performance tuning tricks
Sql
Sql Server
Database
Performance
How to catch SQLServer timeout exceptions
C#
.Net
Sql Server
Error Handling
What is the Oracle equivalent of SQL Server's IsNull() function?
Sql Server
Oracle
Tsql
Plsql
What happens if you don't commit a transaction to a database (say, SQL Server)?
Sql Server
Transactions
Commit
T-SQL query to show table definition?
Sql Server
Tsql
How to truncate string using SQL server
Sql Server
Tsql
How to get difference of days/months/years (datediff) between two dates?
Sql Server
Postgresql
Date
Sql Date-Functions
No process is on the other end of the pipe (SQL Server 2012)
Sql Server
Sql Server-2012
OR is not supported with CASE Statement in SQL Server
Sql
Sql Server
Tsql
Case
Case When
NOT IN vs NOT EXISTS
Sql
Sql Server
Notin
Add a column to existing table and uniquely number them on MS SQL Server
Sql
Sql Server
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
WITH (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Sql
Sql Server
Sql Server-2005
How to make a query with group_concat in sql server
Sql Server
String Aggregation
Sql Server-Group-Concat
SQL to determine minimum sequential days of access?
Sql
Sql Server
Date
Gaps and-Islands
Parse JSON in TSQL
Sql Server
Tsql
Json
Grant execute permission for a user on all stored procedures in database?
Sql
Sql Server
Sql Server-2000
Setting up maven dependency for SQL Server
Sql Server
Hibernate
Maven
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
How to change a table name using an SQL query?
Sql
Sql Server
Sql Server-2005
Changing the size of a column referenced by a schema-bound view in SQL Server
Sql
Sql Server
Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
Sql Server
Tsql
Sql Server-2005
Insert
Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
Sql
Sql Server
Max
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
SQL Server Management Studio won't let me add an index to a table
Sql Server
Sql Server-2008
Sql Server-2012
Ssms
Sql Server-2014
Connection to SQL Server Works Sometimes
Sql Server
ado.net
How to quickly edit values in table in SQL Server Management Studio?
Sql
Sql Server
Ssms
T-SQL datetime rounded to nearest minute and nearest hours with using functions
Sql
Sql Server
Tsql
Sql Server-2008
SQL Server reports 'Invalid column name', but the column is present and the query works through management studio
Sql
Sql Server
Is there a way to access the "previous row" value in a SELECT statement?
Sql
Sql Server
Sql Server-2008
How do I change db schema to dbo
Sql
Sql Server
Database
Sql Server-2008
Schema
What is a good reason to use SQL views?
Sql
Sql Server
"CASE" statement within "WHERE" clause in SQL Server 2008
Sql
Sql Server
Case
Select values from XML field in SQL Server 2008
Sql Server
Xml
Xpath
Querying data by joining two tables in two database on different servers
Sql
Sql Server
Database
Sql Server-2005
Sql Server-2008
Declare variable in table valued function
Sql Server
Function
User Defined-Functions
The transaction log for the database is full
Sql
Sql Server
Sql Server-2008
Dynamics Crm
"The transaction log for database is full due to 'LOG_BACKUP'" in a shared host
asp.net
Sql Server
asp.net Mvc
Database
C# equivalent of the IsNull() function in SQL Server
C#
.Net
Sql Server
Isnull
efficient way to implement paging
Sql
Sql Server
asp.net Mvc
Linq to-Sql
Pagination
Datatype for storing ip address in SQL Server
Sql Server
Tsql
Sql Server-2005
Types
Ip Address
SQL Server Script to create a new user
Sql
Sql Server
Database
Is having an 'OR' in an INNER JOIN condition a bad idea?
Sql
Sql Server
Sql Server-2008
Tsql
Inner Join
Why do we always prefer using parameters in SQL statements?
Sql
Sql Server
Sql Injection
Cause of a process being a deadlock victim
Sql Server
Deadlock
GROUP BY to combine/concat a column
Sql
Sql Server
Sql Server-2008
Group By
Replace duplicate spaces with a single space in T-SQL
Sql Server
Tsql
Create table (structure) from existing table
Sql Server
How to concatenate text from multiple rows into a single text string in SQL Server
Sql
Sql Server
Csv
String Concatenation
Group Concat
Best approach to remove time part of datetime in SQL Server
Sql
Sql Server
Tsql
Datetime
Date
SQL-Server: The backup set holds a backup of a database other than the existing
Sql Server
SQL Server equivalent to Oracle's CREATE OR REPLACE VIEW
Sql Server
Procedure expects parameter which was not supplied
.Net
Sql Server
Stored Procedures
SQL Server - where is "sys.functions"?
Sql
Sql Server
Sql Server-2005
Stored Functions
Execution sequence of Group By, Having and Where clause in SQL Server?
Sql
Sql Server
Sql Server-2005
varbinary to string on SQL Server
Sql
Sql Server
Sql Server-2005
Tsql
In SQL Server, when should you use GO and when should you use semi-colon ;?
Sql
Sql Server
Can I change a column from NOT NULL to NULL without dropping it?
Sql Server
Generate random int value from 3 to 6
Sql
Sql Server
Sql Server-2008
Subtract one day from datetime
Sql
Sql Server
Datetime
SQL Server: Get data for only the past year
Sql
Sql Server
Database
Tsql
What columns generally make good indexes?
Sql Server
Database
Optimization
Database Design
Indexing
Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
Sql Server
Sql Server-2008
Code Reuse
Cannot drop database because it is currently in use
C#
asp.net
Sql Server
How To Create Table with Identity Column
Sql
Sql Server
Tsql
Should I index a bit field in SQL Server?
Sql Server
Indexing
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 create materialized views in SQL Server?
Sql Server
Database Design
Indexed View
Is there a way to list open transactions on SQL Server 2000 database?
Sql
Sql Server
Transactions
Sql Server-2000
Create a nonclustered non-unique index within the CREATE TABLE statement with SQL Server
Sql Server
How do I find duplicates across multiple columns?
Sql
Sql Server
Sql Server-2008
Duplicates
How to kill/stop a long SQL query immediately?
Sql
Sql Server
Sql Server-2008
Backup a single table with its data from a database in sql server 2008
Sql
Sql Server
Sql Server-2008
Best way to store time (hh:mm) in a database
Sql Server
Database
Database Design
Datetime
Return rows in random order
Sql
Sql Server
Tsql
How can I alter a primary key constraint using SQL syntax?
Sql
Sql Server
Primary Key
Composite Primary-Key
SQL Server CTE and recursion example
Sql Server
Common Table-Expression
unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
Sql
Sql Server
Tsql
Sql Server-Data-Tools
The target principal name is incorrect. Cannot generate SSPI context
Sql Server
Tfs
Kerberos
Sspi
Spn
How do I enable MSDTC on SQL Server?
Sql Server
Msdtc
Simplest way to do a recursive self-join?
Sql
Sql Server
Recursion
Hierarchical Data
Self Join
How to convert int to char with leading zeros?
Sql Server
Stored Procedures
alternatives to REPLACE on a text or ntext datatype
Sql
Sql Server
Tsql
How to add Active Directory user group as login in SQL Server
Sql Server
Sql Server-2008
Security
Authentication
Search of table names
Sql
Sql Server
Sql Server-2008-R2
Optimal way to concatenate/aggregate strings
Sql
Sql Server
Azure
Aggregate Functions
Azure Sql-Database
SQL function as default parameter value?
Sql
Sql Server
Stored Procedures
How to select bottom most rows?
Sql
Sql Server
Database
Select
Keyword
How to force a SQL Server 2008 database to go Offline
Sql
Sql Server
Tsql
Sql Server-2008
How do I do an insert with DATETIME now inside of SQL server mgmt studio
Sql Server
Datetime
Connection timeout for SQL server
C#
asp.net
Sql Server
ado.net
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
The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
Sql Server
Azure Sql-Database
I cannot start SQL Server browser
Sql Server
Sql Server-2008
64 Bit
What is the best way to paginate results in SQL Server
Sql
Sql Server
Performance
Pagination
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
Sql Server
Sql Server-2005
Tsql
Truncate
Foreign Keys
SQL Server: Make all UPPER case to Proper Case/Title Case
Sql
Sql Server
Uppercase
Title Case
How can I run just the statement my cursor is on in SQL Server Management Studio?
Sql Server
Database
Editor
SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
Sql Server
SQL Server 2008: how do I grant privileges to a username?
Sql
Sql Server
Sql Server-2008
Ssms
How can I set an SQL Server connection string?
C#
Sql Server
Connection String
Sa
SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Sql Server
Tsql
Datetime
UPDATE and REPLACE part of a string
Sql
Sql Server
String
Sql Server-2008
Replace
SQL - Query to get server's IP address
Sql
Sql Server
Get the week start date and week end date from week number
Sql
Sql Server
Date
Sql Server-2005
Week Number
Aggregate function in an SQL update query?
Sql
Sql Server
Tsql
Add Foreign Key relationship between two Databases
Sql
Sql Server
Tsql
Foreign Keys
How to print GETDATE() in SQL Server with milliseconds in time?
Sql
Sql Server
Sql Server-2008
Datetime
Getdate
COALESCE Function in TSQL
Sql
Sql Server
Sql Server-2008
Tsql
sql primary key and index
Sql
Sql Server
Tsql
Indexing
Primary Key
Avoiding SQL injection without parameters
C#
asp.net
Sql Server
Sql Injection
How to find the port for MS SQL Server 2008?
Sql Server
Sql Server-2008
Top 1 with a left join
Sql Server
Outer Join
Partition Function COUNT() OVER possible using DISTINCT
Sql
Sql Server
Tsql
Sql Server-2008-R2
Sql Server-2014
Auto increment primary key in SQL Server Management Studio 2012
Sql Server
Sql Server-2012
Identity
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 to do a Postgresql subquery in select clause with join in from clause like SQL Server?
Sql
Sql Server
Postgresql
Subquery
How do I use the CONCAT function in SQL Server 2008 R2?
Sql Server
Sql Server-2008
Tsql
Set a DateTime database field to "Now"
Sql Server
vb.net
Current executing procedure name
Sql Server
Sql Server-2008
Tsql
Stored Procedures
Retrieve the maximum length of a VARCHAR column in SQL Server
Sql
Sql Server
String Length
Maxlength
SQL update trigger only when column is modified
Sql
Sql Server
Triggers
Selecting COUNT(*) with DISTINCT
Sql
Sql Server
Sql Server-2005
Tsql
What is the significance of 1/1/1753 in SQL Server?
Sql Server
Tsql
Datetime
Localization
Internationalization
Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
Sql Server
Spring
Maven
pom.xml
Insert Update stored proc on SQL Server
Sql
Sql Server
Stored Procedures
Upsert
How do I alter the precision of a decimal column in Microsoft SQL Server?
Sql Server
SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?
Sql Server
Backup
Restore
How can I automate the "generate scripts" task in SQL Server Management Studio 2008?
Sql Server
Visual Studio-2008
Automation
Ssms
Sql Server-2008
How to determine the number of days in a month in SQL Server?
Sql
Sql Server
Datetime
Date
User Defined-Functions
Return number of rows affected by UPDATE statements
Sql
Sql Server
Create SQL script that create database and tables
Sql
Sql Server
Using RegEx in SQL Server
Sql Server
Regex
Sql Server-2008
Tsql
SQL Server Linked Server Example Query
Sql Server
Linked Server
Is there a way to retrieve the view definition from a SQL Server using plain ADO?
Sql Server
Ado
How do I split a string so I can access item x?
Sql
Sql Server
Tsql
Split
How to convert SQL Server's timestamp column to datetime format
Sql Server
Datetime
Timestamp
How to find SQL Server running port?
Sql Server
Sql Server-2008
Connection String
How to convert a datetime to string in T-SQL
Sql Server
Tsql
How to find third or nᵗʰ maximum salary from salary table?
Sql
Sql Server
Sql Server-2008
How to get current instance name from T-SQL
Sql
Sql Server
Tsql
Sql Server-2008r2-Express
What's the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
Sql Server
Sql Server-2008
Latitude Longitude
Spatial
Like Operator in Entity Framework?
.Net
Sql Server
Entity Framework
Linq to-Entities
Using StringWriter for XML Serialization
C#
Sql Server
Xml
Utf 8
Xml Serialization
How to map an entity field whose name is a reserved word in JPA
Java
Sql Server
Hibernate
Orm
Jpa
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
Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)
Sql Server
Sql Server-2008
Sql Server-2012
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
How to create a unique index on a NULL column?
Sql
Sql Server
Indexing
Constraints
Unique
What is PAGEIOLATCH_SH wait type in SQL Server?
Sql Server
Tsql
Optimization
SQL Server datetime LIKE select?
Sql Server
Sql Like
Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
Sql Server
Types
Pad a string with leading zeros so it's 3 characters long in SQL Server 2008
Sql Server
Tsql
Adding an identity to an existing column
Sql
Sql Server
Alter Table
Identity Column
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
Sql Server
Sql Server-2008
Ssms
SQL NVARCHAR and VARCHAR Limits
Sql
Sql Server
Sql Server-2008
Variables
String Concatenation
Relationship of Primary Key and Clustered Index
Sql
Sql Server
Database
Database Design
How to query DATETIME field using only date in Microsoft SQL Server?
Sql Server
Datetime
How to copy a row from one SQL Server table to another
Sql
Sql Server
INSERT vs INSERT INTO
Sql
Sql Server
Tsql
conditional unique constraint
Sql
Sql Server
Sql Server-2005
Get first day of week in SQL Server
Sql Server
Tsql
Sql Server-2008
Date
Unable to begin a distributed transaction
Sql Server
Sql Server-2005
Msdtc
Distributed Transactions
How do I grant myself admin access to a local SQL Server instance?
Sql
Sql Server
Sql Server-2008
Ssms
Sqlcmd
Calculating distance between two points (Latitude, Longitude)
Sql
Sql Server
Tsql
Math
Sql Server-2008-R2
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
Sql
Sql Server
Database
Sql Server-2012
Sql Query-Store
SQL Server - When to use Clustered vs non-Clustered Index?
Sql Server
Indexing
Clustered Index
Non Clustered-Index
Query Tuning
SQL Server: Invalid Column Name
Sql
Sql Server
Sql Server-2008
Stored Procedures
Is it possible to specify condition in Count()?
Sql
Sql Server
Tsql
Horrible performance using SqlCommand Async methods with large data
C#
.Net
Sql Server
Asynchronous
Async Await
What is a simple command line program or script to backup SQL server databases?
Sql Server
Command Line
Scripting
Backup
How to read the last row with SQL Server
Sql
Sql Server
What's the best way to select the minimum value from several columns?
Sql
Sql Server
Tsql
Sql Server-2005
Min
Dynamic SQL - EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
Sql
Sql Server
Dynamic
SQL server ignore case in a where expression
Sql
Sql Server
Where Clause
Case Insensitive
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
Drop a temporary table if it exists
Sql
Sql Server
Could not obtain information about Windows NT group/user
Sql Server
Sql Server-2008
Sharepoint
Execute a large SQL script (with GO commands)
C#
Sql Server
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
SCOPE_IDENTITY() for GUIDs?
Sql
Sql Server
Guid
Uniqueidentifier
Scope Identity
Use a LIKE statement on SQL Server XML Datatype
Sql
Sql Server
Xml
Sql Server-2005
SQL Server function to return minimum date (January 1, 1753)
Sql Server
Datetime
Function
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
Can you have if-then-else logic in SQL?
Sql
Sql Server
How to query for Xml values and attributes from table in SQL Server?
Sql Server
Xml
Sql Server-2005
Sql Server-2008-R2
Sqlxml
Confused about UPDLOCK, HOLDLOCK
Sql Server
Tsql
Sql Server-2008
Concurrency
Locking
How to insert a C# List to database using Dapper.NET
C#
Sql Server
Dapper
JDBC connection failed, error: TCP/IP connection to host failed
Java
Sql Server
Jdbc
Query comparing dates in SQL
Sql
Sql Server
Date
Compare
SQL Server IIF vs CASE
Sql Server
Sql Server-2012
Case
Iif
How to determine total number of open/active connections in ms sql server 2005
Sql Server
Database
Sql Server-2005
Connection
T-SQL: Looping through an array of known values
Sql
Sql Server
Tsql
What is the point of "Initial Catalog" in a SQL Server connection string?
Sql Server
Database
Sql Server-2005
Connection String
Database Connection
WHERE clause on SQL Server "Text" data type
Sql Server
Sql Server-2005
Tsql
Rename a constraint in SQL Server?
Sql
Sql Server
Constraints
Column "invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause"
Sql Server
Group By
Printing integer variable and string on same line in SQL
Sql
Sql Server
Tsql
Can I logically reorder columns in a table?
Sql Server
Is there a way to make a TSQL variable constant?
Sql Server
Tsql
Script entire database SQL-Server
Sql
Sql Server
Sql Server-2008
SQL Server tables: what is the difference between @, # and ##?
Sql Server
What are database constraints?
Sql
Sql Server
Constraints
Rdbms
Does the order of columns matter in a group by clause?
Sql
Sql Server
Group By
Declare Variable for a Query String
Sql
Sql Server
Sql Server-2005
Tsql
Dynamic Sql
How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
Sql Server
Sql Server-2005
Why doesn't SQL Server support unsigned datatype?
Sql
Sql Server
Sqldatatypes
Unsigned Integer
The SqlParameter is already contained by another SqlParameterCollection - Does using() {} cheat?
C#
.Net
Sql Server
ado.net
Why use the INCLUDE clause when creating an index?
Sql Server
Sql Server-2008
Sql Server-2005
Indexing
SQL Client for Mac OS X that works with MS SQL Server
Sql Server
Macos
Table and Index size in SQL Server
Sql Server
Is there a way to persist a variable across a go?
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Sql Server-2000
Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
Sql Server
Primary Key
Scope Identity
Received an invalid column length from the bcp client for colid 6
C#
.Net
Sql Server
Database
Sql Server-2005
Difference between #temptable and ##TempTable?
Sql Server
Temp
Regex pattern inside SQL Replace function?
Sql Server
Regex
MultipleActiveResultSets=True or multiple connections?
C#
.Net
Sql Server
Sql Server-2005
ado.net
Select columns from result set of stored procedure
Sql Server
Tsql
Select
Stored Procedures
How do I write LINQ's .Skip(1000).Take(100) in pure SQL?
.Net
Sql
Sql Server
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
How to generate a new Guid in stored procedure?
Sql
Sql Server
Stored Procedures
SQL Server: How to check if CLR is enabled?
Sql
Sql Server
Clr
Multiple rows to one comma-separated value in Sql Server
Sql Server
Sql Server-Group-Concat
Good way to use table alias in Update statement?
Sql Server
How to escape strings in SQL Server using PHP?
Php
Sql Server
Escaping
Sanitization
Equivalent of Oracle's RowID in SQL Server
Sql
Sql Server
Tsql
Rowid
Row Number
SQL SELECT multi-columns INTO multi-variable
Sql
Sql Server
Teradata
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
Number of times a particular character appears in a string
Sql Server
Exporting data In SQL Server as INSERT INTO
Sql
Sql Server
Insert
Data Migration
Update query using Subquery in Sql Server
Sql
Sql Server
Tsql
Sql Update
Calculated column in EF Code First
C#
Sql Server
Ef Code-First
Entity Framework-5
Calculated Columns
What datatype should be used for storing phone numbers in SQL Server 2005?
Sql Server
Indexing
SQL Server: PRINT output doesn't appear immediately
Sql Server
How to calculate difference in hours (decimal) between two dates in SQL Server?
Sql Server
Tsql
Datetime
Decimal
Import MySQL database into a SQL Server
Mysql
Sql Server
SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=
Sql
Sql Server
Tsql
Best data store for billions of rows
Sql Server
Nosql
Should programmers use SSIS, and if so, why?
C#
.Net
Sql Server
Ssis
SQL Server: What are batching statements (i.e. using "GO") good for?
Sql Server
Tsql
Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF
Sql
Sql Server
Sybase
SQL MAX of multiple columns?
Sql
Sql Server
Tsql
Nested select statement in SQL Server
Sql
Sql Server
Nested
Subquery
Querying
how can I Update top 100 records in sql server
Sql
Sql Server
Tsql
Sql Update
Oracle: is there a tool to trace queries, like Profiler for sql server?
Sql Server
Oracle
Profiler
Random record from a database table (T-SQL)
Sql Server
Tsql
Random
Must declare the scalar variable
Sql
Sql Server
Stored Procedures
SQL Server GROUP BY datetime ignore hour minute and a select with a date and sum value
Sql Server
Datetime
Select
Group By
Sequence vs identity
Sql
Sql Server
Tsql
Sql Server-2012
The database owner SID recorded in the master database differs from the database owner SID
Sql Server
Clrstoredprocedure
Tsqlt
SQL Server database restore error: specified cast is not valid. (SqlManagerUI)
Sql Server
Sql Server-2008
Database Restore
How to generate auto increment field in select query
Sql Server
Auto Increment
Is there a LastIndexOf in SQL Server?
Sql
Sql Server
Sql Server-2016
Get month and year from a datetime in SQL Server 2005
Sql
Sql Server
Why does Sql Server keep executing after raiserror when xact_abort is on?
Sql
Sql Server
Tsql
VarBinary vs Image SQL Server Data Type to Store Binary Data?
Sql Server
Table-level backup
Sql Server
Backup
Database Table
Subquery using Exists 1 or Exists *
Sql
Sql Server
Tsql
Is there a way to suppress "x rows affected" in SQLCMD from the command line?
Sql Server
Rows
Sqlcmd
Suppress
Database Naming Conventions by Microsoft?
Sql
Sql Server
Tsql
How to export SQL Server database to MySQL?
Mysql
Sql Server
Database Migration
How can I fill a column with random numbers in SQL? I get the same value in every row
Sql Server
use current date as default value for a column
Sql
Sql Server
Dapper.NET and stored proc with multiple result sets
Sql Server
Stored Procedures
Dapper
Multiple Resultsets
How to install SQL Server Management Studio 2012 (SSMS) Express?
Sql Server
Database
Installation
Ssms
ListAGG in SQLSERVER
Sql
Sql Server
Aggregate
Is it necessary to use # for creating temp tables in SQL server?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Functions vs Stored Procedures
Sql
Sql Server
Database
Function
Stored Procedures
How to execute an SSIS package from .NET?
C#
.Net
Sql Server
vb.net
Ssis
SQL Server Plans : difference between Index Scan / Index Seek
Sql
Sql Server
Sql Execution-Plan
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 String Concatenation with Null
Sql Server
Null
String Concatenation
Calculated Columns
What is the difference between Trusted_Connection and Integrated Security in a connection string?
Sql Server
Connection String
SQL grouping by month and year
Sql
Sql Server
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
Rounding SQL DateTime to midnight
Sql
Sql Server
Sql Server-2005
Getdate
How do you specify a different port number in SQL Management Studio?
Sql Server
Sql Server-2005
Ssms
Efficiently convert rows to columns in sql server
Sql
Sql Server
Sql Server-2008
Pivot
Cannot Connect to Server - A network-related or instance-specific error
Sql Server
Visual Studio
Database Connection
What is the meaning of the prefix N in T-SQL statements and when should I use it?
Sql
Sql Server
Tsql
How to Use UTF-8 Collation in SQL Server database?
Sql Server
Utf 8
Understanding SQL Server LOCKS on SELECT queries
Sql Server
Tsql
Linq to-Sql
The parameterized query ..... expects the parameter '@units', which was not supplied
C#
Sql Server
Exception
How to export data from SQL Server 2005 to MySQL
Mysql
Sql Server
Csv
Sql Server-2005
Bcp
How do I do a simple 'Find and Replace" in MsSQL?
Sql
Sql Server
how to get the 30 days before date from Todays Date
Sql
Sql Server
Datetime
SQL Server: how to constrain a table to contain a single row?
Sql Server
Database Design
Singleton
Understanding PIVOT function in T-SQL
Sql Server
Sql Server-2008
Tsql
Pivot
Can I have a foreign key referencing a column in a view in SQL Server?
Sql Server
View
Foreign Keys
What is the recommended batch size for SqlBulkCopy?
.Net
Sql Server
Performance
ado.net
Why use Select Top 100 Percent?
Sql
Sql Server
Tsql
Difference of two date time in sql server
Sql
Sql Server
Datetime
How to escape simple SQL queries in C# for SqlServer
C#
Sql
Sql Server
Table-Valued Function(TVF) vs. View
Sql Server
Sql View
Sql Function
Improve SQL Server query performance on large tables
Sql
Sql Server
Sql Server-2008
Changing SqlConnection timeout
C#
.Net
Sql Server
Sqlconnection
Storing files in SQL Server
Sql Server
SQL Server JOIN missing NULL values
Sql
Sql Server
SQL Coalesce with empty string
Sql
Sql Server
Select Top 1 field and assign to local variable
Sql
Sql Server
How to compare datetime with only date in SQL Server
Sql
Sql Server
Tsql
Datetime
How to select all the columns of a table except one column?
Sql
Sql Server
A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
Sql Server
Sql Server-2008-R2
How Stuff and 'For Xml Path' work in SQL Server?
Sql
Sql Server
For Xml-Path
Stuff
How to use GROUP BY to concatenate strings in SQL Server?
Sql
Sql Server
String Concatenation
Sql Server-Group-Concat
What is the use of GO in SQL Server Management Studio & Transact SQL?
Sql Server
Tsql
Ssms
ALTER TABLE DROP COLUMN failed because one or more objects access this column
C#
Sql
Sql Server
Code First
SQL Server 2005 implementation of MySQL REPLACE INTO?
Mysql
Sql Server
Sql Server-2005
Generate SQL Create Scripts for existing tables with Query
Sql
Sql Server
Tsql
How to insert into a table with just one IDENTITY column?
Sql
Sql Server
Identity
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
Sql
Sql Server
Stored Procedures
What's the best way to test SQL Server connection programmatically?
C#
Sql Server
Database Connectivity
How do you update a DateTime field in T-SQL?
Sql
Sql Server
Tsql
Types
mssql '5 (Access is denied.)' error during restoring database
Sql Server
Ssms
Database design: Calculating the Account Balance
Sql Server
Database
Sql Server-2008
Database Design
ASP.NET CLR Not Enabled
asp.net
Sql Server
Clr
Calling stored procedure with return value
C#
Sql Server
Stored Procedures
ado.net
Return Value
When increasing the size of VARCHAR column on a large table could there be any problems?
Sql Server
Sql Server-2008
Varchar
Alter Column
How to view the stored procedure code in SQL Server Management Studio
Sql Server
Tsql
Ssms
Delete statement in SQL is very slow
Sql
Sql Server
Sql Server-2008
Database Optimization
Cannot login after creating the user in SQL Server
Sql Server
Cannot use UPDATE with OUTPUT clause when a trigger is on the table
Sql
Sql Server
Sql Server-2008-R2
Last executed queries for a specific database
Sql Server
Sql Server-2012
String or binary data would be truncated. The statement has been terminated
Sql
Sql Server
Getting the current date in SQL Server?
Sql
Sql Server
Sql Server-2008
Datetime
Current Time
Entity Framework 6 transaction rollback
C#
Sql Server
Entity Framework
Transactions
Entity Framework-6
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
Get list of databases from SQL Server
Sql Server
Use of SqlParameter in SQL LIKE clause not working
C#
Sql Server
Tsql
ado.net
Sql Like
DateTime's representation in milliseconds?
C#
Sql Server
Datetime
How to get export output in "real" CSV format in SQL Server Management Studio?
Sql
Sql Server
Csv
Ssms
SQL Server Profiler : How to specify multiple values for "NOT LIKE" column filter
Sql Server
Profiler
How to use SQL Select statement with IF EXISTS sub query?
Sql
Sql Server
Exists
Query to get only numbers from a string
Sql
Sql Server
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column
Sql Server
Sql Server-2008
Ssis
Etl
How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?
Sql Server
Entity Relationship
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
How to monitor SQL Server table changes by using c#?
C#
Sql Server
Monitoring
How to create jobs in SQL Server Express edition
Sql Server
Sql Server-2008-Express
Sql Job
Why is SQL server throwing this error: Cannot insert the value NULL into column 'id'?
Sql
Sql Server
Transfer data from one database to another database
Sql
Sql Server
Sql Server-2008
Export table data from one SQL Server to another
Sql
Sql Server
Sql Server-2005
Export
SQL Server Management Studio 17 cannot find one or more components
Sql Server
Visual Studio
How to remove the time portion of a datetime value (SQL Server)?
Sql Server
Datetime
Date Conversion
Storing a file in a database as opposed to the file system?
Sql Server
Database
Filesystems
Storage
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
Tinyint vs Bit?
Sql
Mysql
Sql Server
Types
Does a foreign key automatically create an index?
Sql Server
SQL Server SELECT into existing table
Sql
Sql Server
Tsql
Stored Procedures
How do I query for all dates greater than a certain date in SQL Server?
Sql
Sql Server
Datetime
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 NOT IN not working
Sql
Sql Server
Convert a SQL Server datetime to a shorter date format
Sql Server
Tsql
Datetime
How do you check if IDENTITY_INSERT is set to ON or OFF in SQL Server?
Sql
Sql Server
Identity Insert
Altering user-defined table types in SQL Server
Sql Server
User Defined-Types
What is the equivalent SQL Server type for the C# long type?
C#
Sql Server
Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
Sql
Sql Server
Csv
How to get the list of all database users
Sql Server
SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance
C#
asp.net
Sql Server
How long should SET READ_COMMITTED_SNAPSHOT ON take?
Sql Server
Isolation Level
Read Committed-Snapshot
ORDER BY items must appear in the select list if SELECT DISTINCT is specified
Sql
Sql Server
Tsql
DBCC CHECKIDENT Sets Identity to 0
Sql
Sql Server
Forcing a query timeout in SQL Server
Sql Server
Testing
Timeout
Locking
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
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
Sql Server
Get Multiple Values in SQL Server Cursor
Sql
Sql Server
Tsql
Database Cursor
How can I show the table structure in SQL Server query?
Sql Server
What is the difference between IFNULL and COALESCE in MySQL?
Mysql
Sql
Sql Server
How do I create a new user in a SQL Azure database?
Sql Server
Azure
Azure Sql-Database
The database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported
Sql Server
Visual Studio
How do I flip a bit in SQL Server?
Sql
Sql Server
Bit Manipulation
Escape a string in SQL Server so that it is safe to use in LIKE expression
Sql Server
Tsql
Stored Procedures
Sql Like
Disable Transaction Log
Sql Server
Sql Server-2008
What should be the best way to store a percent value in SQL-Server?
Sql
Sql Server
Tsql
Types
Move SQL data from one table to another
Sql
Sql Server
Can I have an optional OUTPUT parameter in a stored procedure?
Sql Server
Stored Procedures
Data Access
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
How to avoid the "divide by zero" error in SQL?
Sql
Sql Server
Sql Server-2005
Sql Server-2008
Select statement to find duplicates on certain fields
Sql
Sql Server
Tsql
Sql Server-2008
SQL Server - boolean literal?
Sql
Sql Server
Boolean
Literals
select unique rows based on single distinct column
Sql Server
Tsql
exec failed because the name not a valid identifier?
Sql
Sql Server
Sql Server-2008
Why is 199.96 - 0 = 200 in SQL?
Sql Server
Tsql
Precision
Sql Server-2016
Sqldatatypes
Diagnosing Deadlocks in SQL Server 2005
Sql Server
Sql Server-2005
Deadlock
SQL Server: the maximum number of rows in table
Sql Server
Database Design
SQL Error with Order By in Subquery
Sql Server
Sql Order-By
Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?
Sql Server
Types
Boolean
SELECT INTO a table variable in T-SQL
Sql Server
Tsql
Insert
Table Variable
Conversion of a datetime2 data type to a datetime data type results out-of-range value
C#
Sql Server
Entity Framework
Datetime
Orm
SQL Server Escape an Underscore
Sql Server
Is a single SQL Server statement atomic and consistent?
Sql Server
Sql Server-2008-R2
How to create a Date in SQL Server given the Day, Month and Year as Integers
Sql
Sql Server
In SQL Server, how do I generate a CREATE TABLE statement for a given table?
Sql Server
Scripting
Dynamic Sql
How do I concatenate text in a query in sql server?
Sql
Sql Server
Difference between drop table and truncate table?
Sql
Sql Server
Sybase
"The operation is not valid for the state of the transaction" error and transaction scope
C#
.Net
Sql Server
Transactions
Transactionscope
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
Last Run Date on a Stored Procedure in SQL Server
Sql Server
When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
Sql Server
Unicode
Collation
Nvarchar
What does a transaction around a single statement do?
Sql
Sql Server
Transactions
How do I return the SQL data types from my query?
Sql
Sql Server
Tsql
Sql Server-2008
Change a Nullable column to NOT NULL with Default Value
Sql
Sql Server
Default Value
Alter Table
Alter Column
How to rename a table in SQL Server?
Sql Server
Rename
Alter Table
What's the difference between a temp table and table variable in SQL Server?
Sql Server
Temp Tables
Table Variable
Get day of week in SQL Server 2005/2008
Sql
Sql Server
Datetime
UPDATE OUTPUT into a variable
Sql Server
How can I include null values in a MIN or MAX?
Sql
Sql Server
Tsql
How to directly execute SQL query in C#?
C#
.Net
Sql Server
Batch File
SQL count rows in a table
Sql Server
Count
Rows
Database Table
Rebuild all indexes in a Database
Sql
Sql Server
Indexing
Sql Server-2008-R2
How to update rows with a random date
Sql
Sql Server
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
What's the difference between a Primary Key and Identity?
Sql Server
Add column to table and then update it inside transaction
Sql
Sql Server
Tsql
Transactions
Alter Table
How does SQLParameter prevent SQL Injection?
.Net
Sql Server
Security
TABLOCK vs TABLOCKX
Sql Server
Tsql
Is there a combination of "LIKE" and "IN" in SQL?
Sql
Sql Server
Oracle
Tsql
Plsql
Can a foreign key be NULL and/or duplicate?
Sql
Sql Server
Oracle
Foreign Keys
Best way to create a temp table with same columns and type as a permanent table
Sql
Sql Server
SQL Server 2012 can't start because of a login failure
Sql Server
Permissions
Installation
Sql Server-2012
How to return the output of stored procedure into a variable in sql server
Sql
Sql Server
Variables
Stored Procedures
How to display two digits after decimal point in SQL Server
Sql Server
Sql Server-2008
Sqldatatypes
Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
Sql Server
Linux
Tcpclient
SQL: How to get the id of values I just INSERTed?
Sql Server
How do I perform a GROUP BY on an aliased column in SQL Server?
Sql
Sql Server
Tsql
Syntax
Delete the 'first' record from a table in SQL Server, without a WHERE condition
Sql
Sql Server
How do I find out what is hammering my SQL Server?
Sql Server
Performance
Cpu Usage
Simple check for SELECT query empty result
Sql
Sql Server
Database
Should every SQL Server foreign key have a matching index?
Sql
Sql Server
Tsql
SQL Server - inner join when updating
Sql Server
Inner Join
Is a view faster than a simple query?
Sql
Sql Server
Performance
DBCC SHRINKFILE on log file not reducing size even after BACKUP LOG TO DISK
Sql Server
Backup
Transaction Log
Dbcc
Is varchar(MAX) always preferable?
Sql
Sql Server
Tsql
Comparing results with today's date?
Sql
Sql Server
Current Time
Update records in table from CTE
Sql
Sql Server
Tsql
Common Table-Expression
Get RETURN value from stored procedure in SQL
Sql
Sql Server
Insert 2 million rows into SQL Server quickly
C#
asp.net
Sql Server
Database
ado.net
Export table from database to csv file
Javascript
Sql Server
Database
Csv
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
What is "Connect Timeout" in sql server connection string?
Sql
Sql Server
Determine SQL Server Database Size
Sql Server
Tsql
Convert integer to hex and hex to integer
Sql
Sql Server
Integer
Hex
Add row to query result using select
Sql
Sql Server
Tsql
Select
Insert
Fuzzy matching using T-SQL
Sql Server
Tsql
Fuzzy Search
Why should I use int instead of a byte or short in C#
C#
asp.net
Sql Server
Types
What do the different RAISERROR severity levels mean?
Sql Server
Raiserror
How to flip bit fields in T-SQL?
Sql
Sql Server
Tsql
How do I find the data directory for a SQL Server instance?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Sql Server-2008-R2
MySQL vs. SQL Server vs. Oracle
Mysql
Sql Server
Oracle
Why SQL Server throws Arithmetic overflow error converting int to data type numeric?
Sql Server
Variables
Types
Numeric
SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105)
Sql Server
Backup
SQL Server Profiler - How to filter trace to only display events from one database?
Sql Server
Profiler
Sql Server-Profiler
Selecting data from two different servers in SQL Server
Sql
Sql Server
Tsql
SQL Server: Null VS Empty String
Sql Server
SQL Server Invalid Column name after adding new column
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2005
BULK INSERT with identity (auto-increment) column
Sql Server
Bulkinsert
Identity Column
How to execute .sql file using powershell?
Sql
Sql Server
Powershell
Powershell Module
How to find sum of multiple columns in a table in SQL Server 2005?
Sql
Sql Server
Sql Server-2005
Use float or decimal for accounting application dollar amount?
Sql Server
vb.net
Database Design
Currency
Accounting
Preferred Method of Storing Passwords In Database
Sql Server
Database
Security
Encryption
Passwords
What is the best way to create and populate a numbers table?
Sql Server
Sql Server-2005
How can I convert ticks to a date format?
C#
asp.net
Sql Server
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
Table Naming Dilemma: Singular vs. Plural Names
Sql
Sql Server
Naming Conventions
How to SELECT FROM stored procedure
Sql
Sql Server
Sql Server-2005
Stored Procedures
Difference between numeric, float and decimal in SQL Server
Sql
Sql Server
Types
SQL Join Table Naming Convention
Sql
Sql Server
Naming Conventions
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
How do I list all tables in all databases in SQL Server in a single result set?
Sql Server
Metadata
SQL Server: combining multiple rows into one row
Sql Server
Sql Server-2008
Tsql
List rows after specific date
Sql
Sql Server
Sql Server-2008
Sql Server-2005
How to remove foreign key constraint in sql server?
Sql Server
Database
Foreign Keys
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
How to remove a column from an existing table?
Sql Server
Most efficient way in SQL Server to get date from date+time?
Sql
Sql Server
Tsql
Is it possible to use Full Text Search (FTS) with LINQ?
Sql Server
Linq
Full Text-Search
Paste MS Excel data to SQL Server
Sql Server
Excel
Copy Paste
how do you insert null values into sql server
Sql
Sql Server
Null
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
Read committed Snapshot VS Snapshot Isolation Level
Sql Server
Snapshot
Isolation Level
Read Committed-Snapshot
Only inserting a row if it's not already there
Sql
Sql Server
Tsql
Concurrency
Locking
How to word wrap in SQL Server Management Studio
Sql Server
Editor
Ssms
Create parameterized VIEW in SQL Server 2008
Sql
Sql Server
Can't see the triggers that I created in SQL Server Management Studio 2008
Sql Server
Sql Server-2008
When is it better to store flags as a bitmask rather than using an associative table?
C#
Sql Server
Database Design
Bitmask
Why can't I use "create schema" in a begin/end block in SQL Management Studio?
Sql
Sql Server
Tsql
How to solve SQL Server Error 1222 i.e Unlock a SQL Server table
Sql Server
Database
Sql Server-2008-R2
Locking
Deadlock
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
How to alter table add column with named default constraint and named foreign key constraint?
Sql Server
How to do join on multiple criteria, returning all combinations of both criteria
Sql
Sql Server
Join
Sleep Command in T-SQL?
Sql Server
Tsql
Asynchronous
Sleep
How do you create a yes/no boolean field in SQL server?
Sql Server
Boolean
Sqldatatypes
What are the best practices for using a GUID as a primary key, specifically regarding performance?
Sql Server
Entity Framework
Database Design
Primary Key
Guid
Is there a Profiler equivalent for MySql?
Mysql
Sql Server
Database
Floor a date in SQL server
Sql Server
Tsql
In sql server 2005, how do I change the "schema" of a table without losing any data?
Sql Server
Database
Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE
Mysql
Sql Server
Tsql
What is the purpose of system table master..spt_values and what are the meanings of its values?
Sql
Sql Server
Database Design
Configuration
Delete rows with date older than 30 days with SQL Server query
Sql Server
Date Arithmetic
SQL Server silently truncates varchar's in stored procedures
Sql
Sql Server
Stored Procedures
Truncate
Truncation
SqlBulkCopy Insert with Identity Column
C#
Sql Server
Sqlbulkcopy
Identity Insert
T-SQL Substring - Last 3 Characters
Sql
Sql Server
Sql Server-2005
Tsql
How to find which views are using a certain table in SQL Server (2008)?
Sql
Sql Server
Views
How to remove cached server names from the Connect to Server dialog?
Sql Server
Caching
Login
Sql Server-2012
Ssms
How SQL query result insert in temp table?
Sql
Sql Server
SQL Server 2008- Get table constraints
Sql
Sql Server
Sql Server-2008
Constraints
Get 2 Digit Number For The Month
Sql
Sql Server
Sql Server-2008
Tsql
How to use order by with union all in sql?
Sql
Sql Server
Get Table and Index storage size in sql server
Sql
Sql Server
Sql Server-2008
Indexing
Change collations of all columns of all tables in SQL Server
Sql Server
Collate
How to set variable from a SQL query?
Sql
Sql Server
Tsql
sql server invalid object name - but tables are listed in SSMS tables list
Sql Server
Ssms
How to replace a string in a SQL Server Table Column
Sql
Sql Server
Database
Database Administration
How can I import an Excel file into SQL Server?
Sql Server
Excel
Csv
Import
Oledb
What's the difference between a Table Scan and a Clustered Index Scan?
Sql
Sql Server
Indexing
Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
Sql Server
Getdate
Getting return value from stored procedure in C#
C#
Sql
Sql Server
Set start value for column with autoincrement
Sql Server
How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
Sql Server
SELECT max(x) is returning null; how can I make it return 0?
Sql
Sql Server
SQL Server 2000: How to exit a stored procedure?
Sql Server
Tsql
Stored Procedures
Sql Server-2000
Control Flow
What are NDF Files?
Sql
Sql Server
How to use table variable in a dynamic sql statement?
Sql
Sql Server
Sql Server-2008
Dynamic Sql
Table Variable
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
Finding the data types of a SQL temporary table
Sql
Sql Server
Use one CTE many times
Sql
Sql Server
Sql Server-2008
Common Table-Expression
List of all index & index columns in SQL Server DB
Sql Server
Tsql
Indexing
Reverse Engineering
SQL Schema Comparison Error "Target is unavailable"
Sql Server
Visual Studio-2015
Visual Studio-2017
Are foreign keys indexed automatically in SQL Server?
Sql Server
Indexing
Foreign Keys
Insert Picture into SQL Server 2005 Image Field using only SQL
Sql
Sql Server
Sql Server-2005
Image
How to retrieve field names from temporary table (SQL Server 2008)
Sql
Sql Server
Sql Server-2008
Temp Tables
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
Cannot find the object because it does not exist or you do not have permissions. Error in SQL Server
Sql Server
How to pass a null variable to a SQL Stored Procedure from C#.net code
C#
Sql
Sql Server
Stored Procedures
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
set default schema for a sql query
Sql
Sql Server
Schema
SQL Server - Return value after INSERT
Sql
Sql Server
Sql Server-2008
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
Get all table names of a particular database by SQL query?
Sql
Sql Server
how to insert datetime into the SQL Database table?
.Net
Sql
Sql Server
Sql Server-2005
C# 3.0
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
Get everything after and before certain character in SQL Server
Sql
Sql Server
How do I get the creation date of a MySQL table?
Mysql
Sql
Sql Server
Database
SQL Server returns error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." in Windows application
Sql Server
Security
Sqlconnection
How to send email from SQL Server?
Sql
Sql Server
Tsql
Sp Send-Dbmail
DateTime.MinValue and SqlDateTime overflow
C#
Sql Server
Datetime
SQL Server (localdb)\v11.0 explained
Sql Server
Ssms
Localdb
Can I have multiple rows of tabs in SQL Server Management Studio
Sql Server
Ssms
SQL Server IF EXISTS THEN 1 ELSE 2
Sql
Sql Server
If Statement
Stored Procedures
Sql Server-2012
How to import a SQL Server .bak file into MySQL?
Mysql
Sql Server
Migration
Backup
Will a SQL Server Job skip a scheduled run if it is already running?
Sql
Sql Server
Scheduled Tasks
Sql Server-Agent
SQL Server: Extract Table Meta-Data (description, fields and their data types)
Sql
Sql Server
Metadata
What is a Trusted Connection?
Sql Server
Trustedconnection
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
Get a list of dates between two dates using a function
Sql Server
Date
Datetime in where clause
Sql
Sql Server
Datetime
Sql Server-2005
Filter
Best way to copy a database (SQL Server 2008)
Sql Server
Sql Server-2008
Can I Comma Delimit Multiple Rows Into One Column?
Sql
Sql Server
Sql Server-2008
Tsql
How to Create a real one-to-one relationship in SQL Server
Sql
Sql Server
Entity Framework
One to-One
Right click script alter table disabled in SQL Server Management Studio
Sql Server
Ssms
Alter Table
Using stored procedure output parameters in C#
C#
Sql Server
Stored Procedures
Inner Joining three tables
Sql
Sql Server
Add a summary row with totals
Sql
Sql Server
Rollup
SQL Left Join first match only
Sql
Sql Server
Tsql
Join
Greatest N-per-Group
T-SQL Throw Exception
Sql Server
Tsql
Throw
How to generate a Guid in SQL Server?
Sql
Sql Server
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
How do I obtain a list of all schemas in a Sql Server database
C#
.Net
Sql Server
ado.net
Find non-ASCII characters in varchar columns using SQL Server
Sql Server
Tsql
Sql Server-2005
Non Ascii-Characters
Node.js and Microsoft SQL Server
Sql Server
node.js
Node Mssql
Tedious
Query to check whether a column is nullable
Sql Server
Sql Server-2008
Nullable
How can I force entity framework to insert identity columns?
asp.net
Sql Server
Database
Entity Framework
Ef Code-First
How do I find a stored procedure containing <text>?
Sql Server
Sql Server-2008
Tsql
Stored Procedures
Incorrect syntax near 'GO'
Sql Server
ado.net
How to subtract 30 days from the current date using SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Restoring SQL Server backup to Azure SQL Database
Sql Server
Azure
Azure Sql-Database
Database Backups
TRIM is not a recognized built-in function name
Sql
Sql Server
Tsql
Using variable in SQL LIKE statement
Sql Server
Why is SQL Server losing a millisecond?
Sql
Sql Server
Most recent record in a left join
Sql
Sql Server
Sql Server-2005
SqlDateTime.MinValue != DateTime.MinValue, why?
.Net
Sql Server
Datetime
Types
What is the LDF file in SQL Server?
Sql Server
How can I insert binary file data into a binary SQL field using a simple insert statement?
Sql Server
Tsql
Sql Server-2000
Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
Sql
Sql Server
Database Design
Sql Server-2008
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
How to check if a string is a uniqueidentifier?
Sql
Sql Server
Import and Export Wizard with Identity Column
Sql Server
Sql Server-2008
Sql Server-2008-R2
Are there any disadvantages to always using nvarchar(MAX)?
Sql
Sql Server
Sql Server-2005
SQL Server - stop or break execution of a SQL script
Sql
Sql Server
Scripting
Exit
What is the best way to implement Polymorphic Association in SQL Server?
Sql Server
Associations
Polymorphic Associations
Database Normalization
How can I lock a table on read, using Entity Framework?
C#
Sql Server
Entity Framework
Multiprocessing
How to return a incremental group number per group in SQL
Sql
Sql Server
Tsql
Group By
How to rollback or commit a transaction in SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2005
how to know status of currently running jobs
Sql Server
Sql Server-2008
Tsql
Sql Agent
Connecting to SQL Server using windows authentication
C#
asp.net
Sql
Sql Server
How can I catch UniqueKey Violation exceptions with EF6 and SQL Server?
C#
Sql Server
Exception Handling
Entity Framework-6
Unique Key
ROW_NUMBER Without ORDER BY
Sql
Sql Server
Tsql
Window Functions
SQL User Defined Function Within Select
Sql
Sql Server
Select
User Defined-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
Combine two tables that have no common fields
Sql Server
Union
How can I delete using INNER JOIN with SQL Server?
Sql
Sql Server
Sql Server-2008
Inner Join
Sql Delete
What is the difference between varchar and nvarchar?
Sql Server
Varchar
Nvarchar
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
How can I tell what edition of SQL Server runs on the machine?
Sql
Sql Server
Can an INNER JOIN offer better performance than EXISTS
Sql
Sql Server
Sql Server-2005
Performance
Tsql
SQL Server - Convert date field to UTC
Sql Server
Datetime
Utc
Naming of boolean column in database table
Sql Server
Database
Database Design
Naming Conventions
How to declare local variables in postgresql?
Sql Server
Postgresql
Migration
How to add a new schema to sql server 2008?
Sql Server
Sql Server-2008
Execute SQL script from command line
Sql
Sql Server
Batch File
Command Line
Scripting
SQL Server Group by Count of DateTime Per Hour?
Sql Server
Datetime
Rounding
EXISTS vs JOIN and use of EXISTS clause
Sql
Sql Server
Sql Server-2005
Sql Server-2008
SQL Server: IF EXISTS ; ELSE
Sql
Sql Server
If Statement
Exists
Using tuples in SQL "IN" clause
Sql
Sql Server
Tuples
Row Value-Expression
How do you UNION with multiple CTEs?
Sql Server
Union
Common Table-Expression
Remove certain characters from a string
Sql Server
Tsql
Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"
Sql Server
Bulk Update in C#
C#
.Net
Sql Server
Bulk
How to import a bak file into SQL Server Express
Sql Server
Sql Server-2008
Database Backups
Database Restore
SQL Server procedure declare a list
Sql
Sql Server
Sql Server-2008-R2
Conditional JOIN Statement SQL Server
Sql Server
Join
Conditional
Case
Microsoft SQL Server Management Studio Opening Error
Sql Server
Visual Studio-2010
How do I use cascade delete with SQL Server?
Sql Server
Cascading Deletes
Stored procedures/DB schema in source control
Sql Server
Database
Version Control
SQL Server - Running large script files
Sql Server
Sql Scripts
Search and replace part of string in database
Sql
Sql Server
Tsql
SQLException : String or binary data would be truncated
C#
Sql
Sql Server
How can I execute a set of .SQL files from within SSMS?
Sql Server
Batch File
Ssms
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 can I move a table to another filegroup in MS SQL Server?
Sql Server
Sql Server-2008
Filegroup
How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
Sql
Sql Server
Sql Server-2008
Datetime
Datetimeoffset
Online SQL syntax checker conforming to multiple databases
Mysql
Sql Server
Oracle
Postgresql
Is there a way to get a list of all current temporary tables in SQL Server?
Sql
Sql Server
Sql Server-2000
Temp Tables
Relationship between catalog, schema, user, and database instance
Mysql
Sql Server
Oracle
Postgresql
Db2
SQL Server: how to add new identity column and populate column with ids?
Sql
Sql Server
Primary Key
Database Cursor
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Sql
Sql Server
Sql Server-2005
String Aggregation
What does a Status of "Suspended" and high DiskIO means from sp_who2?
Sql Server
Temporary table in SQL server causing ' There is already an object named' error
Sql
Sql Server
Tsql
Temp Tables
Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED
Sql Server
node.js
Node Mssql
Tedious
Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
Sql
Sql Server
Performance
Optimization
Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
Sql Server
Stored Procedures
Smo
Size of VARBINARY field in SQL Server 2005
Sql
Sql Server
Sql Server-2005
Clr
Management Studio default file save location
Sql Server
Ssms
How do I change the owner of a SQL Server database?
Sql Server
Sql Server-2005
Permissions
How do you set autocommit in an SQL Server session?
Sql Server
Session
Autocommit
Truncate Table Within Transaction
Sql
Sql Server
Sql Server-2005
Transactions
Truncate
Why can't I use alias in a count(*) "column" and reference it in a having clause?
Sql
Sql Server
Alias
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 can I know when SQL Full Text Index Population is finished?
Sql Server
Unit Testing
Fulltext Index
Population
Getting an odd error, SQL Server query using `WITH` clause
Sql Server
SQLite vs SQL Server
Sql Server
Sqlite
SQL Query to add a new column after an existing column in SQL Server 2005
Sql
Sql Server
Sql Server-2005
Decimal values in SQL for dividing results
Sql Server
Sql Server-2005
SQL Server default character encoding
Sql Server
Character Encoding
Collation
Convert float into varchar in SQL Server without scientific notation
Sql Server
EF4 - The selected stored procedure returns no columns
Sql Server
Entity Framework-4
Temp Tables
How to set value to variable using 'execute' in t-sql?
Sql Server
Tsql
sql server select first row from a group
Sql Server
How to Troubleshoot Intermittent SQL Timeout Errors
.Net
Sql
Sql Server
Sql Server-2008
Timeout
SQL Server 2008 delete all tables under special schema
Sql
Sql Server
What is the connection string for localdb for version 11
C#
Sql Server
Connection String
Sql Server-2012
Localdb
INNER JOIN vs INNER JOIN (SELECT . FROM)
Sql
Sql Server
Join
Inner Join
SQL Server find and replace specific word in all rows of specific column
Sql
Sql Server
Sql Server-2008
Get week day name from a given month, day and year individually in SQL Server
Sql
Sql Server
Function
Date
What is the use of WITH TIES keyword in SELECT statement in SQL Queries?
Sql Server
Tsql
64 bit Microsoft SQL Server Data Tools
Sql Server
Visual Studio-2013
Ssdt Bi
How do I see active SQL Server connections?
Sql
Sql Server
Sql Server-2008
Why do table names in SQL Server start with "dbo"?
Sql Server
How do I pass a list as a parameter in a stored procedure?
Sql
Sql Server
Stored Procedures
SQL Server 2005 Using DateAdd to add a day to a date
Sql
Sql Server
Tsql
Date
Dateadd
How Can I Log and Find the Most Expensive Queries?
Sql Server
Sql Server-2008
Profiling
Using WITH NOLOCK Table Hint in Query Using View - Does it Propagate Within the View?
Sql
Sql Server
Locking
Does End Using close an open SQL Connection
.Net
Sql
Sql Server
vb.net
What are Covering Indexes and Covered Queries in SQL Server?
Sql
Sql Server
Indexing
ORDER BY DATE showing NULLS first then most recent dates
Sql Server
Sql Server-2000
How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?
Sql
Sql Server
Tsql
What is the most appropriate data type for storing an IP address in SQL server?
Sql
Sql Server
Types
Ip Address
Ipv4
Check if string doesn't contain another string
Sql Server
Tsql
String
What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
Java
Sql Server
Jdbc
Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
.Net
Sql Server
Visual Studio
Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
Sql Server
Tsql
Join
Sql
TransactionScope Prematurely Completed
C#
Sql Server
ado.net
Deadlock
Transactionscope
Pros & Cons of TRUNCATE vs DELETE FROM
Sql Server
Sql Server-2008
Tsql
Sql Delete
Truncate
Is a Primary Key necessary in SQL Server?
Sql
Sql Server
Sql Server-2005
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
Convert Time DataType into AM PM Format:
Sql Server
Sql Server-2008
Select
Time
MySQL - Meaning of "PRIMARY KEY", "UNIQUE KEY" and "KEY" when used together while creating a table
Mysql
Sql Server
Primary Key
Unique Key
How do I return multiple result sets with SqlCommand?
C#
Sql Server
ado.net
Bulk Insert Partially Quoted CSV File in SQL Server
Sql Server
Csv
Bulkinsert
Why no windowed functions in where clauses?
Sql
Sql Server
Tsql
Window Functions
Why do I get the error "Xml data type is not supported in distributed queries" when querying a linked server for non-xml data?
Sql Server
Xml
Linked Server
What kind of datatype should one use to store hashes?
Sql
Sql Server
Sql Server-2008
Tsql
SQL Server Case Statement when IS NULL
Sql
Sql Server
Sql Server-2008
What is the equivalent of the Oracle "Dual" table in MS SqlServer?
Sql Server
Oracle
Dual Table
SQL Server Agent Job - Exists then Drop?
Sql
Sql Server
Sql Server-Agent
Sql Job
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
Where is SQL Profiler in my SQL Server 2008?
Sql Server
Sql Server-Profiler
Profiling
.Net vs SSIS: What should SSIS be used for?
.Net
Sql Server
Ssis
How to export SQL Server 2005 query to CSV
Sql Server
Sql Server-2005
Bcp
Sqlcmd
How can I compare time in SQL Server?
Sql
Sql Server
Datetime
How Do I Insert a Byte[] Into an SQL Server VARBINARY Column
Arrays
Sql Server
What accounts to use when installing SQL Server 2008 Developer
Sql Server
Installation
Development Environment
Settings
To get total number of columns in a table in sql
Sql Server
The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'
Sql
Sql Server
Permissions
Dotnetnuke
Sysobjects
How can I tell if a database table is being accessed anymore? Want something like a "SELECT trigger"
Sql Server
Database Design
Sql Server-2008
Clustered Index
syntax for single row MERGE / upsert in SQL Server
Sql Server
Merge
Upsert
SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?
Sql Server
Formatting
Ssms
What is this hacker trying to do?
Sql Server
Windows
Tsql
Security
Sql Injection
Alternate table with new not null Column in existing table in SQL
Sql Server
Common Table Expression, why semicolon?
Sql
Sql Server
Tsql
Sql Server-2008
Common Table-Expression
Size property has an invalid size of 0
C#
asp.net
Sql Server
Stored Procedures
Sqlparameter
SQL Server: Isolation level leaks across pooled connections
Sql Server
Tsql
ado.net
Transactions
Transactionscope
SQL Server FOR EACH Loop
Sql
Sql Server
Tsql
Update int column in table with unique incrementing values
Sql
Sql Server
Sql Server-2008
Composite Primary key vs additional "ID" column?
Sql
Sql Server
Database
Database Design
SQL Server file names vs versions
Sql Server
Version
How to add plus one (+1) to a SQL Server column in a SQL Query
Sql
Sql Server
Tsql
What is the meaning of SELECT ... FOR XML PATH(' '),1,1)?
Sql
Sql Server
Why is it considered bad practice to use cursors in SQL Server?
Sql Server
Sql Server-2005
Database Cursor
How to store directory / hierarchy / tree structure in the database?
Sql Server
Sql Server-2005
Database Design
Tree Structure
Import Excel spreadsheet columns into SQL Server database
Sql Server
Excel
Sql Server-2008
Import
Etl
@@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
Sql
Sql Server
Tsql
Identity
Output Clause
How to select data of a table from another database in SQL Server?
Sql
Sql Server
Database
Linked Server
Add a new table column to specific ordinal position in Microsoft SQL Server
Sql Server
Database Table
Change Management
Downsides to "WITH SCHEMABINDING" in SQL Server?
Sql
Sql Server
Query Optimization
Schemabinding
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
SQL Server LIKE containing bracket characters
Sql
Sql Server
Pattern Matching
The parameterized query expects the parameter which was not supplied
Sql
Sql Server
vb.net
How do I swap column values in sql server 2008?
Sql
Sql Server
Sql Server-2008
Select n random rows from SQL Server table
Sql
Sql Server
Random
Using merge..output to get mapping between source.id and target.id
Sql Server
Sql Server-2008
Merge
In SQL Server Management Studio what is SQLCMD mode?
Sql Server
Ssms
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
CASE WHEN statement for ORDER BY clause
Sql
Sql Server
Sql Server-2008-R2
Entity Framework The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
C#
Sql
.Net
Sql Server
Entity Framework
Passing Output parameters to stored procedure using dapper in c# code
C#
Sql
Sql Server
Stored Procedures
Dapper
Possible to restore a backup of SQL Server 2014 on SQL Server 2012?
Sql
Sql Server
Sql Server-2012
Compatibility
Sql Server-2014
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
How do I reset an increment identity's starting value in SQL Server
Sql Server
Identity
SQL Query for Logins
Sql
Sql Server
How to insert multiple records and get the identity value?
Sql
Sql Server
Sql Server-2005
What is the best way to version control my SQL server stored procedures?
Sql Server
Visual Studio
Svn
Version Control
Stored Procedures
Default port for SQL Server
asp.net
Sql
Sql Server
SQL Server query to find all current database names
Sql Server
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
Is it possible to list all foreign keys in a database?
Sql Server
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
SQL Server Int or BigInt database table Ids
Sql
Sql Server
Doing a join across two databases with different collations on SQL Server and getting an error
Sql Server
Tsql
Collation
SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
C#
Sql Server
Performance
SQL Server 2008: The columns in table do not match an existing primary key or unique constraint
Sql
Sql Server
Foreign Keys
Foreign Key-Relationship
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
Java
Sql Server
Jdbc
Driver
Sqlexception
sql set variable using COUNT
Sql Server
Tsql
Using a conditional UPDATE statement in SQL
Sql
Sql Server
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
Update Query with INNER JOIN between tables in 2 different databases on 1 server
Sql Server
Database
Syntax
Inner Join
Using IF ELSE statement based on Count to execute different Insert statements
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2008-R2
How to fix the embedded text qualifier issue while exporting data to CSV flat file?
Sql Server
Ssis
Sql Server-2000
Sql Server-2012
How To change the column order of An Existing Table in SQL Server 2008
Sql Server
SQL Server : Arithmetic overflow error converting expression to data type int
Sql
Sql Server
Tsql
Connecting to MS SQL Server with Windows Authentication using Python?
Sql Server
Sql Server-2008-R2
Odbc
Windows Authentication
Pyodbc
SqlServer: Login failed for user
Sql Server
Sql Server-2008
Jdbc
Logging ALL Queries on a SQL Server 2008 Express Database?
Sql Server
Not equal <> != operator on NULL
Sql
Sql Server
Tsql
Null
How to change the data type of a column without dropping the column with query?
Sql Server
Linq to SQL DateTime values are local (Kind=Unspecified) - How do I make it UTC?
C#
Sql Server
Linq to-Sql
Datetime
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
identity from sql insert via jdbctemplate
Java
Sql Server
Spring
Jdbc
Jdbctemplate
How to select true/false based on column value?
Sql Server
Check for empty GUID in SQL
Sql Server
Tsql
How can I remove accents on a string?
Sql Server
How to convert empty spaces into null values, using SQL Server?
Sql Server
Null
Is Empty
Use SQL Server time datatype in C#.NET application?
C#
.Net
Sql
Sql Server
Time
How to: Create trigger for auto update modified date with SQL Server 2008
Sql Server
Sql Server-2008
Date
Triggers
Get MAX value of a BIT column
Sql
Sql Server
Tsql
Sql Server-2008
Stored Procedures
Remote Procedure call failed with sql server 2008 R2
Sql Server
Sql Server-2008
Sql Server-2008-R2
SQL Server Insert if not exists
Sql
Sql Server
Sql Server-2008
Stored Procedures
How to do version control for SQL Server database?
Sql Server
Database
Svn
Version Control
Convert Date format into DD/MMM/YYYY format in SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Add a row number to result set of a SQL query
Sql
Sql Server
Sql Server-2005
What is the T-SQL syntax to connect to another SQL Server?
Sql Server
Tsql
Stored Procedures
Ssms
How to get SQL Profiler to monitor trigger execution
Sql Server
Sql Server-2005
Sql Server-Profiler
What is the purpose for using OPTION(MAXDOP 1) in SQL Server?
Sql
Sql Server
What's the best method to pass parameters to SQLCommand?
.Net
Sql Server
ado.net
Sqlcommand
SQL formatting standards
Sql
Sql Server
Formatting
Standards
Coding Style
How to get difference between two rows for a column field?
Sql
Sql Server
Tsql
Sql Server-2005
Hitting the 2100 parameter limit (SQL Server) when using Contains()
Sql Server
Linq
Parameters
Limit
CONCAT'ing NULL fields
Sql
Sql Server
Concatenation
Calculating number of full months between two dates in SQL
Sql
Sql Server
How can I create a SQL unique constraint based on 2 columns?
Sql Server
Sql Server-2005
Sql Server-2008
Constraints
Unique Constraint
Delete all rows in table
Sql Server
Tsql
Replace single quotes in SQL Server
Sql Server
Replace
Error Handling
Add default value of datetime field in SQL Server to a timestamp
Sql Server
Datetime
How do you check if a certain index exists in a table?
Sql Server
Best practices for SQL varchar column length
Mysql
Sql
Sql Server
Postgresql
What does the SQL # symbol mean and how is it used?
Sql Server
Syntax
Symbols
Is there an elegant way to Invert a Bit value in an SQL insert Statement?
Sql
Sql Server
Bit Manipulation
SQL Server - current user name
Sql Server
Tsql
Capturing count from an SQL query
C#
Sql
Sql Server
T-SQL XOR Operator
Sql Server
Tsql
Xor
How to insert a data table into SQL Server database table?
C#
Sql Server
Datatable
Increment Row Number on Group
Sql
Sql Server
Sql Server-2005
How to get just the date part of getdate()?
Sql Server
Tsql
SQL Server Express cannot connect error: 28 - Server doesn't support requested protocol
Sql Server
Network Protocols
Find all stored procedures that reference a specific column in some table
Sql
Sql Server
Select
Find
Columnname
Dynamic query with OR conditions in Entity Framework
C#
Sql Server
Entity Framework
Linq
Linq to-Entities
"IN" clause limitation in Sql Server
Sql
Sql Server
be careful parts of your document may include personal information that cannot be removed by the Document Inspector
Sql Server
Excel
Excel 2013
Powerpivot
Copy tables from one database to another in SQL Server
Sql
Sql Server
Copy
Migrate
Database Table
Difference between scalar, table-valued, and aggregate functions in SQL server?
Sql Server
Function
Tsql
Aggregate Functions
Sqlclr
Using SQL Server Management Studio to remote connect to docker container
Sql Server
Docker
Digital Ocean
SQL, Auxiliary table of numbers
Sql
Sql Server
Configure Lucene.Net with SQL Server
Sql Server
lucene.net
SQL Server 2005 drop column with constraints
Sql Server
Sql Server-2005
How to update and order by using ms sql
Sql
Sql Server
Tsql
Sql Order-By
Sql Update
SQL GROUP BY CASE statement with aggregate function
Sql
Sql Server
Sql Server-2005
Group By
How do I create a comma-separated list using a SQL query?
Sql
Sql Server
Tsql
String Aggregation
How can you convert "tinyint" of t-sql to integer in c#?
C#
Sql Server
SQL Server 2008: TOP 10 and distinct together
Sql
Sql Server
Sql Server-2008
How to get number of rows inserted by a transaction
Sql Server
Sql Server-2005
'datetime2' error when using entity framework in VS 2010 .net 4.0
C#
Sql Server
Entity Framework
Sql Server-2008
How to get first character of a string in SQL?
Sql
Sql Server
Sql Server-2005
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
SQL COUNT overflow
Sql
Sql Server
Count
Overflow
Execute Stored Procedure from a Function
Sql
Sql Server
Sql Server-2005
Stored Procedures
User Defined-Functions
How do I add a auto_increment primary key in SQL Server database?
Sql
Sql Server
Auto Increment
Does inserting data into SQL Server lock the whole table?
Sql Server
Entity Framework
Is there a difference between SQL Server Express (2012) and LocalDB?
Sql Server
Localdb
Convert SSMS .rpt output file to .txt/.csv
Sql Server
Sql Server-2005
Character Encoding
Ssms
Rpt
T-SQL How to grant role to user
Sql Server
Sql Server-2008
Tsql
Temporarily disable all foreign key constraints
Sql Server
Sql Server-2008
Ssis
Constraints
Dropping and recreating databases in Microsoft SQL Server
Sql Server
Sql Server-2008
What is the syntax meaning of RAISERROR()
Sql
Sql Server
Database
Sql Server-2008
Sql Server-2008-R2
Get all dates between two dates in SQL Server
Sql
Sql Server
How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
Sql Server
Sql Server-2008-Express
Login to Microsoft SQL Server Error: 18456
Sql Server
Connection
Error Code
How to convert DateTime to VarChar
Sql
Sql Server
Datetime
Sql Convert
Can we run SQL script using code first migrations?
C#
Sql Server
asp.net Mvc
Entity Framework
asp.net Mvc-4
How to connect to a local database in SQL Server Management Studio?
Sql Server
Database
Ssms
Select columns with NULL values only
Sql Server
tsql returning a table from a function or store procedure
Sql Server
Tsql
How do I determine if a database role exists in SQL Server?
Sql
Sql Server
Create a one to many relationship using SQL Server
Sql
Sql Server
Sql Server-2005
Which sql server data type best represents a double in C#?
C#
Sql
Sql Server
Tsql
Double
Is it possible to force row level locking in SQL Server?
Sql Server
Sql Server-2005
Sql Server-2008
Rowlocking
SQL Server: UPDATE a table by using ORDER BY
Sql Server
How to write "not in ()" sql query using join
Sql
Sql Server
Tsql
Notin
Composite Primary Key On Table Variable In Stored Procedure
Sql
Sql Server
Sql Server-2008
Stored Procedures
Primary Key
The order of a SQL Select statement without Order By clause
Sql Server
Oracle
Select
Sql Order-By
Database design for user settings
Mysql
Sql Server
Database
Database Design
Relational Database
Retrieving Data from SQL Using pyodbc
Python
Sql
Sql Server
Pyodbc
Keyword Not Supported: Metadata
C#
Sql Server
asp.net Mvc
Entity Framework
I get a "An attempt was made to load a program with an incorrect format" error on a SQL Server replication project
C#
Sql Server
Replication
How to check if a stored procedure exists before creating it
Sql
Sql Server
Tsql
Stored Procedures
Entity-framework code is slow when using Include() many times
C#
Sql Server
Entity Framework
Linq
Iframe
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
C#
Sql
Sql Server
Sql Server-2005
What’s the best way to capitalise the first letter of each word in a string in SQL Server
Sql
Sql Server
String
Rename SQL Server Schema
Sql
Sql Server
Sql Server-2005
Schema
T-SQL, updating more than one variable in a single select
Sql
Sql Server
Tsql
Creating table names that are reserved words/keywords in MS SQL Server
Sql
Sql Server
newid() inside sql server function
Sql Server
Function
Newid
What does =* mean?
Sql
Sql Server
Database
Tsql
When is a good situation to use a full outer join?
Sql
Sql Server
Calculate Time Difference Between Two Rows
Sql Server
Database
Difference Between-Rows
Which SQL data type to store Base64 encoded file?
Sql Server
Base64
Select All as default value for Multivalue parameter
Sql Server
Visual Studio-2008
Reporting Services
Parameters
Python vs C#/.NET -- what are the key differences to consider for using one to develop a large web application?
.Net
Python
Sql Server
Django
asp.net Mvc-2
adding a column description
Sql
Sql Server
Sql Server-2005
Why are composite primary keys still around?
Mysql
Sql Server
Database Design
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
Convert negative data into positive data in SQL Server
Sql
Sql Server
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
How to execute a stored procedure inside a select query
Sql
Sql Server
Sql Server-2008
Stored Procedures
Does Sql JOIN order affect performance?
Sql
Sql Server
Select columnValue if the column exists otherwise null
Sql
Sql Server
Select
Exists
Identity column value suddenly jumps to 1001 in sql server
Sql
Sql Server
Sql Server-2012
Scope of temporary tables in SQL Server
Sql
Sql Server
Tsql
Sql Server-2012
What do these Copy Only Backup options mean?
Sql Server
Database
Sql Server-2008
Error Invalid prefix or suffix characters in SQL Server Management Studio
Sql Server
Sql Server-2008-R2
Ssms
SQL server stored procedure return a table
Sql
Sql Server
Matlab
Stored Procedures
sql try/catch rollback/commit - preventing erroneous commit after rollback
Sql
Sql Server
Exception
Transactions
Try Catch
MSDTC on server 'server is unavailable'
Sql Server
Linked Server
Msdtc