XML Workshop XV - Accessing FOR XML results with ADO.NET
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,714 reads
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,714 reads
Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.
2008-02-13
7,865 reads
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
2008-02-06
8,841 reads
Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.
2008-01-23
3,202 reads
Part 3 of his series looking at SQL Server Compact Edition, then embedded version of SQL Server. This time we look at the new version that's in beta.
2007-12-27
2,254 reads
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,937 reads
Building SSIS packages and deploying them to production can be a challenge as connection strings and directory structures change. Longtime SQL Server guru Jacob Sebastian brings us a technique for building packages to make this easier.
2007-12-12
11,278 reads
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
2007-12-05
7,269 reads
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
2007-11-21
4,600 reads
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
2007-11-14
6,208 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers