Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

Trigger to prevent Insertion for duplicate data of two columns

SQL Server stored procedure line number issue

Recommend usage of temp table or table variable in Entity Framework 4. Update Performance Entity framework

Why insert-select to variable table from XML variable so slow?

Using UNION ALL in STUFF / XML Path

How to use @@ROWCOUNT in IF statement as well as within BEGIN..END block?

SQL 2008 geography & geometry - which to use?

Union all geometry in a SQL Server table like GeomUnion in Postgres

sql sql-server-2008 spatial

Deleting column doesn't reduce database size

How to rename something in SQL Server that has square brackets in the name?

can SQL insert using select return multiple identities? [duplicate]

Generate ASP.Net Membership password hash in pure T-SQL

which datatype to use to store a mobile number

Create PK for #temp table failed when the script is run in parallel

SQL - convert int to double

sql-server-2008

How to only check the time on datetime fields but ignore the date?

sql sql-server-2008 tsql

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query

sql sql-server-2008

SQL CASE and local variables

Can you use an asterisk (*) to filter a column in a WHERE clause under SQL Server 2008?

Do CTEs use any space in tempdb?