I wish to create a scenario whereby my Stored Procedure will be able to do an Insert values into two colunms but single row of a table.
INSERT INTO Table1 (Message1, Number1) VALUES(@Message1, @Number1)
When I do the above stored procedure using SQL Express, and Excecute the stored procedure in VS2005 C# using ADO.Net, the table is updated but the values of Message1 and Number1 are inserted into different rows i.e. when value is inserted into Message1,
Number1 is '0' and vice-versa.
what I really want is for both Message1 and Number1 to be inserted with values at the same row. How do I acheive this please?
Many thanks in advance.
View Complete Post