- 博客(2)
- 收藏
- 关注
原创 查看表的行数
查看一个表的行数: sp_spaceused InstitutionClinicaltrials 查看一个数据库中所有表的行数: SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id WHERE (a.type = 'u') AND (b.indid IN (0, 1))
2013-11-19 10:09:57 716
转载 存储过程拆分Patents表Inventor字段逗号分隔字符串
USE [METRIX] GO /****** Object: StoredProcedure [dbo].[SplitString] Script Date: 11/12/2013 12:07:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDUR
2013-11-12 12:08:21 510
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人