摘要:
with TableRecord(TableName,RecordCount) as( select o.name,i.rows from sysobjects o,sysindexes i where o.id=i.id and o.Xtype='U' and i.indid<2 ) select * from TableRecord order by tablename 阅读全文
摘要:
ALTER FUNCTION [dbo].[fun_splitIds]( @str varchar ( max ) , @split varchar ( 10 ) ) /*2010-8-23 : by jrt调用示例: SELECT * FROM [fun_splitIds]('ab##呵呵##234##课课练考虑','##')*/RETURNS @t TABLE ( v varchar(max) ) AS BEGIN DECLARE @XmlIDs XML SET @xmlIDs = '<IDs> <ID>' + REP 阅读全文