2012-03-15
2 reads
Schemas+DTDs
2012-03-14
4 reads
2007-09-27
3 reads
2007-09-23
3 reads
XML Workshop VII - Validating values with SCHEMA
This installment of the XML Workshop by Jacob Sebastian continues looking at XML Schemas in SQL Server 2005. Here we learn how the format and range of values can be checked using an XML schema.
2007-09-19
4,939 reads
XML Workshop VI - Typed XML and SCHEMA Collection
The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML subsystem. Regular author Jacob Sebastian brings structure to your XML documents with a few schema examples.
2007-09-05
7,377 reads
Creating Stored Procedure Documentation with XML, SQL-DMO and XSLT
This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT.
2002-08-09
15,464 reads
bcp command -- what am I doing wrong?
Hi all . . . Am trying to use bcp to do a bulk insert into a table. The syntax I'm using is as follows: bcp "[Database_Name].dbo.[Table_Name]" in "filename.txt" -r"~" -m25 -U"sysadminID" -P"sysadminPW" Note: the tilde "~" is my flat file field delimiter, and the maxerror flag is set because I'm trying to import into […]
2002-03-20
1,206 reads
Bytes per row
I have a table with several columns and data types. I am looking for assistance on how I can query this table to calculate the total number of bytes created for this table. -JG -JG
2002-03-20
291 reads
SQLXML 2.0 (XML for SQL Server 2000)
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
2001-10-29
6,623 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Open Enrollment at WordPress.com: Free Websites for Students
By Rob Sewell
A website can change the world. If you're a student, we'd like to help...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers