执行SQL语句，生成删除整个数据库表数据的delete语句

主要用于合并多个（少数据）统计表

获取SQL数据库信息

GO/****** Object: StoredProcedure [dbo].[UP_GetRecordByPage] Script Date: 2020-09-24 13:20:25 ******/DROP PROCEDURE [dbo].[UP_GetRecordByPage]GO/****** Object: StoredProcedure [dbo].[UP_GetRecordByPage] Script Date: 2020-09-24 13:20:25 ****...

转：https://blog.youkuaiyun.com/weixin_33845477/article/details/93364024select v.name ViewName,t.name TableName,vc.name ViewCol,tc.name TableColfrom sysdepends d, sysobjects v, syscolumns vc, sysobjects t, syscolumns tcwhere objectproperty(...

获取SQL数据库的表名，及第一列的注释作为表的说明，生成删除表数据的SQL语句select 'delete from ',Name2 ,'--',RANK()OVER (ORDER BY Name2 DESC) as 序号,字段说明 from(select bb.name as Name2,cc.* from (select min(minor_id) as minor_id,id...

--获取表的名称及用表中第一列的注释作表的说明select 'delete from ',Name2 ,'--',RANK()OVER (ORDER BY Name2 DESC) as 序号,字段说明 from(select bb.name as Name2,cc.* from (select min(minor_id) as minor_id,id from (SELECT ...