MS SQL Hyper-V Replication
If you are running MS SQL on Hyper-V, I highly recommend that you enable hyper-V replication. Hyper-v replication is recommended […]
Information Technology, Microsoft SQL
Microsoft SQL
Information Technology, Microsoft SQL
MS SQL how to replace line feed or carriage return with space
SQL 2000, SQL 2005 and SQL 2008 You can replace carriage return and line feed in a field by running
Information Technology, Microsoft SQL
SQL 2005 MM-DDD-YY format
To format a date as MM-DDD-YY Today: REPLACE(right(UPPER(convert(varchar(20),getdate() ,06)), len(convert(varchar(20),getdate(),06))), ‘ ‘, ‘-‘) to get Yesterday’s date: PRINT REPLACE(right(UPPER(convert(varchar(20),getdate()-1 ,06)),
Microsoft SQL
SQL breakdown TIME
This statement will count number of records in a given month and breakdown it every 30 minutes. select count(ID) as
Microsoft SQL
SQL updating field with current timestamp
MS SQL to update a field to current time: update tbl1 set col1 = convert(varchar(5),getdate() ,108) result: col1 13:05