SQL SERVER 2005 存储过程
USE AdventureWorks
GO
CREATE PROC spEmployee
AS
SELECT * from Humanresources.Employee
EXEC spEmployee
ALTER PROC spEmployee
AS SELECT EmployeeID from Humanresources.Employee
drop proc spEmployee
ALTER PROC spEmployee
@LastName nvarchar(50) = NULL
AS
IF @LastName IS NULL
SELECT * from HumanResources.Employee
ELSE
SELECT c.LastName,c.FirstName,e.*
from Person.Contact c
INNER JOIN HumanResources.Employee e
ON c.ContactID = e.ContactID
WHERE c.LastName LIKE @LastName + '%'
EXEC spEmployee
BEGIN TRY
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
END TRY
BEGIN CATCH
DECLARE @MyOutParameter int
IF ERROR_NUMBER() = 2714
BEGIN
PRINT 'WARNING SHIPPING CREATE AS TABLE ALREADY EXISTS'
EXEC dbo.uspLogError @ErrorLogID = @MyOutParameter OUTPUT
PRINT 'A ERROR WAS LOGGED.THE ERROR ID WAS ' + CAST(@MyOutParameter AS VARCHAR)
END
ELSE
RAISERROR('SOMETHINGS NOT GOOD HAPPENED THIS AROUND',16,1)
END CATCH
DROP TABLE OurIFTest
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
IF @@ERROR != 0
PRINT 'PROBLEM'
ELSE
PRINT 'EVERYTHING ID OK !'
CREATE PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
RETURN @MyOtherMessage
RETURN
ALTER PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN 100
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
PRINT @MyOtherMessage
RETURN
DECLARE @ReturnVal int
EXEC @ReturnVal = spTestRETURN
SELECT @ReturnVal
DECLARE @Error int
INSERT INTO Sales.Individual
(CustomerID,ContactID)
VALUES
(0,0)
SELECT @Error = @@ERROR
PRINT ''
PRINT 'THE VALUE OF ERROR IS ' + CONVERT(VARCHAR,@Error)
PRINT 'THE VALUE OF @@ERROR IS ' + CONVERT(VARCHAR
相关文档:
直接restore或附加应该是不行的, 用脚本+导数据肯定没有问题。
2005转到2000的步骤
1. 生成for 2000版本的数据库脚本
2005 的manger studio
-- 打开"对象资源管理器"(没有的话按F8), 连接到你的实例
-- 右键要转到2000的库
-- 任务
-- 生成脚本
-- 在"脚本向导"的"选择数据库"中, ......
今天在网上上看见一篇“将SQL查询结果转化为pojo对象的”博客,博主自定义做了一个类如下:
import java.lang.reflect.Field;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.property.ChainedPropertyAccessor;&n ......
drop table #t
create table #t(req_spid int,obj_name sysname)
declare @s nvarchar(4000)
,@rid int,@dbname sysname,@id int,@objname sysnam ......
我们在做很多项目时都要涉及到数据库,特别是一些比较大型的web项目,更是有较大的并发处理,所以对数据库的操作有可能会产生死锁,对于数据库的死锁,一般数据库系统都会有一套机制去解锁,一般不会造成数据库的瘫痪,但解锁的过程会造成数据库性能的急速下降,反映到程序上就会造成程序的反应性能的下降,并 ......
摘自http://hi.baidu.com/dusongw/blog/item/4090493d6ec0cdee3d6d97a6.html
我将以“办公自动化”系统为例,探讨如何在有着1000万条数据的MS SQL SERVER数据库中实现快速的数据提取和数据分页。以下代码说明了我们实例中数据库的“红头文件”一表的部分数据结构:
CREATE TABL ......