SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Get all table columns as SP parameters ?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Get all table columns as SP parameters ?
Author Message
rnan



Joined: 12 Jul 2012
Posts: 56
Country: Faroe Islands

Post Get all table columns as SP parameters ? Reply with quote
Hello

Is there any option ( in the latest ver ) to create insert /update SP for a table ?

for example :

If I have customerTable
which has :

id , name , year

so Im asking if there's something which generates ( insert/update) sp: like :

update customerTable
(
@id int,
@name nvarchar(..),
@year int...)
as
begin
.....
end
Tue Mar 05, 2013 8:55 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7852

Post Reply with quote
It sounds like you want the Bulk Code Generator feature. Please check it out. It provides built-in sample templates for generating CRUD stored procedures for tables. If that is not exactly what you want, you can develop your own templates and use them to generate stored procedures in bulk.
Tue Mar 05, 2013 9:01 am View user's profile Send private message
rnan



Joined: 12 Jul 2012
Posts: 56
Country: Faroe Islands

Post Reply with quote
Hi Thanks for reply

6.2.107 enterprise
I dont have that kind of feature.
I guess there is a new version..

is there any alternative in 6.2.107 ?
or can I upgrade to the latest with the same licence?
Tue Mar 05, 2013 9:04 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7852

Post Reply with quote
Yes, it's in 6.3, one of the new features. If your license includes support and maintenance option, then yes you can install the upgrade and it's free for you.
Tue Mar 05, 2013 10:14 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.