Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 I like 'insert to', but why not go all the way!

Author  Topic 

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 2007-05-09 : 11:13:41
I like the new 'script table as -> insert to' feature in sql server 2005 that allows you to quickly generate the insert statement template.

Why couldn't they give us a feature to automagically FILL in the values of the query with dummy data? (data that represents the correct data type for the column ofcourse).

Am I missing something here or what? hehe

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2007-05-09 : 12:14:09
I know what you mean. One thing that might be helpful when playing around can be found on the menu: Query -> Specify Values For Template Paramaters...

That will give yo a dialoge to type in and it will replace the templatized parameters from the Script Table As -> Insert To script.

Cheers

-Ryan
Go to Top of Page
   

- Advertisement -