How to cast variables in T-SQL for bulk insert?

by

As I know only literal string is required in the from. In that case you have to write a dynamic query to use bulk insert

declare @q nvarchar(MAX);
set @q=
    'BULK INSERT [TStagingTable]
    FROM '+char(39)+@CSVfile+char(39)+'
    WITH
    (
    FIELDTERMINATOR = '','',
    ROWTERMINATOR = ''\n'',
    FIRSTROW = 1  
    )'
exec(@q)

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. How can I get column names from a table in SQL Server?
  3. How can I select the first day of a month in SQL?
  4. Multi-statement Table Valued Function vs Inline Table Valued Function
  5. Select statement to find duplicates on certain fields
  6. Using a Variable in OPENROWSET Query
  7. How to find current transaction level?
  8. Check for file exists or not in sql server?
  9. SQL Server 2008 – IF NOT EXISTS INSERT ELSE UPDATE
  10. Why is a UDF so much slower than a subquery?
  11. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  12. Query runs slow with date expression, but fast with string literal
  13. Alternate of lead lag function in SQL Server 2008
  14. UNIX_TIMESTAMP in SQL Server
  15. Generate all combinations in SQL
  16. Generate random int value from 3 to 6
  17. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
  18. Add emoji / emoticon to SQL Server table
  19. SQL Server SELECT INTO @variable?
  20. How do I change db schema to dbo
  21. How to subtract 30 days from the current date using SQL Server
  22. Count records for every month in a year
  23. How to export data from Excel spreadsheet to Sql Server 2008 table
  24. SQL Server: +(unary) operator on non-numeric Strings
  25. Use one CTE many times
  26. Bulk insert using stored procedure
  27. Connect different Windows User in SQL Server Management Studio (2005 or later)
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment