Skip to content

Tag Archives: SQL-Server

In this article, we will be discussing about distinct clause in MS SQL Server. Introduction : A table has a maximum of 1000 rows constituted.… Read More
In this article, order by and terms related to order by will be discussed. Introduction – There are some instances where the tables are to… Read More
In this article, the most basic statement used in SQL is being discussed. Basic statement: select There are large amounts of data available everywhere. The… Read More
Data is a collection of facts and figures and we have humungous data available to the users via the internet and other sources. To manipulate… Read More
A procedure is a subroutine (like a subprogram) in a regular scripting language, stored in a database. In the case of MySQL, procedures are written… Read More
Among several electronic database Management System, the 2 most well liked and wide used are: Oracle and SQL Server. Oracle supports the operating systems such… Read More
SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database. MySQL is an open source… Read More
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 human error or the change… 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