declare @Place nvarchar
declare @PlaceName nvarchar
declare @getScenery nvarchar
set @Place='BelongToArea'
set @PlaceName='华中'
if(@Place='BelongToArea')
set @getScenery='select * from Scenery where BelongToArea='''+@PlaceName
else
begin
if(@Place='BelongToProvince')
set @getScenery='select * from Scenery where BelongToProvince='''+@PlaceName
else
set @getScenery='select * from Scenery'
end
/* SET NOCOUNT ON */
exec (@getScenery)
RETURN
declare @PlaceName nvarchar
declare @getScenery nvarchar
set @Place='BelongToArea'
set @PlaceName='华中'
if(@Place='BelongToArea')
set @getScenery='select * from Scenery where BelongToArea='''+@PlaceName
else
begin
if(@Place='BelongToProvince')
set @getScenery='select * from Scenery where BelongToProvince='''+@PlaceName
else
set @getScenery='select * from Scenery'
end
/* SET NOCOUNT ON */
exec (@getScenery)
RETURN
declare @PlaceName nvarchar(100)
declare @getScenery nvarchar(1000)
set @Place=N'BelongToArea'
set @PlaceName=N'华中'
if(@Place=N'BelongToArea')
set @getScenery=N'select * from Scenery where BelongToArea='''+@PlaceName + ''''
else
begin
if(@Place=N'BelongToProvince')
set @getScenery=N'select * from Scenery where BelongToProvince='''+@PlaceName+''''
else
set @getScenery='select * from Scenery'
end
/* SET NOCOUNT ON */
exec (@getScenery)
RETURN
BelongToProvince='''+@PlaceName
这没对哟,后面还要跟上+''''