Read INI files from stored procedure

Ever wanted to look at some ini setting from a stored procedure? I tried several forums and found that none of them has a script to read ini files from stored procedures.So here is my script, works in SQL2000. For SQL7, replace table variables with temporary tables.

5 (1)

2003-06-17

1,239 reads

Blogs

Book Review: High Performance SQL Server (Second Edition)

By

One of the technical books that sit on my work desk (or dining table,...

The PowerShell Basics If Statement–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

T-SQL Tuesday Retrospective #013: What the business wants

By

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...

Read the latest Blogs

Forums

SQLCMD.exe get installed with SSMS?

By doughora

Is the  SQLCMD.exe  supposed to be installed when SSMS is installed on a workstation?...

Complex .Json Data Parsing with multiples Array elements into SQL (MS-SQL 2016)

By manihindus

DECLARE @JSON NVARCHAR(MAX) =N'{ "code": 200, "msg": "success", "data": [{ "ITEM": "SP", "FACTORY_NO": [{...

How to Display FeatureName of Comptitor First then Npx Feature Name second Based

By ahmed_elbarbary.2010

How to Display Feature Name of Comptitor First then NXP Feature Name second Based...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers