General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Update does not work.
Hi,
I have a table with more than 600,000 rows of data. I want to transfer the data from the field Group_ to INS_GROUP1 within the same table, in such a way that at the end both the fields have exactly the same data. I wrote the following update query.
Update XXX Set INS_GROUP1 = Group_ where INS_GROUP1 is null
After executing for two minutes, I got the following error..
[Microsoft][ODBC SQL SERVER driver]TimeOut expired.
On pressing OK, it stops exectuting the query further. I have the Driver number 3.70.09.61. Any help is highly appreciated.
Thanks
Bharat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only