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 |
|
heovang1211
Starting Member
5 Posts |
 Posted - 2009-11-17 : 21:56:53
|
| Now, I have 1 stored procedure 'UpdateCustomer':.....process something ....begin tran updatetableinsert tblUser values('Tommy', 1)commit tran updatetable....print 'inserted successfully'continue processing something .........Next, I run this stored and after it finish command above (this stored is still running), I want to query data at tblUser to get User 'Tommy' with query string : "Select * from tblUser". But SQL always query and doesn't return the result. I just have the result after the stored 'UpdateCustomer' runs complete.So, the question is how can I get data at table tblUser immediately while the store 'UpdateCustomer' is running.Thank you for your help. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 22:18:48
|
| why are u using explicit transaction for something like this? |
 |
|
|
heovang1211
Starting Member
5 Posts |
Posted - 2009-11-17 : 22:29:32
|
| I use transaction to want that data really will be inserted into tblUser to I can query them while this stored is still running. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heovang1211
Starting Member
5 Posts |
Posted - 2009-11-18 : 03:08:27
|
| so, how can I get data at table tblUser immediately while the store 'UpdateCustomer' is running? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heovang1211
Starting Member
5 Posts |
Posted - 2009-11-18 : 20:57:46
|
| ??? I don't understand what you said, please explain, thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How can I get data at a table