SQL Server also creates a row in the sysobjects table, as it does for most database objects. The problem arises when you rename the object in Enterprise Manager or with the sp_rename stored procedure.

Built on the .Net platform, xSQL Object 1.5 supports SQL Server 2000 and requires .Net Framework 1.1 or later. Pricing starts at $199 for a single-user license; $499 for a 5-user license; and $999 ...

In a previous Practical .NET column I showed how to retrieve rows that hold JSON objects by querying on values in those objects’ properties. However, sometimes you’ll want to work with the complete ...

Declare @Customers Table (id nvarchar(100), createdOn Date); In a production system, rather than use a Table variable, I could truncate an existing table on disk and load the rows from my JSON object ...