This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies.
MS Sql Server
Data types in MS SQL Server
A data type is an attribute that specifies the type of data that the object can ...
Sql Server Basics and Architechture
MS SQL Server is a client-server architecture. MS SQL Server process starts with...
User-Defined Functions in Sql Server
User-defined functions (UDFs) are routines that accept parameters, perform compl...
COALESCE Function in Sql Server
The Coalesce function of the SQL server is used to manage Null values.
Database normalization in Sql Server
Database normalization is the process of organizing the fields and tables of a r...
Table Variables in Sql Server
Like the temp table in SQL Server, a table variable is a sort of local variable ...
Temporary tables in Sql Server
Temporary tables are tables that exist temporarily on the SQL Server. The tempor...