Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
228 views
in Technique[技术] by (71.8m points)

sql server - How to show specific condition in column?

I have this very weird need, I have a query that contains some conditions. Here is a sample one.

SELECT FirstName, LastName, ConditionalColumn FROM Employee
WHERE LastName != 'Ciaz'

I want to show the WHERE conditional column value in ConditionalColumn. So that column will have Ciaz in it.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Declare @Param Varchar(MAX) = 'Ciaz'
SELECT FirstName, LastName, @Param AS ConditionalColumn FROM Employee
WHERE LastName != @Param

Line 1: Declare a Varchar (string) variable @Param and assign value of 'Ciaz'. Line 2: In Select query with FirstName, LastName add @Param with 'As' keywords and column name 'ConditionalColumn', with this @Param shown as a column in your query.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...