https://blog.youkuaiyun.com/feegle_developzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/feegle_develop/article/details/6450512https://blog.youkuaiyun.com/feegle_develop/article/details/6450512feegle_developFri, 27 May 2011 16:45:00 +0800
MSSQL2008数据库邮件通知配置
配置数据库邮件
1.     连接到MSSQL2008 数据库服务器，右键数据库实例，单击“方面”，然后在“方面”选项卡中选择“外配配置管理器”，修改SqlMailEnabled 属性为True ，便可启用数据库邮件；

2.     展开“管理”，右键“数据库邮件”，选择“配置数据库邮件”；
 
3.     出现欢迎页面后下一步，选择“通过执行以下任务来安装数]]>https://blog.youkuaiyun.com/feegle_develop/article/details/6450506https://blog.youkuaiyun.com/feegle_develop/article/details/6450506feegle_developFri, 27 May 2011 16:44:00 +0800/********************SqlCMD命令********************/
一、直接输入,执行批处理命令
1.开启sqlcmd,并链接到服务器
  开始=>运行=>键入cmd=>键入sqlcmd -S 实例名 -U 用户名 -P 密码
2.指定数据库
  use 数据库名
  go
3.编写SQL语句
4.键入go,执行批处理命令
二、执行文件中]]>https://blog.youkuaiyun.com/feegle_develop/article/details/6450505https://blog.youkuaiyun.com/feegle_develop/article/details/6450505feegle_developFri, 27 May 2011 16:43:00 +0800create procedure sp_kill(@tbname varchar(100),@dbname varchar(100))
as
begin
    declare @spid int
   
    if OBJECT_ID('tempdb.dbo.#Kill') is not null
      drop table #Kill

    create table #K]]>https://blog.youkuaiyun.com/feegle_develop/article/details/6450502https://blog.youkuaiyun.com/feegle_develop/article/details/6450502feegle_developFri, 27 May 2011 16:42:00 +0800--数据库(可疑)的解决方案(修复数据库)
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
ALTER DATABASE PD_FIE SET EMERGENCY
GO
sp_dboption 'PD_FIE', 'single user', 'true'
GO
DBCC ]]>https://blog.youkuaiyun.com/feegle_develop/article/details/6450496https://blog.youkuaiyun.com/feegle_develop/article/details/6450496feegle_developFri, 27 May 2011 16:40:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5861780https://blog.youkuaiyun.com/feegle_develop/article/details/5861780feegle_developFri, 03 Sep 2010 16:39:00 +0800/*
应用场景:从字符串里提取特殊字符
*/
--提取数字
DECLARE @STRING VARCHAR(200)
SET @STRING='今KFA天KlK在F1254下66FaDFA雨,FKLjFDSA8你97知道8854fAOE么I?UQRQ'
WHILE @STRING LIKE '%[^0-9]%'
BEGIN
SET @STRING=STUFF(@STRING,PATIN]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5861551https://blog.youkuaiyun.com/feegle_develop/article/details/5861551feegle_developFri, 03 Sep 2010 15:20:00 +0800/*
IN、EXISTS和LEFT JOIN，NOT IN、NOT EXISTS和INNER JOIN在存在与不存在的查询效率
*/
 
IF OBJECT_ID('A') IS NOT NULL
  DROP TABLE A
GO

CREATE TABLE A
(
ID INT
)
GO

IF OBJECT_ID]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5861286https://blog.youkuaiyun.com/feegle_develop/article/details/5861286feegle_developFri, 03 Sep 2010 13:48:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5841234https://blog.youkuaiyun.com/feegle_develop/article/details/5841234feegle_developThu, 26 Aug 2010 16:46:00 +0800/*
应用场景：将项目组的员工职位合并到同一列
*/
IF OBJECT_ID('A') IS NOT NULL
  DROP TABLE A
GO

CREATE TABLE A
(
ID INT,
NAME VARCHAR(50)
)
GO

IF OBJECT_ID('B') IS NOT NULLhttps://blog.youkuaiyun.com/feegle_develop/article/details/5841207https://blog.youkuaiyun.com/feegle_develop/article/details/5841207feegle_developThu, 26 Aug 2010 16:42:00 +0800/********************生成xml文档********************/
/********************for xml path********************/
/*
if OBJECT_ID('ct') is not null
  drop table ct
go

create table ct
(
Code int ide]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5841204https://blog.youkuaiyun.com/feegle_develop/article/details/5841204feegle_developThu, 26 Aug 2010 16:41:00 +0800declare @name varchar(100),@sql varchar(100),@drop varchar(max)
--@name存储用户表名
--@sql存储删除用户表语句
--@drop存储查询已删除的表名
set @drop='select name from ('
--循环查找用户表，如无用户名，则退出循环
while (select count(Name) from ]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5686731https://blog.youkuaiyun.com/feegle_develop/article/details/5686731feegle_developTue, 22 Jun 2010 15:49:00 +0800create table xlfkzz_cs
(
xlfkzz01 varchar(20),
xlfkzz02 varchar(20) not null,
xlfkzz03 datetime not null,
xlfkzz04 varchar(20)
)
go

alter table xlfkzz_cs
add constraint pk_xlfkzz_cs]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5656010https://blog.youkuaiyun.com/feegle_develop/article/details/5656010feegle_developTue, 08 Jun 2010 16:18:00 +0800选择"备份数据库",进去"SQL Server备份"界面=>选择"数据库-完全"(默认)=>单击"添加",选择备份路径(例:F:/备份/test201006081545)=>确定(注："备份到"路径有且仅有一个,如果有其它备份路径，请删除)=>选择"追加到媒体"(默认)=>确定】     完全备份完成 2.差异备份 【右键选择数据库(test)=>选择"备份数据库",进去SQL Server备份界面=>选择"数据库-差异"(默认)=>单]]>https://blog.youkuaiyun.com/feegle_develop/article/details/5604793https://blog.youkuaiyun.com/feegle_develop/article/details/5604793feegle_developTue, 18 May 2010 17:11:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5600918https://blog.youkuaiyun.com/feegle_develop/article/details/5600918feegle_developMon, 17 May 2010 16:04:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5594208https://blog.youkuaiyun.com/feegle_develop/article/details/5594208feegle_developSat, 15 May 2010 08:21:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5567702https://blog.youkuaiyun.com/feegle_develop/article/details/5567702feegle_developFri, 07 May 2010 16:51:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5563804https://blog.youkuaiyun.com/feegle_develop/article/details/5563804feegle_developThu, 06 May 2010 16:30:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5563760https://blog.youkuaiyun.com/feegle_develop/article/details/5563760feegle_developThu, 06 May 2010 16:22:00 +0800https://blog.youkuaiyun.com/feegle_develop/article/details/5520035https://blog.youkuaiyun.com/feegle_develop/article/details/5520035feegle_developFri, 23 Apr 2010 14:51:00 +0800