| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Column Information From all User Tables | SQL Server 7.0 | Intermediate /
Brandon McPherson | 17453 since
2/21/2001 4:15:27 PM |
By 10 Users
6 Excellent Ratings
|
| |
This is a query I use to retrieve info from the user tables to build XML data on a database. With that, you can use XSL to dynamically create SQL for your apps.<br /><br />If you want to add more column data, you can select columns from dbo.syscolum ...(description truncated) |
| |
| |
| |
|
Currency Exchange rates from Central bank of Turkish Republic | SQL Server 2000 | Intermediate /
Ertan SAYGI | 13120 since
5/23/2006 6:39:49 PM |
By 3 Users
2 Excellent Ratings
|
| |
Getting XML formatted currency exchange rates data from Central bank of Turkish Republic by using stored procedures and saving it for further use. |
| |
| |
| |
|
Use OPENXML to insert values from a string of XML | Other | Intermediate /
Devin Garlit | 13891 since
7/1/2002 12:11:09 AM |
By 2 Users
|
| |
Use OPENXML to pull records from an XML string and insert them into a database. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 Use XML as a stored procedure parameter in SQL 2000! | Other | Intermediate /
Brandon McPherson | 29389 since
5/25/2001 7:13:03 PM |
By 7 Users
3 Excellent Ratings
|
| |
In SQL 2000, most of the XML documentation involves using IIS to pass the data in, or Visual Basic. However, you can also simply pass the XML code itself as an ntext parameter, and just load it in as though it were a recordset. See the below example on th ...(description truncated) |
| |
| |
| |
|
XML Parsing Functions | SQL Server 7.0, Other | Beginner /
David Drake | 11567 since
6/4/2002 12:49:40 PM |
By 3 Users
2 Excellent Ratings
|
| |
This script will create two Functions in a SQL Server 2000 database which Parse XML stored in a database column. fnGetXMLText() will return the contents of an XML tag and fnGetXMLNode() will return the entire XML node. These functions will allow you to ea ...(description truncated) |
| |
| |
| |
|
XML Searching routine | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 12457 since
7/25/2000 8:44:58 PM |
By 1 Users
|
| |
Search for strings within XML tags |
| |
| |
| |
|
Xml2Sql | SQL Server 2000 | Advanced /
Keith Henry | 12834 since
7/15/2003 12:30:44 PM |
By 1 Users
|
| |
Converts an xml document to a sql where clause.
XML structured so that easy for front end to
manuipulate without needing to see data structure.
In front end filter can be built up from list of table.field names
|
| |
