Include @rate as an output parameter in the procedure and the code should be fine
More Related Contents:
- How to pass an array into a SQL Server stored procedure
- Call a stored procedure with parameter in c#
- Getting data from stored procedure with Entity Framework
- Passing List to SQL Stored Procedure
- What is passing parameters to SQL and why do I need it?
- How do I update a value in C# and SQL Server? [closed]
- How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
- How to pass table value parameters to stored procedure from .net code
- What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
- Insert 2 million rows into SQL Server quickly
- Calling stored procedure with return value
- SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Cannot create an automatic instance
- Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
- Avoiding SQL injection without parameters
- Why should I use int instead of a byte or short in C#
- Using DateTime in a SqlParameter for Stored Procedure, format error
- Connection timeout for SQL server
- WHERE IN (array of IDs)
- SQL: Update a row and returning a column value with 1 query
- Generate class from database table
- Stored procedure return into DataSet in C# .Net
- Retrieve image from database in asp.net
- How to pass a null variable to a SQL Stored Procedure from C#.net code
- Fastest method for SQL Server inserts, updates, selects
- How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?
- How to retrieve binary image from database using C# in ASP.NET
- Database Error: There is no row at position 0
- Passing array to a SQL Server Stored Procedure
- Generating sql code programmatically
- What does a timestamp in T-Sql mean in C#?