摘要:SQLSERVER存储过程使用说明书sqlserver存储过程入门例子加讲解
阅读全文
摘要:http://wenku.it168.com/d_000425276.shtmlsql server 2008 r2 产品密钥
阅读全文
摘要:http://www.showyounger.com/?p=100633
阅读全文
摘要:use mastergo--定义创建作业DECLARE @jobid uniqueidentifier, @jobname sysnameSET @jobname = N'testInterval'IF EXISTS(SELECT * FROM msdb.dbo.sysjobs WHERE name=@jobname)EXEC msdb.dbo.sp_delete_job @job_name=@jobnameEXEC msdb.dbo.sp_add_job@job_name = @jobname,@job_id = @jobid OUTPUT--定义作业步骤DECLARE @s
阅读全文
摘要:http://www.cnblogs.com/sjrhero/articles/1814442.html
阅读全文
摘要:http://www.cnblogs.com/lijun198504/articles/1352558.html
阅读全文
摘要:http://wenku.baidu.com/view/8225e5294b73f242336c5f5f.htmlhttp://www.cnblogs.com/aliceblogs/archive/2010/08/27/1810362.html
阅读全文
摘要:SQLSERVER存储过程及调用详解SQL Server 存储过程
阅读全文
摘要:http://blog.sina.com.cn/s/blog_609f9fdd0100vujd.html
阅读全文
摘要:create procedure getUserName@userid int,@username varchar(30) outputasbegin select @username=name from person where id=@useridend--declare @username varchar(30) --exec getUserName 1 ,@username output--select @username;create proc findSomeUser(@begin int ,@end int)asbeginselect * from person whe...
阅读全文
摘要:http://www.cnblogs.com/xunziji/archive/2012/08/22/2650822.html
阅读全文
摘要:http://wenku.baidu.com/view/7b2dfffa700abb68a982fb33.html
阅读全文
摘要:http://www.2cto.com/database/201207/140460.html
阅读全文
摘要:http://www.cnblogs.com/icewee/articles/2019783.html
阅读全文
摘要:http://www.wuhao.me/pc/soft/727.htmlhttp://blog.sina.com.cn/s/blog_6b1a15850100sjxq.html
阅读全文
摘要:sqlserver中日期的比较可以用=,>,<
阅读全文