Ok, Here is the problem. I need to implement view to enforce a rule I have. I have the following SQL statement:
CREATE VIEW v_new_cable
AS SELECT Make_ID, Model_ID, PurchaseDate, Equipment_ID, Description, Vendor_ID, Image_ID
FROM Inventory$
WHERE Equipment_ID = '3' -- The number 3 represents a cable.
Anyway I check the syntax and that checks out ok. Then I get an Alert Message saying that:
The Query Designer does not suppor the CREATE VIEW SQL Contruct.
What does that mean and how do I fix this?
Thanks!What are you using to write the query, i.e. what editor?|||I am creating a new view. (right click new view)
I am then typing in the following into the middle white box.
(I'm a new to SQL Server)|||Dont know the answer to that one..try posting a question on this forum....:
http://www.sqlservercentral.com/forum/forum.asp?FORUM_ID=9&CAT_ID=1&Forum_Title=General|||when you use enterprise manager to create a view:
- to enter the select statement in the middle box
- click the save button in the left top
- enter the new for the view and press ok
If you want to type your complete statement yourself, you can use the Query Analyzer.
No comments:
Post a Comment