数据库
ljhjason
这个作者很懒,什么都没留下…
展开
-
外连数据库
<br />OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.1.100;Initial Catalog=database;Persist Security Info=True;User ID=name;pwd=password).database.[dbo].table原创 2011-03-17 03:32:00 · 504 阅读 · 0 评论 -
查询所有表大小
<br />create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20)) <br />exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'" <br />select * from #t <br />order by rows desc <b转载 2011-03-17 03:30:00 · 556 阅读 · 0 评论 -
生成ODBC和OLEDB 连接字符串
<br />生成ODBC和OLEDB 连接字符串 创建Link.udl文件,配置,复制连接原创 2011-03-14 14:46:00 · 755 阅读 · 0 评论 -
sql 查看最近修改的表或存储过程
<br />USE DataBase<br />select * from sys.all_objects where type IN('P','FN','TR','IF','TF') AND modify_date>='2009-2-18' order by modify_date desc原创 2011-03-17 03:29:00 · 1621 阅读 · 0 评论 -
sql 清存储过程注释
<br />DECLARE curSPName CURSOR FOR SELECT [name] FROM sysobjects WHERE xtype='P' <br />DECLARE @SPName nvarchar(200) <br />DECLARE @Table TABLE([Text] nvarchar(200)) <br />DECLARE @ErrTab TABLE(ERSP nvarchar(200), <br />ErrorNumber nvarchar(200), <br />Err原创 2011-03-17 03:34:00 · 958 阅读 · 0 评论 -
sql 查询存储过程内容
<br />select b.name from <br />dbo.syscomments a,dbo.sysobjects b <br />where a.id=b.id and b.xtype in ('p','tr','fn','tf','if') <br />and a.text like '%context%'原创 2011-03-17 03:33:00 · 955 阅读 · 0 评论 -
sql 递归查询结果集1 ~ 100
<br />with T as ( select a from (select 1 a) TT union all select a+1 from T where T.a<100 )select * from T原创 2011-03-17 03:27:00 · 1117 阅读 · 0 评论 -
sql随机列值 newid转float
<br />select RAND(CAST(CAST(NEWID()AS binary(10))AS int))原创 2011-03-17 03:24:00 · 999 阅读 · 0 评论