奇迹世界了望塔,无忧创业网,zznba
创建动态sql存储过程的代码实例
use [databasename] go set ansi_nulls on go set quoted_identifier on go -- ============================================= -- author: -- create date: -- description: -- ============================================= create procedure procname @p1 int = null, @p2 nvarchar(12) = null, as set nocount on; declare @sql nvarchar(4000) set @sql = 'select row_number() over(order by fieldname) as row ,fieldname_1 ,... ,fieldname_n from tablename where fieldname = value' +case when @p1 is null then '' else ' and fieldname_1 = @p1' end +case when @p2 is null then '' else ' and fieldname_2 = @p2' end exec sp_executesql @sql, n'@p1 int = null, @p2 nvarchar(12) = null,',@p1,@p1 go
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论