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 |
|
tmccar
Starting Member
27 Posts |
 Posted - 2012-07-04 : 04:16:08
|
| I have run the following command on a database of users, to change the domain part of their email address:update users;set email=replace (email, 'domaina.com' 'domainb.com')select * from users;and it runs fine, but it does not diaplay the records (i.e. does not run the last line - "select * from users")What am I missing? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-04 : 04:20:58
|
| Depends on your client. Could be running it but not presenting the result - or could not be running it - or displaying the result somewhere you don't expect (maybe hidden).==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tmccar
Starting Member
27 Posts |
Posted - 2012-07-04 : 04:49:10
|
| You're right, it was displaying the results in another tab, thanks. |
|
|
|
|
|
|
Records not displaying