SQL Server

Learn how to create and drop procedures in SQL Server (Transact-SQL) with syntax and examples. What is a procedure in SQL Server? In SQL Server, a procedure is a stored program that…

This SQL Server tutorial explains how to use literals (strings, integers, decimals, and datetime values) in SQL Server with examples. Description In SQL Server, a literal is the same as…

Learn how to create, rename and drop indexes in SQL Server with syntax and examples. What is an Index in SQL Server? An index is a performance-tuning method of allowing faster retrieval…

Learn how to grant and revoke privileges in SQL Server (Transact-SQL) with syntax and examples. Description You can GRANT and REVOKE privileges on various database objects in SQL Server. We'll look at…

Learn how to create and drop functions in SQL Server (Transact-SQL) with syntax and examples. What is a function in SQL Server? In SQL Server, a function is a stored program that…

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…