How to get the path of a directory of a script using sql query?. The SQL query is run by same script

Question

I have a SQL query which is running by script while I am publishing the code in .net,

My problem is that, I need a SQL query to find the directory of same script.

Please help me to do so.

There is not enough information for anyone to be able to help you. What RDBMS are we talking about? What kind of script are you executing, and how? — ninesided
– ninesided, Commented Feb 29, 2016 at 8:39
@ninesided I am using MS SQL server as RDBMS. SQL file is running while I am publishing an XML script in the .NetFramework. IS it enough? — chaaru
– chaaru, Commented Feb 29, 2016 at 8:47

ninesided · Accepted Answer · 2016-02-29 08:58:08Z

2

I don't think that the SQL Server client cares where the script is being executed from. Your best bet would be to figure out what the path of the script is before you execute it and pass it in as a parameter, or embed it in the script itself.

answered Feb 29, 2016 at 8:58

ninesided

23.3k17 gold badges88 silver badges109 bronze badges

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

Collectives™ on Stack Overflow

How to get the path of a directory of a script using sql query?. The SQL query is run by same script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related