I have a simple SQLCMD script that includes some lines like this: /* Load data into Exampletable */ BULK INSERT dbo.Example
Firstly, I\'m not a DBA and I don\'t have any (admin) experience with SQL Server, so please use words with few syllables when answering...
For some reason开发者_开发技巧 neither SQL managment studio nor import and export wizard works on my friends network due to some security policy
Executing the following script via sqlcmd fails. However, executing it via ssmo or SQL Server Management Studio works.
I\'m writing a program in c# to export SQL Server data from one database and importing it in another. Since these two servers are not connected I need to choose a method such as bcp.
When I try to run sqlcmd (from the cmd prompt) I get the开发者_开发技巧 following error: HResult 0x2, Level 16, State 1
I\'m trying to export data from SQL Server into CSV format. I have a bat task to do this that\'s run at regular intervals. Command is:
SQLCMD supports the -s parameter to specify the column separator, but I couldn\'t figure how how to represent the tab (CHAR(9)) character.I have tried the following but both don\'t work:
I am sure these has been asked before but cannot find clear instruction how to create a batch file lets call it \"Update Database\" this batch file should
I have a pretty simple question (and these are typically the ones I spend most of my time tearing my hair out about). I am using a batch file to execute all the .sql queries that are in the same direc