--引用http://www.microsoft.com/china/technet/columns/tipsfortechs/wsqs3.asp 综合实例 下面给出了一个存储过程,它的作用是自动将当前数据库的用户存储过程加密。DECLARE @sp_name nvarchar(400)DECLARE @sp_content nvarchar(2000)DECLARE @asbegin intdeclare @now datetimeselect @now = getdate()DECLARE sp_cursor CURSOR FOR SELECT object_name(id)FROM sysobjectsWHERE xtype = 'P' AND type = 'P' AND crdate < @nowAND OBJECTPROPERTY(id, 'IsMSShipped')=0OPEN sp_cursorFETCH NEXT FROM sp_cursor INTO @sp_nameWHILE @@FETCH_STATUS = 0BEGINSELECT @sp_conten...
查看详细内容 >>