摘要:
CREATE PROCEDURE [dbo].[BatchDeleteTableField] @ColumnName VARCHAR(50)ASBEGIN DECLARE @sql VARCHAR(2000) DECLARE @Name VARCHAR(50) DECLARE bDTF CURSOR 阅读全文
摘要:
DECLARE deleteDBTableData CURSOR FOR (SELECT name FROM sysobjects WHERE xtype='U' AND (name LIKE 'XXXX%' OR name LIKE 'YYY%'))OPEN deleteDBTableDataDE 阅读全文
摘要:
USE [master]GO/****** Object: LinkedServer [SQL01] Script Date: 2020/4/9 11:51:17 ******/EXEC master.dbo.sp_addlinkedserver @server = N'SQL01', @srvpr 阅读全文
摘要:
SELECT B.NAME,A.ROW_COUNT FROM SYS.DM_DB_PARTITION_STATS A,SYS.OBJECTS BWHERE A.OBJECT_ID=B.OBJECT_ID AND A.INDEX_ID<=1AND B.TYPE='U'AND A.ROW_COUNT>8 阅读全文
摘要:
DECLARE @ESQL VARCHAR(1000);DECLARE FCursor CURSOR --定义游标FOR (SELECT 'ALTER TABLE '+O.name+' DROP CONSTRAINT '+F.name+';' AS CommandSQL from SYS.FOREI 阅读全文
摘要:
UPDATE 表 SET 栏位A = REPLACE(栏位A, CHAR(10), '') UPDATE表 SET 栏位A = REPLACE(栏位A, CHAR(13), '') 阅读全文
摘要:
DECLARE killspid CURSOR FOR (SELECT CONVERT(VARCHAR(100), request_session_id) FROM sys.dm_tran_locks WHERE resource_type='OBJECT' )OPEN killspidDECLAR 阅读全文
摘要:
BEGIN TRAN BEGIN TRY DELETE FROM dbo.表INSERT INTO dbo.表( Id, 字段....)SELECTId,字段... FROM dbo.表 COMMIT TRAN END TRY BEGIN CATCH ROLLBACK END CATCH 阅读全文
摘要:
你们想要的短信对接,要舍得点钱哦。。。。 /// <summary> /// http://sms.webchinese.cn/api.shtml /// </summary> public class SMSWebChineseApi { private string SMS_UID = stri 阅读全文
摘要:
不想说废话,直接源码拿去用。。。 /// <summary> /// 二维码管理 /// </summary> public class QRCoderHelper { /// <summary> /// 生成二维码图片 /// </summary> /// <param name="Content 阅读全文