今天群里的哥们问到这个问题，他是刚刚接触.NET的，但我感觉写SQL跟写程序是两回事吧？也许他是刚刚接触程序！呵呵

废话不多说了，直接看怎么解决问题吧！

创建存储过程就不多写了，直接写那条语句了：

ALTER PROCEDURE [dbo].[sp_PUB_GetAllPromotion]
@Dimission int = 0

AS
BEGIN
declare @sql varchar(8000)；--定义SQL语句变量

set @sql='select a.ID , a.Name , TeleNum , RetailerName , c.Name as City ,b.Name as Territory , a.SalesCity
from CRM_PUB_Promotor a INNER JOIN
MSS_PUB_SalesCity c ON a.SalesCity =c.ID INNER JOIN
dbo.MSS_Pub_SalesTerritory b ON c.SalesTerritory=b.ID
where a.Dimission = '+ CAST(@Dimission AS varchar(200)) --这里是转换类型

print @sql
exec (@sql)