some data not inserted into table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

some data not inserted into table

I have a stored procedure which was running fine few minutes ago but <br />not its not inserting some data in the table.<br /><br />The procedure is inserting data into this table : <br /><br /><br />create table temp_XML <br />(xml_data varchar(8000)) <br /><br /><br />using cursors and row by row operation. The procedure takes about 3 <br />minutes to run and runs fine but just breaks up before its about to <br />end. The last data to be inserted in table is <br /><br /><br />select @feed7 = ‘&lt;/channel&gt;’ <br />select @feed8 = ‘&lt;/rss&gt;’ <br />insert into temp_XML(xml_data) values (@feed7) <br />insert into temp_XML(xml_data) values (@feed<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> <br /><br /><br />This is to close the XML. The proc still runs fine sometimes but breaks <br />most of the times. It was running fine before all the time. <br /><br /><br />I am inserting all the data into column xml_data varchar(8000) <br /><br /><br />I just ran a trace and found out that the crusor does reads the last 2 <br />lines and makes the inserts into the table then why is the data not acctually inserted into the table. The procedure runs fine on production database and returns more database. <br />But in the development data base there is this problem. Any hints on <br />what maybe going on. <br /><br /> <br />
Did you use any begin transaction and end transaction?
If so, maybe you havent do a commit transaction.
Check the Variable @feed7 and @feed8 Data Type with Data….If both are not compatible it won’t get inserted. Regards
Sivaraman Latchapathi