SQL Server Unique Constraints
In SQL Server, constraints are certain rules that can enforce data integrity on database tables. In...
SQL Server Synonyms
An SQL Server Synonym is a special database object used to an alias or alternative name for an existing object within the local server...
SQL Server PIVOT Operator
In SQL Server, PIVOT is a powerful operator to transpose table values in the rows format to table values in column format. In this article,...
SQL Server COUNT Function
COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers...
SQL Server Configuration Manager
Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by default with SQL Server Installation to...
How to limit rows in SQL Server
While executing SELECT queries on tables containing huge records, developers often need to limit the number of records being fetched out to...
SQL Server Primary Key
Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the...
SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
SSDT (SQL Server Data Tools) for Visual Studio: Main Features
SQL Server provides SQL Server developers and administrators with dedicated client tools for...
