This article explains the most commonly used and must-know SQL Server functions and techniques that help and are handy in daily .NET Development and working with SQL Server Database projects. I found that working knowledge of these functions are very helpful and used very often in software development. Read Full Article Here
Article Covers
- GETDATE()
- DATEADD()
- DATENAME()
- DATEPART()
- DATEDIFF()
- DAY()
- MONTH()
- YEAR()
- DATALENGTH()
- APP_NAME()
- HOST_NAME()
- SYSTEM_USER
- @@IDENTITY
- IDENT_CURRENT
- SET IDENTITY_INSERT
- sp_defaultdb
- Sp_Password
Leave a Reply