Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

Return one of two columns in a view - whichever one is not null

How to delete all duplicate records from SQL Table?

Update WHERE NOT EXISTS problem

SQL Server PIVOT perhaps?

Setting and resetting the DATEFORMAT in SQLServer 2005

How to pass parameter values to a T-SQL query

SQL: how to select single record for multiple id's on the basis of max datetime?

identifying values which would be truncated in an insert query

SQL Server, select a record every 'x' amount of records

Converting datetime format to 12 hour

Programmatically detach SQL Server database to copy mdf file

SQL Server won't use my index

How to solve 'invalid object name' in SQL Server?

sql sql-server-2005

C# SqlCommand - cannot use parameters for column names, how to resolve?

c# sql sql-server-2005

Composite primary keys and influence on natural/surrogate keys usage [closed]

How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?

SQL Performance-wise, what's better: an IF...ELSE clause, or WHERE LIKE clause?

sql sql-server-2005 tsql

Best way to change clustered index (PK) in SQL 2005

tsql script to find tables not being used by stored procedures, views, functions, etc?

Having TRANSACTION In All Queries