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 ...

U-SQL supports both scalar function and table valued function (TVF). Functions take zero to many arguments and return either a single scalar value or a table, which is a dataset comprised of ...

However, you can greatly improve the performance by converting the scalar function to a table-valued function and using a CROSS APPLY in the query.

Welcome to another exciting installment of “Deep Thoughts by Jack Handy T-SQL Theory questions that only Maxer seems to care about…”If trees could scream, would we be so cavalier about ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.