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 41    Older >>
 

min Function (XQuery)

By Mikael Eriksson 2016/08/25 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,045 reads

Querying XML

By Steve Jones 2016/06/22 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,133 reads

Inserting XML

By Steve Jones 2016/06/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,387 reads

Why STUFF

By Steve Jones 2016/05/04 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 1,678 reads

Converting to XML

By Steve Jones 2016/03/30 | Category: try_convert()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,211 reads

Extract the titles from XML

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

Deterministic

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

Computed Column

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

Secondary XML Indexes

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

XML Indexes

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

Formatted output

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

Which query will give an error?

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

XML to Relational

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

XML

By Ryan Barrett 2011/12/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,112 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,284 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,921 reads
   Items 1 to 20 of 41    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)    
stuff (1)    
table (1)    
triggers (1)    
try_convert() (1)    
tvp (1)    
unique (1)    
user defined function (udf) (1)    
user-defined data types (1)