随笔分类 -  数据库

SqlServer查看锁
摘要：SELECT request_session_id sessionid,resource_type type,resource_database_id dbid,OBJECT_NAME(resource_associated_entity_id, resource_database_id) obje... 阅读全文
posted @ 2015-02-04 14:44 jesse_xie 阅读(237) 评论(0) 推荐(0)
查看加密的存储过程
摘要：GO/****** Object: StoredProcedure [dbo].[sp_decrypt_sp] Script Date: 11/19/2014 10:00:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--===... 阅读全文
posted @ 2014-11-19 10:03 jesse_xie 阅读(454) 评论(0) 推荐(0)
sql数据库表名做参数
摘要：declare @tablename nvarchar(50)declare @count intset @tablename = 'SplitzRank'declare @sqlstr nvarchar(512)set @sqlstr = 'select @count=count(*) from ... 阅读全文
posted @ 2014-08-13 14:30 jesse_xie 阅读(718) 评论(0) 推荐(0)