Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

Does index_id=0 in sys.indexes refer to the table itself?

SQL Server - Enforcing uniqueness in one column depending on another column

SQL: Recursively get parent records using Common Table Expressions

How to figure out how many tables are affected in database after inserting a record?

Exclude records matching subquery

sql sql-server-2005 t-sql

In TSQL converting JSON to XML?

Use SQL Server CTE to return all Parent Records

Pymssql: Calling Stored Procedure with parameters

return only the last select results from stored procedure

Can't disable Vardecimal Storage Format

Need to store a large number of hours and minutes (ie 36:30) best method?

sql sql-server-2005

Deleting entry in SQL Server 2005 - Conversion failed when converting varchar value to data type int

SQL Query Error - Error Source: .Net SqlClient Data Provider

Similar function in SQL Server to string.format in c#

How to return a row with 0s if no data is returned?

sql t-sql sql-server-2005

msdb.dbo.sp_send_dbmail does not execute within a stored procedure

How to kill/resolve a reeeeally long-running update in SQL Server

sql-server-2005 rollback

# ifdef type conditional compilation in T-SQL sql server 2008 2005

Converting DateTime to nvarchar, just month and year

Converting JDE Julian date to Gregorian