hi all
what is the syntax to use a UPDATE within a function ??
thanks
Printable View
hi all
what is the syntax to use a UPDATE within a function ??
thanks
UPDATE syntax is the same whether you're inside a function or not.
No , i think this is difference. bkz gives error.
No, the syntax is the same.
but the following code gives me some error
Code:
create function myfunc (@S# int , @Grade dec(5,2)) returns int as begin update std set garde=@grade where s# = @s# end
What about the semicolons?
in SQL semicolons is optional.