--表haha7到11中的数据
SELECT TOP 5 * FROM (SELECT TOP 11 * FROM haha)t ORDER BY id desc
//带有变量的存储过程
exec sp_executesql @Return,N'@Sum int output',@Sum output
/*
* 前台全站、站内信息搜索
*/
CREATE PROCEDURE Pro_SearchJewelry
@KeyWord nvarchar(50) = null,
@MN_ID nvarchar(50) = null
AS
declare @sql varchar(2000)
set @sql = 'select * from Jewelry_MenuContent where 1=1'
if @KeyWord <> ''
begin set @sql = @sql + ' AND (MC_Title like ''%'+@KeyWord+'%'' or MC_Content like ''%'+@KeyWord+'%'') ' end
if @MN_ID <> ''
begin set @sql = @sql + ' AND MN_ID='''+@MN_ID+'''' end
print(@sql)
exec (@sql)
RETURN
//output用法
alter procedure InsertData
@name nvarchar(20),
@name2 nvarchar(20),
@name3 nvarchar(30) output
as
insert into map values(@name,@name2)
本内容试读结束，登录后可阅读更多
下载后可阅读完整内容，剩余3页未读，立即下载
