Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi,
I have the following stored procedure:
CREATE PROCEDURE ACC_usp_Next_Number @cTableName char(40),@cField AS CHAR(40),@iNext int OUTPUT AS
DECLARE @cSQLString VARCHAR(256)
SET @cSQLString = 'SELECT @iNext = MAX('+@cField+') FROM '+RTRIM(@cTableName)
EXEC(@cSQLString)
RETURN @iNext
GO
I get the error "Must declare the variable '@iTest'.". Basically I would like to get the next number of the table and field that I pass. Why is it telling me to declare @iTest if I'm passing it? Does anyone know of a better way to accomplish this?
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement