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

min Function (XQuery)

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

Querying XML

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

Inserting XML

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

Why STUFF

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

Converting to XML

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

Extract the titles from XML

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

Deterministic

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

Computed Column

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

Secondary XML Indexes

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

XML Indexes

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

Formatted output

By Anju Renjith 2014/10/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,981 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,552 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,191 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,191 reads

XML to Relational

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