数据库
declare @Place nvarchardeclare @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
--------------------编程问答-------------------- 为什么老提示找不到存储过程
补充:.NET技术 , ASP.NET