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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-07-08 : 12:41:11
|
| I'm duplicating some data with two tables - one is "users" and another is "administrators"Both have name, office, email contact information and I maintain separate code sets to query and administrate each with ASP/ADO.I'd like to delete the administrator table by adding a few bits of information in the users table identifying which users are administrators.Here's the question. I haven't used views in any of my work. Could I create a view called "admin" which could be treated like the old "admin" table so the ASP/ADO code won't need to change (at least immediately?)SamC |
|
|
dsdeming
479 Posts |
Posted - 2002-07-08 : 12:42:48
|
| As long as the WHERE clause in your view filtered the data appropriately and the data is formatted the same as the old table, yes. |
 |
|
|
|
|
|
Combining two tables