SQL IN Operator
You can specify multiple values with IN operator and it will return matching values from WHERE clause of a table. IN operator matches values in a list or subquery and returns the output. Here...
Author: Manzoor Siddiqui
Fixed Server Roles in SQL Server
445viewsTo maintain security and access level of database, SQL Server provides fixed server roles. As the name indicates, you cannot modify or alter server roles hence it helps to manage permissions on the server....
SQL CREATE TABLE Statement
A table is primarily a list of useful items or a group of lists and to manage such list it should be organised. To organise this information it is divided into rows and columns....
IIF() Logical Function in SQL Server
IIF() logical function has been introduced in SQL Server 2012. We already know about CASE expression and IF-Else statement in SQL Server so now you can also use IIF() function to get the same output in...
Backup All User and System Databases with Compression by T-SQL
552viewsIn previous article we have seen how to backup system databases by creating maintenance plan. Here we will use T-SQL to backup all user and system databases with compression. You can also create SQL...
How to work with Maintenance Plan Wizard in SQL Server
438viewsSQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize indexes, update statistics, backup databases and performs maintenance cleanup tasks etc. These...
