A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Hi @Sudip Bhatt ,
Adding some notes to Olaf's answer:
What is first parameter called BULK ?
You use BULK INSERT or OPENROWSET(BULK...) to import data to SQL Server.
The OPENROWSET bulk rowset provider is accessed by calling the OPENROWSET function and specifying the BULK option.
You could consider BULK inside OPENROWSET is a fixed collocation.
Reference: OPENROWSET(BULK...) Function
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table