Author: K Z

This SQL Server tutorial explains how to use the SQL Server DROP USER statement with syntax and examples. Description The DROP USER statement is used to remove a user from the SQL…

This SQL Server tutorial explains how to use the SQL Server CREATE USER statement with syntax and examples. Description The CREATE USER statement creates a database user to log into SQL Server.…

This SQL Server tutorial explains how to use comments within your SQL statements in SQL Server (Transact-SQL) with syntax and examples. Description Did you know that you can place comments…

This SQL Server tutorial explains how to use the ALTER TABLE statement in SQL Server (Transact-SQL) to add a column, modify a column, drop a column, rename a column or rename a…

This SQL Server tutorial explains how to use the CREATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) CREATE TABLE statement allows you to create…

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…