Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, XML Rss

   Items 1 to 20 of 30    Older >>
 

Which query will give an error?

By Vimal Lohani 2014/08/15 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 reads

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,460 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,139 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,139 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,153 reads

XML-XSL Transformations in SQL Server

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.  Read more...
By Cem G├╝ler 2012/01/04 | Source: SQLServerCentral.com | Category: mds
Rating: |  Discuss |   Briefcase | 2,947 reads

XML

By Ryan Barrett 2011/12/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,076 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,241 reads

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...
By Mohd Nizamuddin 2010/10/22 (first published: 2009/08/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,898 reads

Sending multiple rows to the Database from an Application: Part I

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...
By Mohd Nizamuddin 2010/10/15 (first published: 2009/08/18) | Source: SQLServerCentral.com | Category: comma seperated
Rating: |  Discuss |   Briefcase | 27,264 reads

SQL Server 2008 Table Valued Parameters Performance

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...
By Scott Zurolo 2010/07/08 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 9,517 reads

Another way to get a table list from a string

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.  Read more...
By Bernabe Diaz 2010/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,432 reads

Using T-SQL to Transform XML Data to a Relational Format

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.  Read more...
By Nasir Mirza 2009/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,658 reads

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...
By Mohd Nizamuddin 2010/10/22 (first published: 2009/08/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,898 reads

Sending multiple rows to the Database from an Application: Part I

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...
By Mohd Nizamuddin 2010/10/15 (first published: 2009/08/18) | Source: SQLServerCentral.com | Category: comma seperated
Rating: |  Discuss |   Briefcase | 27,264 reads

Using the FOR XML Clause to Return Query Results as XML

The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in Books-on-Line. We challenged Bob Sheldon to make it seem simple. Here is his sublime response.  Read more...
By Additional Articles 2009/06/11 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,060 reads

XML Index

Checking XML indexs with a sample.  Read more...
By abmore 2008/09/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,361 reads

Sales Order Workshop Part IV

In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever.   Read more...
By Jacob Sebastian 2007/04/05 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 12,211 reads

Sales Order Workshop Part III

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.   Read more...
By Jacob Sebastian 2007/04/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,668 reads

Sales Order Workshop Part II

In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.  Read more...
By Jacob Sebastian 2007/03/29 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,247 reads
   Items 1 to 20 of 30    Older >>
 
Tags
miscellaneous (9)    
stored procedures (8)    
basics (6)    
openxml (4)    
performance tuning (4)    
updategrams (4)    
xsl (4)    
indexing (3)    
sql server 7 (3)    
ado (2)    
comma seperated (2)    
delimited strings (2)    
parsing delimited string (2)    
programming (2)    
schemas/dtds (2)    
visual basic 6 (2)    
administration (1)    
advanced querying (1)    
backup / restore (1)    
check constraint (1)    
configuring (1)    
create (1)    
database design (1)    
distributed queries (1)    
dts (1)    
english query (1)    
etl (1)    
execute (1)    
foreign keys (fk) (1)    
installation (1)    
mds (1)    
monitoring (1)    
news (1)    
primary key (pk) (1)    
replication (1)    
security (1)    
sql server 2005 (1)    
table (1)    
triggers (1)    
tvp (1)    
unique (1)    
user defined function (udf) (1)    
user-defined data types (1)    
xquery (1)