How to Find Current Directory of itself with a TSQL Script File In SQL Server

Question

I Think That My Question Is Simple. How Can I Find That My Query Is Running From Where ( Where is The Location of the Script File itself ) ?

Edit :

Thank You For Your Answer. I Need To Import a XML File Using my TSQL Script File And i want to Keep Them Together, so Wherever Someone try to run the TSQL script file, it must knows the current directory of itself to know where is the XML file and then import it. Thank Again !

It's not simple. All SQL Server knows is that it's been handed a batch of text to compile and execute. That text may have been dynamically generated by some code, or may be in an unsaved query window in SSMS, or ... (you hopefully get the idea) — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Oct 3, 2012 at 6:34
This also sounds like a small part of a larger (broken) solution - perhaps if you present the overall problem that you're trying to solve, we could produce a solution that doesn't require this information. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Oct 3, 2012 at 6:38
thank for your answer, but this is weird !, why just this sample thing must be so difficult ? , — Farzad Karimi
– Farzad Karimi, Commented Oct 3, 2012 at 7:01
How do you expect import with TSQL, if your "script" and xml reside on client PC, but server is located on the other side of world? TSQL can't access your local PC anyway. — Arvo
– Arvo, Commented Oct 3, 2012 at 7:06

Damien_The_Unbeliever · Accepted Answer · 2012-10-03 07:11:40Z

1

You need a well known location where you can place XML files for the server to load. This could be a share on the SQL Server machine, or on a file server which the SQL Server service account has permissions to read from.

You then need a comment like this at the top of your script:

--Make sure you've placed the accompanying XML file on \\RemoteMachine\UploadShare
--Otherwise, expect this script to produce errors

Change \\RemoteMachine\UploadShare to match the well known location you've selected. Optionally, have the comment followed by 30-40 blank lines (or more comments), so that it's obvious to anyone running it that they might need to read what's there.

Then, write the rest of your script based on that presumption.

answered Oct 3, 2012 at 7:11

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Farzad Karimi · Accepted Answer · 2012-10-06 13:06:23Z

1

I Found A Solution to my problem that's simpler ! You Know I Just Import My XML File To A Temp Table for once. Then I Write a Select Query for That Temp Table That Contains my imported Data Like This :

" SELECT 'INSERT INTO MyTable VALUES (' + Col1 + ', ' + Col2 + ')' FROM MyImportedTable "

And Now I Have Many Insert Commands For Each One Of My Imported Records. And I Save All of the Insert Commands in My Script. And So I Just Need My Script File Everywhere I Go.

answered Oct 6, 2012 at 13:06

Farzad Karimi

7801 gold badge13 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to Find Current Directory of itself with a TSQL Script File In SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related