Mar 25, 2009
# 2,284
Recently I had troubles restoring a database in my SQL Server 2005 instance (SP3). I used the ‘wizard’ in the SQL Server Enterprise manager but after I got the message ‘restore completed successfully’ the database hung in ‘Restoring’ state, blocking connections. read more →
Nov 15, 2006
# 214
Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →
Nov 3, 2006
# 1,342
Cursors in tsql, it can be done … read more →
Nov 1, 2006
# 344
Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →
Sep 18, 2006
# 160
Getting around in the mssql environment read more →
Sep 17, 2006
# 443
Date time functions (frustrations) in T-SQL. read more →
