sarpay
7/15/2016 - 7:55 AM

SQL Notes

SQL Notes.sql
content_copyfile_download
--DATE FORMATTING:
SELECT FORMAT(GETDATE(),'dd/MM/yyyy') AS ItalianDate

--INSERTING INTO TABLE W/ IDENTITY COLUMN
SET IDENTITY_INSERT [IdentityTable] ON
INSERT INTO [IdentityTable]
([TheIdentity], [TheValue]) VALUES (3, 'First Row')
SET IDENTITY_INSERT [IdentityTable] OFF