Different types of Procedures in MySQL
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 »
Tag Archives: SQL-Server
Comparisons between Oracle vs SQL Server
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 »
Difference between MySQL and MS SQL Server
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 »
SQL | Checking Existing Constraints on a Table using Data Dictionaries
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 »
SQL SERVER | IN Condition
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 »
Allow only alphabets in column in SQL Server
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 and Mode in SQL Server
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 | SERVERPROPERTY()
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 »
SQL Server | STUFF() Function
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 »
SQL SERVER | Conditional Statements
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 »
SQL Server Identity
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 »
