Basic Overview of C #
This article describes an introduction of C# programming language. What is C#?C# (pronounced C-sharp) is a one kind of objects oriented language developed by Microsoft Corporation. It is designed with …
SQL BETWEEN operator for datetime
This article describes about the SQL between operator, how to use SQL between operator in date time operation? Create a Temp table. For the sql query is Create Table #Temp …
Remove or trim the leading zeros in SQL
Some times we need to remove or trim the leading zeros in an alphanumeric column of a table flied. Following SQL query will help us to do this. DECLARE @String …
Difference between temp table and table variable
In SQL, temp tables and table variables are used to save or store data in temporary basis. Both are almost same, but have some difference. This article describes a comparison …
SQL Server Database Backup
Backup is an vital part for any database system. It reduce accidental data loses. This article describes how to create a database backup in SQL query. Summary of the article: …