SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Monday, August 26, 2013
Date time formatting in SQL Server
›
Below is a small script that shows you the date output in different format: It just outputs the current date in the various formats so yo...
Monday, August 19, 2013
Query to create a Table of dates between date range specified
›
Use below query to create a table of date for given date range: DECLARE @FromDt AS DateTime = '2013-09-01', @ToDt AS DateTime = ...
Monday, August 12, 2013
Restart Computer Failure While uninstalling SQL Server 2008
›
You may get the below error while uninstalling SQL server: A computer restart is required. You must restart this computer before install...
Monday, August 5, 2013
Msg 1934, Level 16, State 1, Line 2
›
Today I was running below query to rebuild all indexes: EXEC sp_msforeachtable 'ALTER INDEX ALL ON ? REBUILD' But it failed and...
1 comment:
Monday, July 22, 2013
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
›
Today when I was connecting my SQL server from some client system, connection established successfully with the server. However, then an er...
24 comments:
‹
›
Home
View web version