Author Archive

What is ASP.Net?

ASP.NET is frameworks that allow us to developed or build web pages and web sites with HTML, CSS, and other scripting language such as JavaScript, VB Script. It is a server side technology. It accepts all .NET compatible languages. This article explains the introduction to ASP.NET Frameworks, basic overview of ASP.NET. What is ASP.NET? History

Relational Database Management System or RDBMS

Relational Database Management System is computer software/program that is developed based on relational model. At present most modern commercial and open-source database systems are using RDMS. This article explains what a RDBMS is? It also describes the basic overview of RDBMS. What is Relational Database Management System (RDMS)? Examples of RDMS What is Relational Database

Database Management System or DBMS

DBMS is the process to store and retrieve information. This article describes about the basic overview of  DBMS or Database Management System. Summary of the article: What is Database? What is Database Management System or DBMS? What is Database? The word database has comes from two words data-means information and Base-means gathering.So database means gathering

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 the combination of C and C++. It has taken a lot of concepts from Java. Data Types in C# In a programming language Data

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 (Id varchar(2), Name varchar(15), Dob datetime); Then insert some data into the table. insert into #Temp values(‘1’, ‘Komal’, ‘1984-10-27 02:10:00’); insert into #Temp values(‘2’, ‘Ajay’,

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 nvarchar(100) SET @String='000123050' SELECT SUBSTRING(@String,PATINDEX('%[1-9]%', @String),LEN(@String)) Output After run the above query you will get the output: 123050 Remember that the orginal string was: 000123050

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 on SQL temp table and table variable. SQL offer four types of table structure to store data. They are: Local temporary table (#table_name) Global temporary

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: What is Database Backup? SQL Script to Backup Single SQL Server Database SQL Script to Backup all SQL Server Databases What is Database Backup? Database