批处理SQL 文件
@echo off
rem Input Parameters:
rem 1 -Server Name
rem 2 -Database Name
if "%1"=="" goto ERROR
if "%2"=="" goto ERROR
@rem Make variables local
@Setlocal
@rem set variables from input parameters
set Server=% 1
set DBName=% 2
@rem---------------------------------------------------------------
set LOGFILE=buildDB.log
rem---------------------------------------------------------------
if exist %LOGFILE% del %LOGFILE%
echo--------------------BEGIN %0 -------------------------------------
time/t
echo -----------------BEGIN %0---------------->>%LOGFILE%
time/t>>%LOGFILE%
@rem Create Database
echo Create Database
echo Create Database>>%LOGFILE%
osql -S %Server% -d master -i createdatabase.sql -n -b -w2048>>%LOGFILE%
@rem Create Tables
echo Create Tables
echo Create Tables>>%LOGFILE%
for % %i in(Table\*.sql) do call :osql "% %i"
@rem Create Constraints
echo Create Constraints
echo Create Constraints>>%LOGFILE%
for % %i in(Table\Constraints\*.sql) do call :osql "% %i"
@rem Create Triggers
echo Create Triggers
echo Create Triggers>>%LOGFILE%
for % %i in(Table\Triggers\*.sql) do call :osql "% %i"
@rem Create Indexes
echo Create Indexes
echo Create Indexes>>%LOGFILE%
for % %i in(Table\Indexes\*.sql) do call :osql "% %i"
@rem Create Views
echo Create Views
echo Create Views>>%LOGFILE%
for % %i in(Table\Views\*.sql) do call :osql "% %i"
@rem Create SPs
echo Create SPs
echo Create SPs>>%LOGFILE%
for % %i in(Table\SPs\*.sql) do call :osql "% %i"
@rem Create Functions
echo Create Functions
echo Create Functions>>%LOGFILE%
for % %i in(Table\Functions\*.sql) do call :osql "% %i"
goto DONE
:ERROR
Echo All 2 parameters (Server name ,CMDB database name) must be supplied as parameters.
Echo---------------------------------------------------------
Echo USAGE: %0 [Server] [database]
Echo------------------------------------------------------------
:ERROREXIT
echo-----
相关文档：
【IT168 技术分析】在向2009年告别之际，我们来回顾一下过去的一年中最受欢迎的SQL Server技巧，包括了OPENROWSET、FILESTREAM等函数的用法、密码工具介绍以及DBA日常工作建议等内容。
通过对这些精华文章的再次回顾，希望可以帮助您梳理一下这一年以来的工作以及学习心得，对未来一年更进一步打下更坚实的基础。
� ......
一、适合读者对象：数据库开发程序员，数据库的数据量很多，涉及到对SP（存储过程）的优化的项目开发人员，对数据库有浓厚兴趣的人。
二、介绍：在数据库的开发过程中，经常会遇到复杂的业务逻辑和对数据库的操作，这个时候就会用SP来封装数据库操作。如果项目的SP较多，书写又没有一定的规范，将会影响以后的系统维护 ......
ch02
--3-4
select * from orders
where 'México D.F.' in
(select City
from Customers
where Orders.CustomerID = Customers.CustomerID )
--3-5
select * from orders
where 'usa' =
(select Country
from Customers
where Orders.CustomerID = Customers.CustomerID )
--4-1
select * from or ......
use Dbname
go
select
[表名]=c.Name,
[表说明]=isnull(f.[value],''),
[列名]=a.Name,
[列序號]=a.Column_id,
&nbs ......
