本文介绍了我使用哪种表单重命名列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好, 您将使用哪个代码示例来更改输出widnow中列的名称? 示例1
Hello, Which Code sample would you use to change the name of the column in the output widnow? Example 1
SELECT COUNT(*) AS 'myCount' FROM myTable或 示例2
or Example 2
SELECT myCount = COUNT(*) FROM myTable感谢您的回答:)
Thanks for your answer :)
推荐答案我将示例1视为更常用的形式。 I see Example 1 as the more often used form.
示例1是一个很好的做法。在示例2的情况下,Sql server将创建一个名为myCount的对象,您的值将分配给变量myCount并将显示。 Example 1 is a good practice. In case of Example 2 Sql server will create one object with name "myCount", your value will assign to variable "myCount" and it will be displayed.
更多推荐
我使用哪种表单重命名列
发布评论