 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
Get all table columns as SP parameters ? |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|