随笔分类 -  SQL

定时从多个Excel导入数据到SQL数据库
摘要：Scheduling Data Imports in SQL Server Importing data into a SQL Server database isn't really that tricky: there's a straightforward wizard that you ca 阅读全文
posted @ 2016-10-13 11:47 batter152 阅读(4250) 评论(0) 推荐(0)
SQL数据库修改默认备份和恢复路径
摘要：每次都做数据恢复和备份的时候，点Add文件，系统会自动指定到一个默认路径，是SQL的安装目录，但是我的数据库不是备份在这里，每次都要更改有点麻烦。如上图，更改这个有三个方法。方法一：找到注册表，手动改注册表路径：HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Micros... 阅读全文
posted @ 2015-12-14 11:33 batter152 阅读(15206) 评论(0) 推荐(0)
SQL Trigger 判断增删改
摘要：--updateif ((exists (select 1 from inserted)) and (exists (select 1 from deleted)))--insertelse if (exists (select 1 from inserted) and not exists (select 1 from deleted))--deleteelse if (not exists (select 1 from inserted) and exists (select 1 from deleted))判断当前修改的某一列是否变化if((select count(*) from in 阅读全文
posted @ 2014-03-12 15:19 batter152 阅读(250) 评论(0) 推荐(0)