Category: Miscellaneous

Data type conversion is a method used to change the data type of a value into the other type. SQL Server can convert the data type of a value in two ways: implicitly or explicitly. SQL Server performs implicit conversion for their internal needs. For example, the following query will implicitly convert the string data type into the number…

A trigger is a set of SQL statements that reside in system memory with unique names. It is a specialized category of stored procedure that is called automatically when a database server event occurs. Each trigger is always associated with a table. A trigger is called a special procedure because it cannot be called directly like a…

A stored procedure is a group of one or more pre-compiled SQL statements into a logical unit. It is stored as an object inside the database server. It is a subroutine or a subprogram in the common computing language that has been created and stored in the database. Each procedure in SQL Server always contains a name, parameter…

A temporary (temp) table in SQL Server is a special table that cannot be stored permanently on the database server. This table keeps a subset of data from a regular table and can be reused multiple times in a particular session. We cannot store this table in the memory. Since this table exists temporarily on the…

It is a built-in function in SQL Server. It allows the user to replace the NULL values with a given replacement value. This article gives a complete overview of the ISNULL function to return an alternative value if the expression or table records have NULL values. Syntax The following is a syntax that illustrates the ISNULL function:…

The IF statement is a part of the control flow function in SQL Server. Usually, it is a decision-making statement in various programming languages that returns a value based on the given conditions. This statement executes the code written in IF block when the given condition evaluates to true and when the condition evaluates false, then…

This article will explain the complete overview of a SELECT INTO statement in SQL Server. We will use this statement to add data into tables. When we use this statement, it will first create a new table in the default filegroup before inserting the records selected by the SELECT statement into that new table. It…

Data type conversion is a method used to convert the data type of a value into the other type. All programming languages must have some data type converting functions. Similarly, SQL Server allows the user to change the data type of a value either implicitly or explicitly. SQL Server performs implicit conversion for their internal needs. In contrast,…

Data type conversion is a method used to change the data type of a value into the other type. SQL Server can convert the data type of a value in two ways: implicitly or explicitly. SQL Server performs implicit conversion for their internal needs. For example, the following query will implicitly convert the string data type into the number…

A trigger is a set of SQL statements that reside in system memory with unique names. It is a specialized category of stored procedure that is called automatically when a database server event occurs. Each trigger is always associated with a table. A trigger is called a special procedure because it cannot be called directly like a…