摘要：
CREATE TABLE #temp (TableName VARCHAR (255), RowCnt INT)EXEC sp_MSforeachtable 'INSERT INTO #temp SELECT ''?'', COUNT(*) FROM ?'SELECT TableName, RowC 阅读全文
摘要：
if exists (select * from sysobjects where type='P' and name=N'P_DeleteAllData' ) drop procedure P_DeleteAllDatagoCREATE PROCEDURE P_DeleteAllDataas EX 阅读全文