DaniWeb Forum Index > Software Development > C#

C# RSS

How can I generate sql script with data in sql server 2000?

Please support our C# advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2009

Posts: 9

Reputation: jineesh is an unknown quantity at this point

Solved Threads: 0

jineesh

Offline

Newbie Poster

How can I generate sql script with data in sql server 2000?

Jun 8th, 2009

Please any one help me...
I want to insert data automatically to the table while installing an application. how can i do this? Can I generate sql script for this???

Regards
Jineesh

•

Join Date: Dec 2007

Posts: 97

Reputation: VIeditorlover is an unknown quantity at this point

Solved Threads: 5

VIeditorlover VIeditorlover is offline

Offline

Junior Poster in Training

Re: How can I generate sql script with data in sql server 2000?

Jun 8th, 2009

•

Originally Posted by jineesh

Please any one help me...
I want to insert data automatically to the table while installing an application. how can i do this? Can I generate sql script for this???

Regards
Jineesh

It depends on how big is the data you are dealing with. For example few lines can be inserted handy written script.

Few hundred lines can be inserted from script-generated sql script like:

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
declare @crlf varchar(2)
set @crlf = char(13)+char(10)
select 'insert into tab1 (a,b,c) values (''' +a+''','''+b+''','''+c''');'+crlf;
from tab1
where /* add filter here*/
declare @crlf varchar(2)
set @crlf = char(13)+char(10)
select 'insert into tab1 (a,b,c) values (''' +a+''','''+b+''','''+c''');'+crlf;
from tab1
where /* add filter here*/

for 1000+ you can store data into Excel table and import it very simple way (see http://horizon.leadhoster.com/?content=tipstricks topic Fast and simple import data from Excel table into SQL server ) or XML and process data on the server within stored procedure or with XQuery http://blogs.msdn.com/mrorke/ see Dynamic XQuery Expressions.

Finally for 100000+ I would reccommend you distribute whole database file (mdf+ldf) and during installation just unpack it and attach (works perfectly!).