开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜