开发者

Include in SELECT a column that isn't actually in the database

开发者 https://www.devze.com 2022-12-24 03:00 出处:网络
I\'m trying to execute a SELECT statement that includes a column of a static string value.I\'ve done this in Access, but never with raw SQL.Is this possible?

I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible?

Example:

 Name  | Status
 ------+--------
 John  | Unpaid
 Terry | Unpaid
 Joe   | Unpaid

In th开发者_运维知识库e above example, the "Status" column doesn't exist in the database.


You may want to use:

SELECT Name, 'Unpaid' AS Status FROM table;

The SELECT clause syntax, as defined in MSDN: SELECT Clause (Transact-SQL), is as follows:

SELECT [ ALL | DISTINCT ]
[ TOP ( expression ) [ PERCENT ] [ WITH TIES ] ] 
<select_list> 

Where the expression can be a constant, function, any combination of column names, constants, and functions connected by an operator or operators, or a subquery.

0

精彩评论

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

关注公众号