SQL Server

Learn how to create, update, and drop VIEWS in SQL Server (Transact-SQL) with syntax and examples. What is a VIEW in SQL Server? A VIEW, in essence, is a virtual table that…

This SQL Server tutorial explains how to use the check constraints in SQL Server (Transact-SQL) with syntax and examples. What is a check constraint in SQL Server? A check constraint in SQL…

Question: How do I change the passwords for a user/login in SQL Server? Answer: In SQL Server, the password is associated with the SQL Server Login. The Login is then mapped to…

This SQL Server tutorial explains how to use the SQL Server DROP LOGIN statement with syntax and examples. Description The DROP LOGIN statements is used to remove an identity (ie: Login) used…

This SQL Server tutorial explains how to use the SQL Server CREATE LOGIN statement with syntax and examples. Description The CREATE LOGIN statement creates an identity used to connect to a SQL…

This SQL Server tutorial explains how to use the SQL Server ALTER LOGIN statement with syntax and examples. Description The ALTER LOGIN statement modifies an identity used to connect to a SQL…

Learn how to enable a foreign key in SQL Server with syntax and examples. Description You may encounter a foreign key in SQL Server (Transact-SQL) that has been disabled. You can enable…

Learn how to disable a foreign key in SQL Server with syntax and examples. Description Once you have created a foreign key in SQL Server, you may encounter a situation where you…

Learn how to drop a foreign key in SQL Server with syntax and examples. Description Once a foreign key has been created, you may find that you wish to drop the foreign key…

This SQL Server tutorial explains how to use Foreign Keys with "set null on delete" in SQL Server with syntax and examples. What is a foreign key with "Set NULL on delete"…