NewsBot
1
We're using MS Sql Server 2005.* Now im used to dealing with the excellent MySql.* With MySql i was able to save out a Sql query that represented my data within a table.* I want the same output from a couple of my Sql Server 2K5 tables.* Basically Im after the following output:
INSERT INTO MyTable (Field1, Field2) VALUES (data1, data2)
Where Field1/2 is an actual field name and data1/2 are actual data pulled from the dbase.* I can then take this sql output and run it on a different dbase to insert the data.
How do i save out the data in my sql server 2k5 table in this way?
Thanks.
More...
View All Our Microsft Related Feeds
INSERT INTO MyTable (Field1, Field2) VALUES (data1, data2)
Where Field1/2 is an actual field name and data1/2 are actual data pulled from the dbase.* I can then take this sql output and run it on a different dbase to insert the data.
How do i save out the data in my sql server 2k5 table in this way?
Thanks.
More...
View All Our Microsft Related Feeds