Search code examples
Cannot access temporary tables from within a function...


sql-server-2008function

Read More
Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot...


sqlsql-serversql-server-2008pivotpivot-table

Read More
How to create table using select query in SQL Server?...


sqlsql-serversql-server-2008

Read More
Get the database name in which Stored Procedure exists...


sql-serverdatabasesql-server-2008t-sqlstored-procedures

Read More
Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statem...


sql-serversql-server-2008code-reuse

Read More
Set variable to NULL if not found in query statement...


sqlsql-serversql-server-2008

Read More
T-SQL USE satetement in condition...


sql-serversql-server-2008stored-procedures

Read More
Get MAX value of a BIT column...


sqlsql-servert-sqlsql-server-2008stored-procedures

Read More
Is full text search suitable for searching people's names?...


sql-serversql-server-2008

Read More
The transaction log for the database is full...


sqlsql-serversql-server-2008loggingdynamics-crm

Read More
SQL Server 2008 R2 DeadLock on query Notification (SqlDependency)...


c#sql-server-2008sqldependency

Read More
Why use the INCLUDE clause when creating an index?...


sql-serversql-server-2008sql-server-2005indexing

Read More
Why am I getting Data provider or other service returned an E_FAIL status? SQL Native Client...


sql-server-2008asp-classicvbscriptado

Read More
Import Excel Spreadsheet Data to an EXISTING sql table?...


sqlsql-serverexcelsql-server-2008import

Read More
Retrieving billions of rows from remote server?...


sqlsql-serversql-server-2008

Read More
Combining (concatenating) date and time into a datetime...


sqlsql-serversql-server-2008t-sqldatetime

Read More
SQL ignore part of WHERE if parameter is null...


sqldatabasesql-server-2008stored-procedures

Read More
Schema objects not visible in SQL Server Management Studio 2008...


sql-serversql-server-2008ssms

Read More
Using RegEx in SQL Server...


sql-serverregexsql-server-2008t-sql

Read More
How to convert number of minutes to hh:mm format in TSQL?...


sql-servert-sqlsql-server-2008type-conversiondatediff

Read More
Error 'the subreport could not be found at the specified location. Please verify that the subrep...


sql-serversql-server-2008reporting-services

Read More
Retrieving last record in each group from database - SQL Server 2005/2008...


sql-server-2005t-sqlsql-server-2008distinct

Read More
How to get the name of a the student who got max marks in each subject?...


sqlsql-serversql-server-2008sql-server-2005sql-server-2008-r2

Read More
Reset identity seed after deleting records in SQL Server...


sqlsql-serverdatabasesql-server-2008azure-sql-database

Read More
How can I create a unique constraint on my column (SQL Server 2008 R2)?...


sqlsql-serversql-server-2008unique-constraint

Read More
How to dynamically set the value of a parameter in sp_executesql without modifying the calling softw...


sqlsql-serversql-server-2008sql-server-2005

Read More
Altering the stored procedure does not affect the output...


sqlsql-serversql-server-2008

Read More
Why can't I perform an aggregate function on an expression containing an aggregate but I can do ...


sqlsql-serversql-server-2008t-sqlsql-server-2005

Read More
Edit asterisk symbol into list of column names in SSMS by wildcard expansion...


sqlsql-serversql-server-2008sql-server-2017sql-server-2019

Read More
SQL Server TDE - how to tell when complete?...


sql-server-2008encryptiontde

Read More
BackNext