Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chinlax
Starting Member
30 Posts |
 Posted - 2011-10-14 : 01:59:58
|
| Hi all, I have to create sp for the following1) Create one Simple procedure for DML Process (Insert,Update,Delete) I/P : RecordSet VARCHAR(8000) Table : ID (Identity), Code VARCHAR(4), CodeDescription VARCHAR(100), RecStatus BIT Note : For Insert :'0,1,Code1±' For Update :'2,1,Code2±' For Delete :Other than Insert and Update Records Eg: @RecSet = '0,1,Code1±0,2,Code2±0,3,Code3±4,4,Code4test±' in table : code 1,2,3 are New Records code 4 is Update Other records has to delete from tables.how to do this.......can any one help me out plssssssss |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 02:28:56
|
| Sorry that doesnt make sense. You dont have recordset type in sql. Either you need to send individual values to sql or use xml or table type formats for that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
Stored procedure-DML operations