SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-03-31 19:08:14

jvall
Member

Suggestion: Alternative "Script Execute" format as ASE isql on SPs.

I suggest an alternative way to generate the script to execute stored procedures like ASE isql tool (Dmitry Lukyanov) do and maybe with the value of the returned variable.


declare @param1 int
declare @param2 int
declare @param3 tinyint
declare @param4 varchar(15000)
declare @param5 varchar(1500)
declare @return   int

select @param1 = NULL
select @param2 = 123
select @param3 = NULL
select @param4 = 'Hello'
select @param5 = NULL

execute @return = sp_example @param1 , @param2 , @param3 , @param4 , @param5
select @return


Thank you.

Offline

#2 2016-04-01 15:14:25

sqldbxhelp
Administrator

Re: Suggestion: Alternative "Script Execute" format as ASE isql on SPs.

I do not see any value in doing scripting this way.
Why do you think it's better than what SqlDbx does currently?

Offline

#3 2016-04-01 15:23:38

jvall
Member

Re: Suggestion: Alternative "Script Execute" format as ASE isql on SPs.

I think is better to look at the name and type of parameters on the first sight. But using the tooltips the result is the same.

Offline

Board footer

Powered by FluxBB