3
votes
3answers
9k views

MS SQL Server 2008: How to export all the tables into CSV?

I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables. For that I need to get the data from dozens of tables as unicode CSV or TXT ...
1
vote
2answers
5k views

export proper csv from SqlServer management studio query result

in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
0
votes
1answer
913 views

SQL Passing a List<int> as a SqlCommand Parameter

can i pass a List into a SqlCommand as a paramter? DELETE FROM MyTable WHERE Key IN @MyParam command.Parameters.AddValue("MyParam",MyList); i realize i could just loop over the list but i was ...
1
vote
3answers
733 views

SELECT from inline CSV values in MS SQL

I occasionally get one-off requests to modify some data, and the request comes with some values in CSV. Is there a way I can treat arbitrary CSV as a table or row source quickly and easily, even as ...