TechRepublic

Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...
Ars Technica

TSQ Theory: Why would I use a table valued function instead of a view?

Welcome to another exciting installment of “<STRIKE>Deep Thoughts by Jack Handy<BR><BR></STRIKE> <BR>T-SQL Theory questions that only Maxer seems to care about ...
Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...
TechRepublic

Use SQL to quickly create a new table from existing records in Access

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a larger ...
TWCN Tech News

What are SQL window functions?

SQL Window functions are an advanced type of function in SQL. In this post, you will learn about what SQL window functions are and how they can be used or work. What are SQL window functions? SQL ...