wrapper program
Database
4
Posts
4
Posters
0
Views
1
Watching
-
please let me know how to call a .sql file from one sql file.
-
please let me know how to call a .sql file from one sql file.
-
please let me know how to call a .sql file from one sql file.
Exec (@Filename)
"When did ignorance become a point of view" - Dilbert
-
please let me know how to call a .sql file from one sql file.
Not sure if this is possible as I haven't tried it but what I would try would be to do a bulk insert from your sql file into a single column temporary table. Then you could select this into a temporary varchar variable. You should then be able to use the EXEC() function to run the query in the varchar variable.