INPUT and OUTPUT type parameters in stored procedures

Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output. The OUTPUT keyword in the procedure’s definition or its invocation, designates the input/output type of a parameter. The shorten CREATE syntax for stored procedure Continue reading INPUT and OUTPUT type parameters in stored procedures

Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple

For example the next command

will create database AdventureWorks2014_Clone with Continue reading Database cloning – CLONEDATABASE