select语句中含有变量的问题

Question

declare @fathername varchar(200)
select @fathername='aaaaaa'
SELECT a.archive_id, a.ecode, a.ename, a.kh_bankid, @fathername+b.name
FROM Enterprise_info a, bank b
WHERE a.kh_bankid = b.bankid

Answer 1

SELECT a.archive_id
       ,a.ecode
       ,a.ename
       ,a.kh_bankid
       ,@fathername+b.name
FROM   Enterprise_info a
       ,bank b
WHERE  a.kh_bankid = b.bankid

Answer 2

declare @fathername varchar(20)
set @fathername='aa'
SELECT a.archive_id, a.ecode, a.ename, a.kh_bankid, fathername+b.name
FROM Enterprise_info a, bank b
WHERE a.kh_bankid = b.bankid

Answer 3

不好意思　忘　了加'@':
declare @fathername varchar(20)
set @fathername='aa'
SELECT a.archive_id, a.ecode, a.ename, a.kh_bankid, @fathername+b.name
FROM Enterprise_info a, bank b
WHERE a.kh_bankid = b.bankid

Answer 4

如果fathername 是字段名
declare @fathername varchar(100)
set @fathername = 'xxxx'exec('SELECT a.archive_id, a.ecode, a.ename, a.kh_bankid, '+@fathername+'+b.name
FROM Enterprise_info a, bank b
WHERE a.kh_bankid = b.bankid')
如果fathername 是字符串
declare @fathername varchar(100)
set @fathername = 'xxxx'SELECT a.archive_id, a.ecode, a.ename, a.kh_bankid, @fathername+b.name
FROM Enterprise_info a, bank b
WHERE a.kh_bankid = b.bankid

Answer 5

楼上的 wgsasd311大哥，你少了一个小老鼠：--〉fathername+b.name嗯，楼主也是