Author: K Z

Question: Is there a query to run in SQL Server that will return all Users created? Answer: In SQL Server, there is a system view called sys.database_principals. You can run a query against this…

A Login is an identity used to connect to a SQL Server instance. A User allows you to log into a SQL Server database and is mapped to a Login. So you will need…

Question: Is there a query to run in SQL Server that will return all SQL Server Logins and information about those Logins? Answer: In SQL Server, there is a catalog view (ie: system…

This SQL Server tutorial explains how to use the GLOBAL TEMPORARY TABLES in SQL Server (Transact-SQL) with syntax and examples. Description GLOBAL TEMPORARY TABLES in SQL Server (Transact-SQL) are tables that are…

This SQL Server tutorial explains how to use the LOCAL TEMPORARY TABLES in SQL Server (Transact-SQL) with syntax and examples. Description LOCAL TEMPORARY TABLES are distinct within modules and embedded SQL programs…

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…