-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: thajeer
Message 4 in Discussion



Try this,

        select
 'insert into TableName values (' + column1 + ',' +  column2
 + ')'  from TableName . 



Dirty .. but works !! 

Cheers ,



Thajeer Thundiyil

Tata Consultancy Services










"BDOTNET" <[EMAIL PROTECTED]>


05/10/2004 02:56 AM





Please respond to

"BDOTNET" <[EMAIL PROTECTED]>






To
"BDOTNET" <[EMAIL PROTECTED]>


cc



Subject
Re: SQL Script to Import
from Excel

















New Message on BDOTNET





SQL
Script to Import from Excel





Reply





 
Recommend


Message 3 in Discussion







From:
Ambrose




Hi Sampath,

Thanks for the link.

 Is it possible to create a "Insert statement"
from a table.

I have table with 100 records i want to write a script
which will give me the insert statement for all the 100 records in the
table.

 

thanks

Anandraj





View
other groups in this category. 






Also on MSN:

Start
Chatting |
Listen
to Music |
House
& Home |
Try
Online Dating |
Daily
Horoscopes 









To stop getting this e-mail, or change how often it arrives, go to your
E-mail
Settings. 



Need help? If you've forgotten your password, please go to Passport
Member Services. 

For other questions or feedback, go to our Contact
Us page. 



If you do not want to receive future e-mail from this MSN group, or if
you received this message by mistake, please click the "Remove"
link below. On the pre-addressed e-mail message that opens, simply click
"Send". Your e-mail address will be deleted from this group's
mailing list. 

Remove
my e-mail address from BDOTNET.




ForwardSourceID:NT00004EDA
   



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to