set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[personal2_list_where]AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 ;
END
GO
这个想带查询参数,怎么改?
比如 name ='张三'
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[personal2_list_where]AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 ;
END
GO
这个想带查询参数,怎么改?
比如 name ='张三'
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[personal2_list_where]
(
@name NVARCHAR(10)
)
AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 where name = @name ; -- (或者用like)
END
GO
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[personal2_list_where]
@wheresql varchar(50)
AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 where name=@wheresql;
END
GO
@para1 VARCHAR(100),
@para2 INT
AS
BEGIN SET NOCOUNT ON select top 100 * from personal2 WHERE field = @para1
END
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[personal2_list_where] @name varchar(20)
AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 where name = @name;
END
GOexec [dbo].[personal2_list_where] '张三'
ALTER PROCEDURE [dbo].[personal2_list_where]
@name varchar(20) = null
AS
BEGIN SET NOCOUNT ON; select top 100 * from personal2 where name = isnull(@name,name);
END
GOexec [dbo].[personal2_list_where] '张三'