SQL Server

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

Learn how to declare variables in SQL Server (Transact-SQL) with syntax and examples. What is a variable in SQL Server? In SQL Server (Transact-SQL), a variable allows a programmer to store data…

ASCII table (which stands for American Standard Code for Information Interchange) is a character encoding standard for text files in computers and other devices. ASCII is a subset of Unicode and is…

Unicode is an international character encoding standard that includes different languages, scripts and symbols. Each letter, digit or symbol has its own unique Unicode value. Unicode is an extension of ASCII that…

The following is a list of datatypes available in SQL Server (Transact-SQL), which includes string, numeric, and date/time datatypes. String Datatypes The following are the String Datatypes in SQL Server (Transact-SQL): Data…

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…