ALTER PROCEDURE usp_SchemaChanges
目前分類:DB_TSQL (11)
- Oct 05 Wed 2016 13:48
Schema Changes History
- Oct 04 Tue 2016 16:36
Insert SP results into a table
ALTER PROCEDURE usp_HelpIndex
- Mar 12 Tue 2013 08:37
Create datebase
CREATE DATABASE [DemoDB]
- Mar 06 Wed 2013 14:42
Statements
EXCEPT
- Feb 23 Sat 2013 14:59
Alias cann't be used in the SELECT / WHERE statement
SELECT CaseNo,InCharge,XprCompany1,XprCompany2,XprCompany1+XprCompany2 'xpr' FROM ut_ForeignXpr
- Feb 21 Thu 2013 13:40
查詢優化
http://adalf0722.blogspot.tw/search?q=%E6%9F%A5%E8%A9%A2%E5%84%AA%E5%8C%96
- Mar 09 Wed 2011 14:08
[Table] 備份維護計畫
USE [MSDB]
- Oct 22 Fri 2010 13:03
查詢 Table Size
CREATE TABLE TableSizes