易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

sql中常用动态的行转列

//取出源数据
select groupname,totalnum,inputdate,groupid into #temp from
 (select count(*)as totalnum,p.groupid,g.groupname,convert(nvarchar(10),inputdate,120) as 'inputdate'
 from person p left join admin_group g on p.groupid = g.groupid and deleteflag = '0'
 where p.inactive=' ......

sql大全


. SQL 命令
这部分包含那些 PostgreSQL 支持的 SQL 命令的信息.这里的 "SQL" 就是该语言通常的含义; 每条命令的与标准有关的兼容性的信息可以在相关的参考页中找到.
Table of Contents
ABORT --  退出当前事务
ALTER GROUP --  向组中增加用户或从组中删除用户 
ALTER USER --  改变数据库 ......

sql 全文索引

1、要启用全文索引功能首先需要安装full text search全文索引服务
2、启动full text search服务
3、先创建Unique索引和全文索引:CREATE FULLTEXT INDEX ON table_name
4、每个表只允许创建一个全文索引
删除全文索引 DROP FULLTEXT INDEX ON table_name
全文搜索语句,contains(),freeText()
注 ......

JDBC连接SQL Server 2005的方法

一、下载安装
1、SQL Server 2005 Express Edition
下载 SQL Server 2005 Express Edition(下载页面):
http://msdn.microsoft.com/vstudio/express/sql/download/
安装完数据库后设置ICP/IP协议启动(这一步不能少,默认是TCP/IP不启用的),具体如下:
(1)打开SQL Server Configuration Manager
(2)转到SQL S ......

SQL Server 几个好用的SQL语句

SQL Server 几个好用的SQL语句
1、复制表
 select * into desttable from srctable
 将 srctable 完整地复制一份到 desttable 中,当然后面也可以加上条件来限定需要复制的记录
 要求:desttable 必须为不存在的表名。
 insert into desttable(column1, column2) select columna, columnb from sr ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号