Insert Statements

Question

Post reply

Insert Statements

MissPukeyCow

Ten Centuries

Points: 1146
More actions
July 25, 2006 at 10:12 am

#118798

Hi my Super Smart Peeps!
How would i create insert statements for all the data/values in a table?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 1

Use star sign

select *

or

insert into sometable

select *

N 56°04'39.16"
E 12°55'05.25"

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 2

It may not be the best method, and probably isn't, but it has worked for me in the past - I'm sure there is a better way - this does exactly that for titleauthor in pubs - just run it and paste the output in a new window and remove the last union select statement.

SET NOCOUNT ON

SELECT 'INSERT INTO titleauthor(au_id,title_id,au_ord,royaltyper)'

PRINT 'SELECT'

SELECT '''' + au_id + ''',''' + title_id + ''',''' + cast(au_ord AS varchar(50)) + ''',''' + cast(royaltyper AS varchar(50)) + '''UNION SELECT ' FROM titleauthor