Tag Archives: SQL-Server

Prerequisite: SQL-Constraints In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition. One can use… Read More »

IN condition is an alternative to multiple OR conditions in SELECT, INSERT, UPDATE, or DELETE statement. The IN operator allows multiple values to be tested… Read More »

There may occur some situations when data in column should only be in alphabets, for example: Name column in details table. If user try to… Read More »

Mean is the average of the given data set calculated by dividing the total sum by the number of values in data set. Example: Input:… Read More »

SQL Server provides a System Defined function SERVERPROPERTY(propertyname). SERVERPROPERTY(): SERVERPROPERTY() function is used to return the information about different properties of system or so called… Read More »

There are situations when user want to change some portion of the data inserted. The reason may be because of the human error or the… Read More »

While loop: In SQL SERVER, while loop can be used in similar manner as any other programming language. A while loop will check the condition… Read More »

Identity column of a table is a column whose value increases automatically. The value in an identity column is created by the server. A user… Read More »