betway必威-betway必威官方网站
做最好的网站

Server编写存储过程小工具,依赖函数

主干提醒:SQL Server编写存款和储蓄进程小工具以下是四个存款和储蓄进度的源程序

USE [XXX] GO

SQL Server编写存款和储蓄进度小工具 以下是五个存款和储蓄过程的源程序 /*===========================================================

QUOTED_IDENTIFIER ON GO

语法: sp_GenInsert Table Name,Stored Procedure Name 以northwind 数据库为例 sp_GenInsert Employees, INS_Employees

ALTER PROCEDURE [dbo].[UspOutputData]

注解:假如您在Master系统数据库中开创该进度,那你就足以在您服务器上有着的数据库中央银行使该进程。

@tablename sysname

=============================================================*/

AS

CREATE procedure sp_GenInsert @TableName varchar(130), @ProcedureName varchar(130) as set nocount on

declare @column varchar(2000)

declare @maxcol int, @TableID int

declare @columndata varchar(2000)

set @TableID = object_id(@TableName)

declare @sql varchar(4000)

select @MaxCol = max(colorder) from syscolumns where id = @TableID

declare @xtype tinyint

select Create Procedure rtrim(@ProcedureName) as type,0 as colorder into #TempProc union select convert(char(35),@ syscolumns.name) rtrim(systypes.name) case when rtrim(systypes.name) in (binary,char,nchar,nvarchar,varbinary,varchar) then ( rtrim(convert(char(4),syscolumns.length)) ) when rtrim(systypes.name) not in (binary,char,nchar,nvarchar,varbinary,varchar) then end case when colorder @maxcol then , when colorder = @maxcol then end as type, colorder from syscolumns join systypes on syscolumns.xtype = systypes.xtype where id = @TableID and systypes.name sysname union select AS,@maxcol 1 as colorder union select INSERT INTO @TableName,@maxcol 2 as colorder union select (,@maxcol 3 as colorder union select syscolumns.name case when colorder @maxcol then , when colorder = @maxcol then end as type, colorder @maxcol 3 as colorder from syscolumns join systypes on syscolumns.xtype = systypes.xtype where id = @TableID and systypes.name sysname union select ),(2 * @maxcol) 4 as colorder union select VALUES,(2 * @maxcol) 5 as colorder union select (,(2 * @maxcol) 6 as colorder union select @ syscolumns.name case when colorder @maxcol then , when colorder = @maxcol then end as type, colorder (2 * @maxcol 6) as colorder from syscolumns join systypes on syscolumns.xtype = systypes.xtype where id = @TableID and systypes.name sysname union select ),(3 * @maxcol) 7 as colorder order by colorder

declare @name sysname

select type from #tempproc order by colorder

declare @objectId int

drop table #tempproc

declare @objectname sysname

declare @ident int

set nocount on set @objectId=object_id(@tablename)

if @objectId is null -- 判斷對象是还是不是留存

begin

print 'The object not exists'

return

end

set @objectname=rtrim(object_name(@objectId))

if @objectname is null or charindex(@objectname,@tablename卡塔尔国=0 --此推断不连贯

begin

print 'object not in current database'

return

end

if OBJECTPROPERTY(@objectId,'IsTable'卡塔尔国 < > 1 -- 判斷對象是不是是table

本文由betway必威发布于编程开发,转载请注明出处:Server编写存储过程小工具,依赖函数

TAG标签: betway必威
Ctrl+D 将本页面保存为书签,全面了解最新资讯,方便快捷。