带变量的sql语句怎么写?

[dropping]

DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT 
                       WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
                                         WHERE E.GUID='+@guid+' AND E.COMPANY_ID=A.AD_COM AND A.GUID='+@guid+')'')'

print @strsql
EXEC @strsql

执行结果为：
SELECT * FROM OPENQUERY(ODB,'SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID=1027897 AND E.COMPANY_ID=A.AD_COM AND A.GUID=1027897)')
伺服器: 訊息 203，層級 16，狀態 2，行 8
名稱 'SELECT * FROM OPENQUERY(ODB,'SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID=1027897 AND E.COMPANY_ID=A.AD_COM AND A.GUID=1027897)')' 不是有效的識別項。

上面的SQL该怎么写?
用在存储过程里的。

[子陌红尘]

EXEC @strsql

==>

EXEC(@strsql)

[-狙击手-]

DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT 
                       WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
                                         WHERE E.GUID='''+@guid+''' AND E.COMPANY_ID=A.AD_COM AND A.GUID='''+@guid+''')'')'

print @strsql
EXEC @strsql

[dobear_0922]

DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT 
                       WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
                                         WHERE E.GUID='+@guid+' AND E.COMPANY_ID=A.AD_COM AND A.GUID='+@guid+')'')'

print @strsql
EXEC(@strsql)

[-狙击手-]

DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT 
                       WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
                                         WHERE E.GUID='''+@guid+''' AND E.COMPANY_ID=A.AD_COM AND A.GUID='''+@guid+''')'')'

print @strsql
EXEC (@strsql)

[dobear_0922]

钻钻速度真快，，，

[大宇_]

EXEC(@strsql)