Your starting point for database programming, including answers to frequently-asked technical questions about database development, Get Help with DB2 and SQL Server, feature articles, links to the best database development sites, and news about database tools and updates.
Transact-SQL stored procedures can use the cursor data type only for OUTPUT parameters. If the cursor data type is specified for a parameter, both the VARYING and OUTPUT parameters are required. If the VARYING keyword is specified for a parameter, the data type must be cursor and the OUTPUT keyword must be specified.