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 |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2006-11-16 : 15:03:52
|
| there is a table - TableA in my DBwhich iam using in a stored procedure now the table is normalised and the same date is spread in 6 diff tables.my admin is creating a View which is just like TableA.my question is do i have to change anything in my stored procedure as TableA is a view and not a table anymore. |
|
|
samuelclay
Yak Posting Veteran
71 Posts |
Posted - 2006-11-16 : 15:12:27
|
| If the view has the same name as the original table name (and the same fields), then your code should still work. original table : TableAnew tables : TableA1, TableA2....new view : TableA (Joins TableA1, TableA2....) |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-16 : 22:00:29
|
You may have problems if the sproc was inserting/updating/deleting from TableA. if it was only selecting, you are ok.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
|
|
|
Table/view