摘要:
CREATE PROCEDURE [dbo].[p_CreateDB] @Des_DB sysname, @ServerName sysname=N'', @UserName sysname=N'', @pwd sysname=N'', @fliename sysname AS SET NOCO... 阅读全文
摘要:
SQl修改数据库架构名declare @name sysname declare csr1 cursor for select TABLE_NAME from INFORMATION_SCHEMA.TABLES open csr1 FETCH NEXT FROM csr1 INTO ... 阅读全文
摘要:
SQL查询表占用空间大小.create table tmp (name varchar(50),rows int,reserved varchar(50),data varchar(50),index_size varchar(50),unused varchar(50))insert into t... 阅读全文
摘要:
1、查询造成死锁的SQL语句当SQL数据库的监控报警显示死锁进程数过多时,首先应该找出造成死锁的SQL语句是什么,打开“查询分析器”,将如下的存储过程输入到文本框中,检查语法,然后运行:use mastergoCREATE PROCEDURE sp_who_lock ASbegindeclare @... 阅读全文
摘要:
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.IO;using System.Data;using System.Data.OleDb;namespace ... 阅读全文
![](/skins/gray/images/separator.gif)