Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags XML, T-SQL Rss

   Items 1 to 20 of 36    Older >>
 

Extract the titles from XML

By Steve Jones 2015/07/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,471 reads

Deterministic

By Stewart Campbell 2015/04/16 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,588 reads

Computed Column

By Stewart Campbell 2015/04/14 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,695 reads

Secondary XML Indexes

By Steve Jones 2015/03/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,409 reads

XML Indexes

By Steve Jones 2015/03/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,448 reads

Formatted output

By Anju Renjith 2014/10/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,963 reads

Which query will give an error?

By Vimal Lohani 2014/08/15 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,855 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,539 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,186 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,186 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,185 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 | 3,095 reads

XML

By Ryan Barrett 2011/12/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,103 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,280 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,920 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,281 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,586 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,440 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,723 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,920 reads
   Items 1 to 20 of 36    Older >>
 
Tags
miscellaneous (9)    
stored procedures (8)    
basics (6)    
indexing (5)    
openxml (4)    
performance tuning (4)    
updategrams (4)    
xsl (4)    
sql server 7 (3)    
ado (2)    
comma seperated (2)    
computed columns (2)    
delimited strings (2)    
parsing delimited string (2)    
programming (2)    
schemas/dtds (2)    
visual basic 6 (2)    
xquery (2)    
administration (1)    
advanced querying (1)    
backup and restore (1)    
check constraints (1)    
configuring (1)    
create (1)    
database design (1)    
deterministic (1)    
distributed queries (1)    
dts (1)    
english query (1)    
etl (1)    
execute (1)    
for xml (1)    
foreign keys (fk) (1)    
installation (1)    
mds (1)    
monitoring (1)    
news (1)    
nodes() (1)    
persisted (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)