Database Management System

Foreign Key through GUI in SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Database, Database Management System, Foreign Key, GUI, sql server, Zia Ahmed Shaikh.

Use Distinct Keyword in T-SQL (SQL Server)

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Database, Database Management System, Distinct Keyword, sql server, Zia Ahmed Shaikh.

Concatenate Columns in SQL Server T-SQL

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Comment, Concatenate Columns, Database, Database Management System, Execute Query, sql server, Zia Ahmed Shaikh.

Introduction to T-SQL (SQL Server)

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Database, Database Management System, sql server, T-SQL, Transaction SQL, Zia Ahmed Shaikh.

Generating SELECT (JOIN) Query Through Criteria Pane, SQL Pane, and Diagram Pane

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Criteria Pane, Database, Database Management System, Diagram Pane, Generate Query, SELECT (JOIN) Query, SQL Pane, sql server, Zia Ahmed Shaikh.

Creating Computed Columns with User Defined Functions – SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Computed Column, Create Function, Database, Database Management System, Persisted, sql server, User Defined Function, Zia Ahmed Shaikh.

Creating Computed Column in SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Create Computed Column, Database, Database Management System, Is Persisted, Performance, Zia Ahmed Shaikh.

Using Criteria Pane in SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Alias, Apply Sorting, Criteria Pane, Database, Database Management System, Design View, sql server, Zia Ahmed Shaikh.

Primary Key Constraint in SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Database, Database Management System, NOT NULL, Primary Key, Row Identity, sql server, Uniqe Key, Zia Ahmed Shaikh.

Unique Key Constraint in SQL Server

Posted on November 2, 2018

Read the rest of this entry »

This entry was posted in Database Systems, SQL Server and tagged Database, Database Management System, duplicate key, sql server, Uniqe Key Constraint, Zia Ahmed Shaikh.