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.
Showing posts with label implement. Show all posts
Showing posts with label implement. Show all posts
Subscribe to:
Posts (Atom)