test.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 24 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Test]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO


CREATE procedure Test
 @Js_UserID nvarchar(1024),
 @Js_UserName nvarchar(1024)
as
 select * from js_user where (js_userid like @Js_UserID) and (Js_UserName like @Js_UserName) 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


--exec Test '%','冯孝刚'