Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

Synchronize access to static variables in sql server SQLCLR

Slowly Changing Fact Table?

sql sql-server ssis ssas

How do I select one parent row and additional rows for its children without a UNION?

SQL Server dynamic Order By in query, different data types

Multiple queries using one SqlCommand possible?

.net sql sql-server

Why does creating a table with a foreign key constraint in one transaction block access to the referenced table in another?

sql-server transactions

Are there any programs that will shrink the size of a sql script file?

sql sql-server

Classic ASP - using one connection for many queries?

Update and Insert Stored Procedure

Sql-server Full Text CONTAINS + COLLATE to ignore accents issues

tSQL CASE to control execution

sql sql-server tsql syntax

How can I view the history of inserts to a table?

sql-server

How to speed up a SQL Server query involving count(distinct())

How to check .txt file existence with TSQL?

sql sql-server tsql

How to check that a delete / update operation completed successfully when using a stored procedure?

Calling stored procedures, passing NULL values, dealing with boolean values

Is there any way to make this UDF deterministic?

What GUID can I use as a placeholder

How do you drop a column with an unamed default value constraint and unknown indexes

Unicode characters causing issues in SQL Server 2005 string comparison