开发者

How to make a view in SQL Server? [closed]

开发者 https://www.devze.com 2023-02-24 12:16 出处:网络
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I have more tables and I want to merge that some table for getting result.....

How can I 开发者_StackOverflowdo?


Views is just some sort of "stored query". It can be defined as:

CREATE VIEW viewname AS SELECT <the rest of select query here>

More details at msdn:

  • http://msdn.microsoft.com/en-us/library/ms187956.aspx
  • http://msdn.microsoft.com/en-us/library/aa214068(SQL.80).aspx


CEATE VIEW.

The rest of teh syntax is in ..... the documentation.

And this question is neither related to C# nor C++. It also does not care what you ate for breakfast. SQL works with strings the server interprets, and the langauge has no matter how the server does that.

0

精彩评论

暂无评论...
验证码 换一张
取 消