Error : Saving Changes in not permitted.

I like how SSMS takes stance of displaying warning message and stops user from going further to do operation, thereby preventing hanging of SSMS. However, this feature can cause inconvenience in a situation when one is required to save table using SSMS. If such situation arises, then this feature ca... [More]

Tags:
Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed

Date Formats in Sql Server

--Date--SELECT CONVERT(VARCHAR(20), GETDATE(), 100)SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]  SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]SELECT CONVERT(VARCHA... [More]

Tags:
Permalink | Comments (0) | Post RSSRSS comment feed