Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,586 reads
Blog Posts
SmartPaster
I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...
2012-02-02
818 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
388 reads
SQL Server – COPY TABLE from another SQL Server
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...
2012-02-02
1,012 reads
2012-02-02
6 reads
2012-02-02
4 reads
2012-02-02
5 reads
2012-02-02
13 reads
SQL server 2012 – NextGen HADR Solution
SQL Saturday – San Diego – Sep 17 2011 Thanks you everyone for attending session, here is the presentation DAC….
2012-02-02
932 reads
SQL Server 2012 Virtual Launch
Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.
You can register the event by using the...
2012-02-02
911 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers