January 14, 2010 at 7:15 pm
I'm using SQLServer 2005 and would like to be able to edit data in a view with 2 tables, is this possible? I've read the restrictions for doing this i.e. no group fields, no join fields etc. and it looks like you can edit, but I can't using the simplest tables.
Bruce
January 14, 2010 at 7:50 pm
Bruce-12445 (1/14/2010)
I'm using SQLServer 2005 and would like to be able to edit data in a view with 2 tables, is this possible? I've read the restrictions for doing this i.e. no group fields, no join fields etc. and it looks like you can edit, but I can't using the simplest tables.Bruce
Here is some reading material.
http://msdn.microsoft.com/en-us/library/ms180800(SQL.90).aspx
Question: How are you trying to modify the data within the view?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 14, 2010 at 9:10 pm
Hi Jason thanks for that.
I originally tried editing in SQLServer Management Studio (SMS) and a dodgy application, which didn't allow editing and created the post. That was misleading. I've since accessed the View from an editing application and I can edit from there. It seems SMS wont allow editing, unless I'm missing a setting somewhere.
So question answered. Thanks,
Bruce
January 14, 2010 at 10:18 pm
If you open a view in SSMS, no you cannot update from there. You would need to use insert and update statements.
What is that third party tool that allows you to edit it through a GUI?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply