Search code examples
Find a value anywhere in a database...

sql-servert-sql

Read More
A table name as a variable...

sqlsql-servert-sqlvariable-namestablename

Read More
Applying a dynamic between statement in SQL...

sqldatabaset-sql

Read More
How can you generate possible permutations from a given string in tsql where you need multiple repla...

t-sql

Read More
how to know status of currently running jobs...

sql-serversql-server-2008t-sqlsql-agent

Read More
Executing multiple WITH clauses inside a T-SQL function...

sqlsql-serverfunctiont-sqlwith-clause

Read More
Sargability of RIGHT/LEFT in SQL...

sqlt-sqlquery-optimizationstatic-analysis

Read More
Extract numeric values out of a nvarchar column in SQL...

sql-servert-sql

Read More
Extracting hours from a DateTime (SQL Server 2005)...

sqlt-sqldatetimesql-server-2005hour

Read More
Adding max(value)+1 in new row, can this be a problem?...

sqlsql-serversql-server-2005t-sql

Read More
SP_EXECUTESQL and Output Parameter...

sqlsql-servert-sqlstored-procedures

Read More
Substitute for STRING_AGG pre SQL Server 2016...

sql-servert-sqlgroup-bystring-aggregation

Read More
Run stored procedure for each row of a table...

sqlt-sqlstored-procedures

Read More
Generate MD5 hash string with T-SQL...

sql-servert-sqlsql-server-2008

Read More
T-SQL Throw Exception...

sql-servert-sqlthrow

Read More
How do I escape a single quote in SQL Server?...

sqlsql-servert-sqldelimitersingle-quotes

Read More
How can I do something like: USE @databaseName...

sql-servert-sql

Read More
SQL Management Studio can't drag table / object from Explorer to Query Editor...

sqlsql-servert-sql

Read More
NOT EXISTS with multiple criteria and indirect unique id in SQL Server...

sql-servert-sqlnot-exists

Read More
Using multiple statements in WHEN MATCHED...

sqlsql-servert-sqlmergesql-update

Read More
Calculating Absences by hours and days between dates...

sqlsql-servert-sql

Read More
is it possible to select EXISTS directly as a bit?...

sqlsql-servert-sql

Read More
OR is not supported with CASE expression SQL Server...

sqlsql-servert-sqlcase

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

sql-serversql-server-2008t-sqlssms

Read More
How to ignore trailing whitespace?...

c#sqlentity-frameworkt-sql

Read More
How to add table column headings to sql select statement...

sqlsql-servert-sqlheader

Read More
Syntax of for-loop in SQL Server...

sqlsql-serverloopst-sqlsyntax

Read More
Simple Way to View SQL Query (ies) Generated by SSRS Reports?...

t-sqlsql-server-2008ssrs-2008

Read More
Filling in data as zero which is not existing in database SSRS...

sql-servert-sqlreporting-services

Read More
Identifier on yearly base...

sqlsql-servert-sqlwindow-functions

Read More
BackNext