Examples of programming questions in sql-server

Do I need a database reference for a linked server in a SQL Server database project?
Get All Except from SQL database using Entity Framework
Stored procedure EXEC vs sp_executesql difference?
T-SQL get number of working days between 2 dates
catastrophic failure trying to select from linked server
Joining 100 tables
Update existing database values from spreadsheet
When are SQL Server Views updated?
Is WITH the replacement for a #TEMP table?
XML as parameter in stored procedure (sql server)
How to debug merge in SQL Server?
How can I assign a number to each row in a table representing the record number?
use case in where clause sql server
How to get running sum of a column in sql server
Why does sp_columns return no results?
How to reuse a sub query in sql?
What is SNIReadSyncOverAsync and why would it take a long time to complete?
How to get Distinct values in SQL Query
Return Varchar from Custom T-SQL Functions
Adding characters in values in an existing column
how to get the start and end dates of all weeks between two dates in SQL server?
Try and Catch on TSQL - catch not catching
Cannot resolve collation conflict on column 5 in select statement
Passing xml string parameter to SQL Server stored procedure
SSMS shortcut to navigate between open query windows
nvarchar concatenation / index / nvarchar(max) inexplicable behavior
How to compare two comma-separated strings, and return TRUE if there is at least 1 match
ALTER TABLE my_table ADD COLUMN column_name VARCHAR(50) AFTER col_name not supported in SQL Server 2000
String concatenation in procedure parameters
Call multiple SQL Server stored procedures in a transaction
Configure SQL Server connection pool on Tomcat
What is the syntax for adding multiple arguments onto the "Variables" parameter in sqlpackage.exe?
escape space in connection string
Understand Unicode and code pages in SQL Server collations
dbo.TempGetStateItemExclusive3 called repeatedly
analog to MySQL's DATE_SUB / INTERVAL
radius search by latitude / longitude
Indexing views with a CTE
How to switch to datetime2 in Entity Framework / SQL Server 2008 project
Restore a SQL Server 2000 backup on SQL Server 2012
How to join row values to column names in a dynamic query
Include additional columns in a non clustered primary key index
Error attaching a database (.mdf file) to SQL Server
Raise custom error message with RAISERROR in SQL Server
Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
SQL Server query to find clustered indexes
sp_send_dbmail: FROM_ADDRESS
How does SQL Server compare a date to a string literal?
Setting ConnectionTimeout for OdbcConnection (System.Data.Odbc) in c# does not work
How to get list of all tables that has identity columns
SQL Server Profiler deprecation - Replacement?
SQL Unit Testing Stored Procedures
SQL: Count distinct values from one column based on multiple criteria in other columns
How to get column names of table at runtime in C#?
Do I need NO LOCK in my CREATE View query
DataFlow task in SSIS is very slow as compared to writing the sql query in Execute SQL task
Incorrect syntax near the keyword 'VIEW'
Rollback trans and unlock tables on SQL Server
Scalar function fn_cdc_get_min_lsn() constantly returns '0x00000000000000000000' for valid table names?
SQL VIEW Unsupported Data Type
Sharing data between SQL databases
What are the differences between the older row_number() and the newer OFFSET + FETCH based pagination in SQL Server?
How to retrieve same column twice with different conditions in same table?
MS SQL Server Last Inserted ID
Using IF / ELSE to determine a SELECT INTO statement
How to use DataAdapter with SqlTransaction in C#?
T-SQL IF statement embedded in a sum() function
SQL Server - Generate script without primary key
SQL Server : when using multiple UPDATES in a single query, will the WHERE clause use the current or updated field values?
Invoke-Sqlcmd, InputFile, and Variable
SQL-Server is ignoring my COLLATION when I'm using LIKE operator
How to update the field value of specific's column in SQL Server using Query in one shot?
SQL Server with clause versus temporary table
Cyrillic symbols in SQL code are not correctly after insert
Using output to set a variable in a merge statement
List of distinct years between two dates
Unable to load DLL 'SqlServerSpatial.dll'
Fastest way to insert 30 thousand rows in a temp table on SQL Server with C#
while loop inside a trigger to loop through all the columns of table in sql
IDENTITY_INSERT is set to OFF?
TimeZoneCode to TimeZoneInfo
PHP Fatal error: Call to undefined function mssql_query()
SQL Server 2008 Row Insert and Update timestamps
Stored procedure with table name as parameter amongst others
SQL Insert statement syntax
SQL Server Merge - Getting matched records to another temp table
Finding out if a column is NOT NULL
How to split string into columns for a view?
SQL server Varchar(max) and space taken
How do you find the same weekday last year in SQL?
SQL Server Passthrough query as basis for a DAO recordset in Access
What is the meaning of the following SQL Server declaration: datetime2(7)?
could not create a list of fields for the query
SQL - How to calculate percentage change/growth
SQL Server continue identity count after truncating table
How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
How to add a not null to an already existing column in SQL Server?
Cast string+ntext to nvarchar error
Get the nearest longitude and latitude from MSSQL database table?
SQL LIKE operator not working for comma-separated lists
Correct way to select from two tables in SQL Server with no common field to join on
SELECT rows that are a multiple of x
DBCC CHECKDB to check errors in SQL Server database
SQL Server stored procedure that returns a boolean if table exists, c# implementation
generate guid for every row in a column
Most efficient way to test SQL connection string availibility
Why the SQL Server ignore the empty space at the end automatically?
Try_Convert for SQL Server 2008 R2
SqlParameter does not allows Table name - other options without sql injection attack?
Inserting multiple values into a temporary table, SQL Server
Strange Error XML parsing: line 1, character 2038, illegal xml character
How I can remove all NewLine from a variable in SQL Server?
'invalid for creating a default constraint' error when trying to add a constraint to an existing table
SQL - using an alias in a where clause in a subquery
List all indexes with included columns(nonkeys)
How to create UNIQUE constraint in SSMS 2012
A more concise way to format COUNT result with thousands separator?
On table update, trigger an action in my .NET code
SQL Insert depending if a column exists
Selecting First and Last record from a table in SQL Server
How do we select top 20% and bottom 80% records in sql server
Why CREATE VIEW must be first statement in a batch?
Stored Procedure OUT parameter always returning NULL
EntityFramework not updating column with default value
How to make sql query result to xml file
SQL Server : dynamic pivot over 5 columns
LIKE and NULL in WHERE clause in SQL
Can't create schema inside begin block
white circle in microsoft SQL server management studio 2012
Count of Columns in temp table in SQL Server
check date between two dates or NULL in sql
SQL Transaction uncommittable while using try..catch.. Why?
SSIS- Set Multiple variables via a single SQL task
How to benchmark a SQL Server query using SQL Server
there is a process running select statement on tempdb database?
Using column name when using SqlDataReader.IsDBNull
change all synonyms to another database
How to use sql reserve keyword in column name
How to know TSQL Stored Procedure Update Executed
SQL - UNION, priority on the first select statement when doing order by
Check multiple rows for value, return only row with MAX/MIN
MS SQL How to Update multiple rows with single value?
Getting the current date in SQL Server?
Set Snapshot isolation is not reflecting
Get Current week days from monday to sunday
Cant define SQL variable when using WITH statement
Attach (open) mdf file database with SQL Server Management Studio
Convert varchar dd/mm/yyyy to dd/mm/yyyy datetime
Determining what to Raising Max Pool Size to for my Connection Pool
What's SQL Server version 8?
TSQL - how to tell if SQL is clustered?
CONCAT_WS() for SQL Server
Insert into table with select statement plus additional column in SQL Server 2008
Return All Months & Years Between Date Range - SQL
How to read SQL Server COUNT from SqlDataReader
jTDS connection string: connect to a MS SQL Server instance with a backslash
Incorrect syntax near 'OFFSET'" modift sql comm 2012 to 2008
MS SQL Server 2008 "with (nolock)" equivalent for IBM DB2 9.7
How to check if my SQL Server Express database exceeds the 10 GB size limit?
SQL Server: how to create a stored procedure
DateTimeOffset Sample in SQL 2008R2
EF6 wraps every single stored procedure call in its own transaction. How to prevent this?
How to store select statement result to table variable in sql server
Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013
TSQL Select from Different Table based on a CASE value
nonclustered index on primary key column?
Convert negative integer to positive using VB.NET
How to calculate a MSSQL query execution time using python
Select Average of Top 25% of Values in SQL
Parameterized dynamic sql query
in sql server what is the difference between user_type_id and system_type_id in sys.types
DISTINCT with PARTITION BY vs. GROUPBY
Whats wrong with sp_rename with column?
Using WITH (NOLOCK) and Transactions
comparison of truncate vs delete in mysql/sqlserver
How to generate random boolean value in sql server 2008?
Conversion of one or more characters from XML to target collation impossible
Am I running a 32-bit or 64 bit Sql Server
How to create/open DAC application in Visual Studio 2012?
SQL SUM values where 2 conditions are met
Executing stored procedure takes too long than executing TSQL
Adding filter on the right side table on Left outer joins
with(nolock) , (nolock) , nolock differences?
How do I create a temporary table from a type?
converting sql server rowversion to long or ulong?
Accessing Host SQL Server From VMWare Machines
How to get first day of the week and last day of the week in sql server 2008?
SQL run from Excel cannot use a temporary table
SQL MERGE with variables
SQL Server Reporting Studio report showing "ERROR#" or invalid data type error
How to execute SSIS package when a file is arrived at folder
How to create report textbox aggregate expression in SQL server reporting with multiple datasets
Merge to update all target table columns
BCP in SQL command give NativeError = 2 when no -S parameter on local DB
How to test if database is hosted on SQL Azure?
C# Decrypt bytes from SQL Server EncryptByPassPhrase?
SQL server unable to create table in database because of permissions
Getting IIS to impersonate the windows user to SQL server in an intranet environment
Is SQL code faster than C# code?
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries
Will adding a nonclustered index lock my table?
Grant appropriate permission to use Symmetric Key in stored proc
Could not load file or assembly Microsoft.SqlServer.SqlClrProvider on production ASP.net site, where is it?
image data types are invalid for local variables (using openrowset cannot make it work)
SQL Server Import Wizard "workgroup information file" error when importing Access .mdb
Does new ASP.NET MVC identity framework work without Entity Framework and SQL Server?
SQL Server Xml query with multiple namespaces
FIFO Implementation in Inventory using SQL
Update stored procedure on multiple databases
SQL Check if table Exists in C#, if not create
SQL Server project executing multiple script post deploy
Visual Studio Code Map: Unable to connect to the specified database
Distinct random time generation in the fixed interval
SQL Server: compare dates by only matching month and day
INNER JOIN with Table-Valued Function not working
SQL Server 2012 installation Reporting Services Catalog error
How to print the @SqlQuery annotation in JDBI sql api
How to add new schema to existing Visual Studio Database Project?
Inserting from MS SQL Server to MySQL database
.NET, the SqlConnection object, and multi-threading
Know when to retry or fail when calling SQL Server from C#?
SQL deadlocking..in single user mode now
How to find all users with execute rights on a stored procedure in SQL Server
SQL - how do I generate rows for each month based on date ranges in existing dataset?
Could not find file dacpac?
Change the order by when selecting "edit top 'N' rows
CREATE PROCEDURE permission denied in database 'master'
Sql server's Constant scan - clarification?
GROUP BY multiple values in same column
Is there a way for viewing the recent expensive queries in Sql Server 2005?
Find a gap between time stamp
What is the difference between Int and Integer datatypes in SQL Server?
How to change database from Single user mode to multi user
JPA GenerationType.AUTO not considering column with auto increment
What is SRID 0 for geometry columns?
SQL Server for xml path add attributes and values
Converting from SQL Date to DateTime in Delphi XE
Handle multiple result from a stored procedure with SqlQuery
Linq select Item where it is equal to ID in another table
SSAS - OLE DB error in establishing a connection
Primary File size error while creating database
What is the default network protocol in SqlConnection class
EXEC to USE Database
Node.js and MSSQL stored procedures
How to setup weekly auto backup in SQL Server 2012?
CASE statement in where clause in tsql query
HeidiSql connection to MS SQL Server LocalDB
TSQL: NOCHECK Foreign Key inside CREATE TABLE
How to identify the operation type(insert,update,delete) in SQL Server trigger
Can't save database default locations in SQL Server