视图中的列别名 [英] Column aliases in view

问题描述

什么是SQL SERVER 2008中视图的列别名?(示例)

What is Column aliases for view in SQL SERVER 2008?(Example)

推荐答案

SELECT myColumn AS 'My Column Name to Display' FROM myTable

这将设置别名:该命令将名为myColumn的表列作为名为的列返回My Column Name to Display
后者将用作DataGridView或类似文件中的标题.

This sets up an alias: the table column called myColumn is returned by the command as a column called My Column Name to Display
The later will be used as the header in a DataGridView or similar for example.

这篇关于视图中的列别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！