如何在SQL中生成新表 [英] How to generate a new table in SQL

问题描述

我需要创建一个显示客户名称，订单号和订单日期的视图vCustomerOrders。

I need to create a view vCustomerOrders that displays the customer's name, order number, and order date.

什么是最好的路线？

推荐答案

您正在询问有关sql server的许多基本问题。像这样的论坛不是学习如何编写tsql代码或如何设计数据库的好方法。令人担忧的是，您的组织已经为您提供了无法完成
技能的任务 - 但这是您的关注。 

You are asking many basic questions about sql server. A forum such as this is not a good way to learn how to write tsql code or how to design databases. It is concerning that your organization has given you tasks that you do not have the skills to accomplish - but that is your concern. 

至少，答案是您的问题需要了解数据库架构。如果您无法提供，那么您应该从组织内部获得帮助。熟悉您的系统的人将能够更好地提供指导。创建视图的
最佳路径是写一个
创建视图语句。文档中有一些示例 - 应该让您入门。  

At the very least, answers for your question require knowledge of the database schema. If you cannot supply that, then you should get help from within your organization. People already familiar with your systems will be better able to provide guidance. The best route to create a view is to write a create view statement. The documentation has examples - that should get you started.  

这篇关于如何在SQL中生成新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！