hi all
what is the syntax to use a UPDATE within a function ??
thanks
hi all
what is the syntax to use a UPDATE within a function ??
thanks
Life is about making the right decisions and moving on.
UPDATE syntax is the same whether you're inside a function or not.
No , i think this is difference. bkz gives error.
Life is about making the right decisions and moving on.
but the following code gives me some error
Qt Code:
create function myfunc (@S# int , @Grade dec(5,2)) returns int as begin update std set garde=@grade where s# = @s# endTo copy to clipboard, switch view to plain text mode
Life is about making the right decisions and moving on.
in SQL semicolons is optional.
Life is about making the right decisions and moving on.
Bookmarks