Tag: RETURN

By Posted on Posted in TSQL No Comments Tagged with , , , , , , ,

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET OPENXML OPTION OVER PIVOT PRIMARY PROCEDURE RAISERROR RECONFIGURE REPLICATION RESTORE RETURN RIGHT ROLLBACK ROWCOUNT SELECT SET STATISTICS THEN TRAN TRANSACTION …

SQL Sunday Fun – Word Search with SQL Server Keywords Read more »

By Posted on Posted in TSQL No Comments Tagged with , , , , , , , , ,

In my Common Table Expressions presentation the topic of recursion often comes up, but for scalar functions in T-SQL, it might not be as common. This article has been written to show how a scalar function in SQL Server can call itself, thus being considered recursive. The example uses a recursive scalar function to calculate the Fibonacci sequence. What is …

Recursive Scalar Function in T-SQL Read more »

By Posted on Posted in 70-461 Training, SQL 2008, SQL 2012, SQL 2014, TSQL, TSQL 2012 1 Comment Tagged with , , , , , , , ,

SQL Server 2012 adds a new function called DateFromParts.  This new function simplifies the creating of a DATE type in TSQL over the older ways of doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in TSQL 2012. Pre-SQL 2012 First lets take a look at how you would do the equivalent to DateFromParts before SQL …

DATEFROMPARTS function in TSQL Read more »