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

Content with tags T-SQL, XML Rss

   Items 1 to 20 of 43    Older >>
 

Finding the name

By Steve Jones 2017/01/20 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 904 reads

The Attribute

By Steve Jones 2016/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,178 reads

min Function (XQuery)

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

Querying XML

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

Inserting XML

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

Why STUFF

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

Converting to XML

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

Extract the titles from XML

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

Deterministic

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

Computed Column

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

Secondary XML Indexes

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

XML Indexes

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

Formatted output

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

Which query will give an error?

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

XML

By Ryan Barrett 2011/12/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,115 reads
   Items 1 to 20 of 43    Older >>
 
Tags
miscellaneous (9)    
stored procedures (8)    
basics (6)    
indexing (5)    
openxml (4)    
performance tuning (4)    
updategrams (4)    
xsl (4)    
sql server 7 (3)    
xquery (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)    
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)