Daily Archives: February 5, 2017

As mentioned earlier, the Transact-SQL statements have three categories: DDL statements, DCL statements, and DML statements. Each of the commands in these categories include keywords and parameters that can be used to create, modify, and query SQL Server 2014 databases and tables. The three types are: Data Definition Language (DDL) […]

SQL Server T-SQL Statements

We need to back to basics in our Transact SQL (T-SQL) studies and look at programming with variables. SQL Server allows you to create reusable programming objects. The SQL Server reusable programming objects include Views Stored Procedures Functions Triggers SQL Server Transact-SQL language also allows temporary storage in the form […]

SQL Server T-SQL Variables