Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why does this error occur?
Hello RickCole, I follow your instruction and I also get an error. The error is: "Must declare the variable @nCount". I rewrite this code as: CREATE PROCEDURE L_sp_UniqueUserID @szTableName varchar(20), @szUID varchar(20) output AS declare @nCount smallint declare @nLen smallint...- blongtq
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Why does this error occur?
Hello all, I have the stored procedure: CREATE PROCEDURE UniqueID @szTableName varchar(20), @szPrefix varchar(10), @szKeyword varchar(20), @szUID varchar(20) output AS declare @nCount smallint declare @nLen smallint declare @szTmp varchar(20) select @nCount = count(*) from...- blongtq
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
