SQL Server Archives - Page 10 of 14 - Adglob Infosystem Pvt Ltd

SQL Server: Foreign Keys with cascade delete

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use Foreign Keys with cascade delete in SQL Server with syntax and examples. What is a foreign key with Cascade DELETE in SQL Server? A…

SQL Server: Primary Keys

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

Learn how to create, drop, disable, and enable a primary key in SQL Server (Transact-SQL) with syntax and examples. What is a primary key in SQL Server? In SQL Server (Transact-SQL), a…

SQL Server: Foreign Keys

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:2 Comments

This SQL Server tutorial explains how to use Foreign Keys in SQL Server with syntax and examples. What is a foreign key in SQL Server? A foreign key is a way to…

SQL Server: Foreign Key Topics

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

The following is a list of topics that explain how to use Foreign Keys in SQL Server (Transact-SQL): Create Foreign Keys Create Foreign KeysCreate Foreign Keys with cascade deleteCreate Foreign…

SQL Server: TRUNCATE TABLE Statement

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the TRUNCATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples. Description The TRUNCATE TABLE statement is used to remove all records from…

SQL Server: Subqueries

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use subqueries in SQL Server (Transact-SQL) with syntax and examples. What is a subquery in SQL Server? In SQL Server, a subquery is a query…

SQL Server: HAVING Clause

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the HAVING clause in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) HAVING clause is used in combination with the GROUP…

SQL Server: AVG Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the AVG function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the AVG function returns the average value of…

SQL Server: MAX Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the MAX function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the MAX functions returns the maximum value of…

SQL Server: MIN Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the MIN function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the MIN function returns the minimum value of…