Hello i am try to use the following stored Procedure:
ALTER PROCEDURE DuplikateErmitteln
@Var1 int,
@Var2 int,
@Var3 int OUTPUT
AS
SELECT @Var3 = Matrikel
FROM UserMM
WHERE Matrikel = @Var2
IF @Var3 != @Var2
RETURN @Var3
ELSE
RETURN @Var2
RETURN
maybe it looks confusing...
Hello,
does anyone know whether there is a possiblity to insert a auto-value as a identifier?
E.g.: Whenever i insert a value, the ID is incremented?
Thanks Basti
Hello,
as you can see above i get this message when i want to start a stored procedure. i have grant the execute right to the stored procedure but i get then this error. below you can see the full error message:
ystem.Data.SqlClient.SqlException: Das erteilte oder aufgehobene EXECUTE-Privileg...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.