涓涓细流，汇成波涛汹涌的大海

http://topic.youkuaiyun.com/u/20080826/15/ec583006-f265-4a1d-a5f4-abeee2189114.html

http://wenku.baidu.com/view/cf93afa3284ac850ad024253.html?from=related

例1：create proc proc_stu @sname varchar(20), @pwd varchar(20) as select * from ren where sname=@sname and pwd=@pwd go查看结果：proc_stu 'admin','admin'例2：下面的存储过程实现用户验证的功能，如果不成功，返回0，成功则返回1.CREATE

DECLARE @dms varchar(100)EXEC [dbo].[BJJ_CreateDm] '南宁化工股份有限公司','z',@dms OUTPUTSELECT @dms 或者： DECLARE @str varchar(1000)EXEC [dbo].[BJJ_CreateDm] @lx = 'Z',

Declare @Age intDeclare @Name varchar(20)Declare Cur Cursor For Select Age,Name From T_User Open CurFetch next From Cur Into @Age,@NameWhile @@fetch_status=0 Begin Update T_User Set [N

是sybase的连接字符串不对，最后查出来是因为ODBC里面没有配置正确。。。。

dts(data transformation services)主要就是用来在不同的数据库之间迁移数据用的。http://www.dbworld.com.tw/member/mag_article/S020300002.pdf

http://topic.youkuaiyun.com/u/20090321/19/b57601a0-97d0-4481-8ac3-4e7ea0d3e90e.html

http://topic.youkuaiyun.com/u/20081125/18/9007115f-b276-4ca6-b3a7-12db9aa983d5.html

http://topic.youkuaiyun.com/u/20080920/15/61bf31bf-518c-41be-9e4a-b166c878dcaf.html

http://topic.youkuaiyun.com/u/20081028/16/cb785186-eed1-4e26-b81b-357452e4a7b4.html