Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2005

T-SQL: Comparing Two Tables - Records that don't exist in second table

sql sql-server-2005 tsql

Keyboard shortcut for "Connect to Server" in Management Studio

sql-server-2005 ssms

Use hardcoded list of values in query

sql-server-2005

subqueries in UPDATE SET (sql server 2005)

sql-server-2005 subquery

Entity Framework - default values doesn't set in sql server table

get new SQL record ID

Is it possible for a trigger to find the name of the stored procedure that modified data?

SQL Server 2005 : str(4.65,5,1) = 4.7, str(3.65,5,1) = 3.6?

Why can't i refer to a column alias in the ORDER BY using CASE?

What is the minimum number of rows required to create an index?

Priming or warming cache in SQL Server

LINQ to SQL entity column name attribute ignored with guid primary key

Methods to migrate SQL Database (mdf) to SQL Compact Edition (sdf)

Is there a way to escape a double quote within a text qualified string on a SSIS Csv import?

Is this query equivalent to SQL Server 2008's OPTIMIZE FOR UNKNOWN?

What are the pitfalls of using sql_variant?

Slow performance of SqlDataReader

Inverse of COALESCE

TABLESAMPLE returns wrong number of rows?

Cannot call methods on char