var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedures
I am new to Stored procedures and need help.
I have to read data in a table, modify each row then write it to another table.
Can you please help me with the syntax. What I have is like this.
Create proc updaterows
(@name varchar (10),
@lname varchar (20),
@address varchar (20))
select * from table1
where fname = @name
lastname = @lname
address = @address
If you know something called curson then you can very well use this to solve ur purpose.
How about a little more info. What exactly are you updating? What is the criteria?