http://code.google.com/p/sqlexpressprofiler/downloads/detail?name=SqlExpressProfiler-1.2.1708.7.zip
...
http://code.google.com/p/sqlexpressprofiler/downloads/detail?name=SqlExpressProfiler-1.2.1708.7.zip
...
----查询数据库中用户创建的表----jsj01 为数据库名select name tablename from jsj01..sysobjects where type='U' and name not in ('dtproperties')--查询表里的字段信息 ---docs为表名---- select * from syscolumns where id = object_id('doc
CREATE PROCEDURE [SpPageOrder]
@tblName varchar(255),
@fldName varchar(255),
@OrderfldName varchar(255), -- 排序字段名
@PageSize int = 10,
...