Long time reader, first time poster. I'm currently building a web application in ASP.NET and as a small part of it, I need to insert a record into a MS SQL2008 database and return a value from it. I'm doing this via a stored procedure using the
SqlCommand class from my C# file, but it's not giving me consistent results. For now, I'm merely focusing on getting the record inserted correctly.
My basic stored procedure looks like this:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[uspInsertDemoInfo]
View Complete Post