ms sql存儲過程參數返回值
create table tabReProc
(
name varchar(30),
age integer,
primary key(name,age)
)
insert into tabReProc values('x7700',20)
insert into tabReProc values('x7711',21)
insert into tabReProc values('x7733',23)
insert into tabReProc values('x7755',25)
if exists(select *from dbo.[sysobjects] where [name]='proc1')
drop proc proc1
go
create procedure proc1(@parm1 integer,@parm2 varchar(30) output)
as
select @parm2='zhongguo'
select * from tabReProc where age=@parm1
return 100
go
declare @tmpa int
declare @param1 int ,@param2 varchar(30)
select @param1=20
execute @tmpa=proc1 @param1,@param2 output
select @tmpa,@param2
相关文档：
On BULK COLLECT
By Steven Feuerstein Oracle ACE
Best practices for knowing your LIMIT and kicking %NOTFOUND
I have started using BULK COLLECT whenever I need to fetch large volumes of data. This has caused me some trouble with my DBA, however. He is complaining that although my programs mig ......
SQL语句先前写的时候，很容易把一些特殊的用法忘记，我特此整理了一下SQL语句操作。
一、基础
1、说明：创建数据库
CREATE DATABASE database-name
2、说明：删除数据库
drop database dbname
3、说明：备份sql server
--- 创建 备份数据的 device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssq ......
The following tables describe certain SQL
limits. Adhering to the most restrictive case can help the programmer
design application programs that are easily portable.
Table 7. Identifier Length Limits
Description
Limit in Bytes
Longest authorization
name (can only be single-byte characters) ......
表中有一些记录内容重复，也就是说这些记录除了ID不同之外，其他的信息都相同。需要把重复的记录保留一条，剩下的删除
--第一种方法
delete from temp where id not IN (select min(id) from temp group by col1,col2)
--对col1,col2，即要删除的数据col1,col2两个列都相同,删除id大的行
--第二种方法
with a as
(sel ......
1．SQL并行查询
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --修改会话并行DML select /*+parallel(a,4)*/ * from table_name a select /*+parallel(a,8)*/ * from table_name a &nbs ......
