在select语句中分配变量 [英] Assign Variable in select statement
本文介绍了在select语句中分配变量的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在sql server中使用select语句声明和赋值变量。写查询..
解决方案
看到这个:
DECLARE @ temp VARCHAR ( 30 )
SET @ temp = < span class =code-string>' 示例'
SELECT @ temp
或
DECLARE @ temp VARCHAR ( 30 )
SET @ temp = ' 示例'
SELECT *
FROM Table_Name
WHERE Table_Column = @ temp
或
DECLARE @temp VARCHAR ( 30 )
SELECT @ temp = name
FROM Table_Name
WHERE Id = 1
希望它有所帮助! :D
看到这个
DECLARE @ temp VARCHAR ( 30 )
SELECT @ Temp = Column_Name
FROM TABLE_1
WHERE ID = 1
How to declare and assign a variable using select statement in sql server. write query..
解决方案
Hi, see this:
DECLARE @temp VARCHAR(30) SET @temp = 'Example' SELECT @temp
OR
DECLARE @temp VARCHAR(30) SET @temp = 'Example' SELECT * FROM Table_Name WHERE Table_Column = @temp
OR
DECLARE @temp VARCHAR(30) SELECT @temp = name FROM Table_Name WHERE Id= 1
Hope it helps! :D
See this
DECLARE @temp VARCHAR(30) SELECT @Temp = Column_Name FROM TABLE_1 WHERE ID = 1
这篇关于在select语句中分配变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文