Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

Generate a resultset of incrementing dates in TSQL

How can I create a SQL unique constraint based on 2 columns?

Can there be constraints with the same name in a DB?

SQL Server 2005 drop column with constraints

How do I avoid character encoding when using "FOR XML PATH"?

SQL Server: how to write an alter index statement to add a column to the unique index?

Column name or number of supplied values does not match table definition

How to get SQL Profiler to monitor trigger execution

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

How to get difference between two rows for a column field?

How to insert multiple records and get the identity value?

How get the T-SQL code to find duplicates?

sql-server-2005 tsql ssms

SQL Query to add a new column after an existing column in SQL Server 2005

Convert Xml to Table SQL Server

How to upsert (update or insert) in SQL Server 2005

sql-server-2005

How to store directory / hierarchy / tree structure in the database?

Decimal values in SQL for dividing results

How do parameterized queries help against SQL injection?

Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

Why is it considered bad practice to use cursors in SQL Server?