With SQL Server 2016 ... converted to a virtual table, effectively creating a table from a column in the row. You can then join that virtual table to its row using CROSS APPLY. This query, for example ...

Some of these modules use what is called the SQL Management Object (SMO ... a portion of the properties which are available to view at the SQL instance level. We can now begin digging down into our ...

However, even without a JSON datatype, SQL Server 2016 still lets you query data stored in JSON format. I’ll look at that support in a later column (among other features, it provides a way to ...

Despite these minor drawbacks, I definitely recommend exploring the table parameter feature when SQL Server 2008 comes out. Tim Chapman is a SQL Server database administrator who works for a bank ...

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform ... constraints: IF OBJECT_ID('SalesHistory') > 0 DROP TABLE SalesHistory GO CREATE TABLE ...

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.