Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

Sql Server 2005 how to change dbo login name

Nested stored procedures containing TRY CATCH ROLLBACK pattern?

Create a one to many relationship using SQL Server

When using Trusted_Connection=true and SQL Server authentication, will this affect performance?

What's the fastest way to bulk insert a lot of data in SQL Server (C# client)

Rename SQL Server Schema

Add a row number to result set of a SQL query

Delete duplicate records from a SQL table without a primary key

Execute Stored Procedure from a Function

Is it possible to force row level locking in SQL Server?

Increment Row Number on Group

How to get number of rows inserted by a transaction

Convert SSMS .rpt output file to .txt/.csv

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