0

when I see the code in the view designer it's different from the code showed when I script the view using "ALTER TO" new query editor. Just an example

In design mode:

SELECT * FROM products prd;

In new query editor:

SELECT * FROM products prd
INNER JOIN providers po ON prd_id=po.id

This seems too odd but its what I'm seeing (I thought that need new reading glasses).

Please someone has saw this?

Improve this question
7
  • 2
    "Please someone has saw this?" I have never seen this, no, but also, I don't go anywhere near the buggy, feature lacking, quirky designer because it's buggy, feature lacking and quirky. I, personally, suggest you do the same and forget the designer ever existed. Commented Feb 27, 2023 at 14:38
  • Thx for your blazing fast answer @Larnu but thing is which one SS uses? because sometimes I've detected the results of the view are from the designer query and sometimes uses the scripted code. So, should I replace the designer code with the scripted code? Commented Feb 27, 2023 at 14:46
  • What is an "SS"? Commented Feb 27, 2023 at 14:47
  • SS=SQL Server, sorry Commented Feb 27, 2023 at 14:48
  • As I mentioned, the designer is buggy, feature lacking and quirky; I wouldn't trust it with anything. Commented Feb 27, 2023 at 14:48
Related questions
4347
UPDATE from a SELECT
3327
How to add a column with a default value to an existing table in SQL Server?
2114
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.