Varchar(Max) and ADO
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
835 reads
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
835 reads
This is an older article that was recycled for Fri, but still seems to get a decent number of views...
2007-11-04
454 reads
Just saw the announcement that there will be two back to back TechEd's next year. Both will be held in...
2007-11-03
343 reads
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
2007-11-02 (first published: 2006-01-25)
27,134 reads
I had the chance to see Greg do a presentation at the PASS Summit in Denver that was based on...
2007-11-02
351 reads
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
2007-11-01 (first published: 2001-05-07)
24,616 reads
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,415 reads
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,440 reads
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,955 reads
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,448 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers