Tuesday, March 20, 2012

Cannot Create new View!

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