Is it possible to execute a text file from SQL query?

by

use xp_cmdshell and sqlcmd

EXEC xp_cmdshell  'sqlcmd -S ' + @DBServerName + ' -d  ' + @DBName + ' -i ' + @FilePathName

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Select top 10 records for each category
  3. How important is the order of columns in indexes?
  4. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  5. sql query to return differences between two tables
  6. SQL Server – transactions roll back on error?
  7. Difference between a User and a Login in SQL Server
  8. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  9. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  10. Is it possible to select sql server data using column ordinal position
  11. Insert Picture into SQL Server 2005 Image Field using only SQL
  12. Execute Stored Procedure from a Function
  13. How do I group on continuous ranges
  14. Dynamic SQL to generate column names?
  15. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  16. Restrict an SQL Server connection to a specific IP address
  17. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  18. SQL Server PIVOT perhaps?
  19. How to find consecutive rows based on the value of a column?
  20. SQL server identity column values start at 0 instead of 1
  21. How to escape square brackets inside square brackets for field name
  22. How do you copy a record in a SQL table but swap out the unique id of the new row?
  23. What is the internal representation of datetime in sql server?
  24. Eliminate and reduce overlapping date ranges
  25. Cumulative Total in MS Sql server [duplicate]
  26. SQL query to group by day
  27. Export table data from one SQL Server to another
  28. SQL can I have a “conditionally unique” constraint on a table?
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. SQL, How to Concatenate results?

Leave a Comment