o**a
发帖数: 1315 | 1 make sure that procedure has an OUTPUT parameter |
|
|
B*****g
发帖数: 34098 | 3 BEGIN
EXECUTE IMMEDIATE 'BEGIN misc.drop_db_link END;';
EXECUTE IMMEDIATE 'drop procedure misc.drop_db_link';
END;
/ |
|
j****s
发帖数: 34 | 4 Thank you so much!
In fact, there are 7 records in the table.
select count(*) from user1;
it will show 7.
So how can I set 7 to @num?
thanks
copy
procedure, |
|
c***c
发帖数: 6234 | 5 I am trying to use Stored Procedure and DataGrid. Do I need to use DataSet or
DataTable for binding?
Can someone provides some sample code or where can I get samples codes?
I am new on C# .Net. Thanks you for help |
|
b****u
发帖数: 1027 | 6 你这想法挺有意思，我想一般来说不需要这么做，如果你的情况真的需要，可以考虑
Stored Procedure 每步都更新一个 table, 然后你的客户端程序不断去读那个进程
table 的最新进展，展示给客户看。不过还是觉得没太大必要，你的具体啥 case |
|
w********i
发帖数: 244 | 7 All,
I wonder if there is benefits for performance for Writing CLR Stored
Procedures in C# ? Thank you!
hai |
|
x**n
发帖数: 461 | 8 No. CLR stored procedure is just the database team's effort to get more work
/bonus. It doesn't help your performance at all because the database is not
designed to do such things. The best place to place your business logic is
still your middle tier. |
|
y********o
发帖数: 2565 | 9 I have never tried stored procedure in Java. So, I would like to give it a
shot.
I got the demo from Oracle and compiled this one: PLSQL.java, which is
attached in this post. This code uses Oracle XE's hr/hr schema. I've tried
some other code with plain SQL, and it runs just fine and returns employee
info from the employees table.
But, when I run this PLSQL, I get the following error, and I don't know what
it means. It looks like I get such error message for all codes involving
stored proced |
|
A**o
发帖数: 1550 | 10 1, make sure you understand what's the expected result
2. excute the stored procedure using sql tools, check if it works at all
3. check your jdbc grammer, and intercept your jdbc call to the db
and check against what you have in 2 |
|
F*******n
发帖数: 89 | 11 谢谢。这个stored procedure肯定是work的。用sql tool试验过的，没有问题。
我也很清楚expected的result。
我的database call也没有grammer问题。 |
|
c*****t
发帖数: 1879 | 12
你是指
select foo ();
工作，还是
insert table values (foo ());
工作，还是
update table set col = foo () where col = ...;
工作？
stored procedure 没写好的话，是可以出现前两个“工作”，但是到 update
的时候出问题的情形。比如，foo () 的结果是一 complex data structure，
这个 data structure 可能写的人没注意，只是 memory resident 的。但是
存到硬盘的结够必须是另外一种形式（比如 size header 等），因为有些
database 出于 performance 的考虑，所有的 in-memory data structure
得和硬盘 上的结构一一对应，并不提供 I/O wrapper 。这样的话，
in memory operation 是可以工作的。但是 store / load 在 database 里的
只是 memory pointer，没有实际的 |
|
z***h
发帖数: 405 | 13 use CallableStatement for stored procedure |
|
z***h
发帖数: 405 | 14 stored procedure 好像只能用 CallableStatement
贴出来看看 |
|
g*****g
发帖数: 34805 | 15 这个我老N年前就总结过了。
ORM的好处，易维护，把计算量迁移应用服务器上，容易处理高并发，缓存简单，可在不
同数据库间移植。在高并发的应用里，关系型数据库本身不能scale out，早晚是个瓶
颈，所以ORM提高了系统能支持的并发数。最近几年NoSQL DB的发展，就是单机数据库
系统在ORM下仍然是瓶颈下的必然道路。
Stored procedure的好处，在低并发，大数据量的一些应用上，如每日产生的报表有离
数据近的优势。但不易维护。近年Oracle在数据库服务器上内建对Java的支持，就是为
了提高可维护性。
SP对单个请求比ORM快几乎是必然的。但100个并发的请求，就不见得一样了，10000个
并发的请求，整一个能撑住的数据库服务器，就要比一个小数据库+一个应用服务器ORM
集群，要贵无数倍。别忘了Oracle之类的数据库是按可比CPU算钱的。
techniques
stored |
|
z*******3
发帖数: 13709 | 16 不过有时候我觉得这样也挺好
dba愿意主动承担责任，我觉得没啥坏处
我们公司的dba都很认真，所以一般我不去主动抢他们的活干
procedure已经写好的我就用，虽然加强了依赖，呼呼
throughput
副产 |
|
l*******n
发帖数: 35 | 17 请益：
有个稀疏表，11万行，100列。每行大概1~10个数据，位置不定其余都是null
要数据处理，把数据都读一遍，需要读出value 和相应 column name
用jdbc分批读，发现读入resultset之后遍历要花40分钟。
纯用stored procedure读会不会效率高点？ |
|
s*******e
发帖数: 261 | 18 请问web page如何连接stored procedure?
e.g., Java -- MySQL
Ruby -- MySQL
Thanks. |
|
l********n
发帖数: 200 | 19 【 以下文字转载自 Database 讨论区 】
发信人: lookforfun (lookforfun), 信区: Database
标 题: 请教：how to call a COM object in a stored procedure?
发信站: BBS 未名空间站 (Sat Nov 11 15:59:33 2006)
编译了一个DLL文件。怎么Register这个文件呢？
必须放在MS SQL Server上吗?
放在客户端计算机上，可以吗？ |
|
l********n
发帖数: 200 | 20 数据库很多TABLE是这样命名的，如 table_1, table_2，....现在有数字这个参数，怎
么把其中的数据拿出来？
由于数字这个参数，好像没法直接用SELECT..., 我用SET试了试(如下例)，但外面定义
的变量t1/t2还不能用，还得在SET里再定义两个参数。如果这样，这些值怎么才能拿出
来用呢？
各位遇到这种情况吗？大家怎么处理的呢？谢谢了。
CREATE PROCEDURE sp_test
@TableID int,
@RecordID int
.
.
.
AS
SET NOCOUNT ON
DECLARE @sl varchar(8000), t1 int, t2 int, ......
SET @sl = 'DECLARE c1 int, c2 int'
SET @sl = @sl + CHAR(13) + 'SELECT @c1 = f1, @c2 =CAST(Right(f2, 5) AS
INTEGER)
SET @sl = @sl + CHAR(13) + 'FROM table_' + CAST(@TableID AS VARCHAR)
SET @s |
|
r****y
发帖数: 26819 | 21 dynamic stored procedure.. |
|
l********n
发帖数: 200 | 22 程序编译好了，也不想再动了，所以想动动stored procedure，让它弹出一个message
box或页面。
不知是否可行？ |
|
p*****2
发帖数: 21240 | 23 procedural, function不是first class |
|
c****r
发帖数: 36 | 24 http://www.informaworld.com/smpp/content~db=all~content=a908672612~frm=tit
lelink
AN IMPROVED SYNTHESIS OF 2-ANTHRALDEHYDE
Authors: Palanisamy Arjunana; K. Darrell Berlina
Affiliation: a Department of Chemistry, Oklahoma State University,
Stillwater, OK
DOI: 10.1080/00304948109356143
Publication Frequency: 6 issues per year
Published in: Organic Preparations and Procedures International, Volume
13, Issue 5 October 1981 , pages 368 - 371
万分感谢 |
|
p******t
发帖数: 228 | 25 代码白痴请教fortran问题Orz
自己在试验一个算法，因为以前这方面的程序都是用fortran95写的，所以我现在借用
一下看看。
可是编译时就出现错误：(1) procedures must be either all SUBROUTINEs or all
FUNCTIONs
这个gfortran是gcc4.6自带的，在mac上运行
另外如果在linux下运行gcc4.6自带的gfortran去编译这个程序居然就通过了，不清楚
时啥原因造成的。。。
谢谢 |
|
f*****y
发帖数: 709 | 26 The following is the procedures I followed for applying for FPGEE:
1. Obtain official transcripts from the pharmacy school where you received
your degree. Remember ask the school official to sign the seal of the
transcripts. In the meantime, request a letter (Lack of Licensure) from Li
Laoshi which states that "You are qualified to practice pharmacy in China,
etc". The letter is in Chinese and I sent it to FPGEC without translation
and that was okay. The phone number of Li Laoshi can be foun |
|
v******V
发帖数: 314 | 27 ☆─────────────────────────────────────☆
farmboy (Boy) 于 (Tue Dec 11 12:47:23 2007) 提到:
The following is the procedures I followed for applying for FPGEE:
1. Obtain official transcripts from the pharmacy school where you received
your degree. Remember ask the school official to sign the seal of the
transcripts. In the meantime, request a letter (Lack of Licensure) from Li
Laoshi which states that "You are qualified to practice pharmacy in China,
etc". The letter is in Chinese and I sent i |
|
f*****y
发帖数: 709 | 28 发信人: ClarkKent (little-superman), 信区: Pharmaceutical
标 题: Re: FPGEE Application Procedures
发信站: BBS 未名空间站 (Tue Dec 18 14:31:56 2007)
Per Ms Li, now Ms Du at 010-88312156 is in charge of this matter. Her fax is
010-88312155. You need to provide a copy of your diploma through fax and an
address in China for her to mail the document. The service is free. |
|
f*****y
发帖数: 709 | 29 发信人: ClarkKent (little-superman), 信区: Pharmaceutical
标 题: Re: FPGEE Application Procedures
发信站: BBS 未名空间站 (Tue Dec 18 14:31:56 2007)
Per Ms Li, now Ms Du at 010-88312156 is in charge of this matter. Her fax is
010-88312155. You need to provide a copy of your diploma through fax and an
address in China for her to mail the document. The service is free. |
|
m**c
发帖数: 199 | 30 这种问题应该去编程版，不适合在这里问
procedure: |
|
y*****o
发帖数: 25 | 31 I don't have Enterprise miner. What procedure is for neural network in SAS?
I remember it's proc neural, but I can't find it anymore. Does anyone here
know?
thanks |
|
h*******d
发帖数: 272 | 32 外行菜鸟学regression 混淆了很多概念请大家指点：
开始学了 共线性的危害；先检测FULL MODEL 根据t值剔除不显著的变量--reduced
model 然后再用F-test CONFIRM.
后来又学了 best subset procedure（这里没再提共线性）
感觉2个都是减少变量，优化MODEL 的啊 区别在哪？
谢谢大家 等待您的回复 |
|
s********9
发帖数: 74 | 33 I seldom get chance to communicate with people in the field in my daily work
, while I heard that some company have one group of people only concentrate
on data clean, another group only focus on sampling...
I have to do almost all by myself, sometimes because there are so much to do
, so something may get neglected and cause trouble for the following work.
Any one has the standard procedure for any step from sampling to statistical
result report? Or any other suggestion? |
|
p********a
发帖数: 5352 | 34 I guess this depends on what data you are working on. For different data
structure, there is no such "standard procedure". |
|
b*f
发帖数: 3154 | 35 看那个little sas的书说，macro的好处就是可以reuse，那procedure难道不也是为了
reuse么？这两者的区别是什么？
初学者，请大拿指导。 |
|
o*********h
发帖数: 6 | 36
procedure 现成的， macro 得自己写 |
|
b*f
发帖数: 3154 | 37 So what is the advantage of macros? Whatever macros can do, a procedure can
be written to do the same, correct? If the answer to this question is "YES",
then what is the point of having macros? I have difficulty explaining this
question to my LD who is learning SAS.
Baozi is sent, BTW.
macro |
|
a*****3
发帖数: 601 | 38 yes, you understand 80% correctly. 给个伪币吧。
least: not that easy). So if you want to implement any logic, you will have
to use: macro. I came from other background so I thought SAS procedures
are like: functions in other programming languages that you can write easily
.: Am I understanding it correctly now? |
|
a*****n
发帖数: 230 | 39 SAS has a closed development system. It is very hard for anybody outside SAS
Institute to write a native SAS procedure. Use R for developing new
methodology. |
|
d*******o
发帖数: 493 | 40 What gain would you have with a procedure, since you already have a good-
working macro? |
|
o**m
发帖数: 828 | 41 请问 怎么在 nlme 包里的 lme 函数生成的 object 上
用 stepwise procedure ，例如 step(lm.mod) 类似的
谢谢
包子上 |
|
H***M
发帖数: 7 | 42 自己学的SAS，朋友帮忙介绍一个工作，也许能有interview，我不是学统计的，只能做
prgrammer,而他们正好就找程序员而不是统计分析师。高手们帮忙指点一下，做SAS程
序员和reporting engineer主要用哪些procedure，我能想到的有proc print, proc
report, proc graph, proc plot, gplot, summary, tabulate, freq, format, sql..
...
感谢！ |
|
a****g
发帖数: 8131 | 43 and can be used for many proportional test, chi-sq, fisher's exact, cmh, etc
probably you also need some widely used model buidling procedures
such as glm, logistic, genmod, catmod, |
|
p***r
发帖数: 920 | 44 I have about 10-20 different procedures, depending on different requirement
of on the variables, I need to pick one out of them very time to run it.
And repeating this picking and running 1000-2000 times, is there anyway to
implement this by macro?
Thanks |
|
x***x
发帖数: 3401 | 45 yes, macros can be implemented to run data driven procedures. But without
any details on specifically what you would like to do, it is hard to give
suggestions. |
|
t*****8
发帖数: 157 | 46 有谁知道ICD-9 procedure 和CPT/HCPCS的区别？
thx |
|
t*****8
发帖数: 157 | 47 除了形式上有差别，在用途上有什么出别吗？ 是不是ICD-9 procedure主要用在
hospital上，而CPT/HCPCS用在outpatient 上？ |
|
A*******s
发帖数: 9638 | 48 Just saw a patient who is 20 yrs old. He has a spinal bifida but has to do
cath since age 16 after he had a surgery for a tethered spinal cord. He came
to see me for other medical problems. Since I saw his PMH, I mentioned Dr.
Xiao's procedure.
We watched the youtube togather and he got very excited. He is pretty
healthy otherwise. |
|
A*******s
发帖数: 9638 | 49 Don't know. I hope he sets a criteria for the procedure and carefully screen
the candidates. Why the clinical trial not done in China? Language
barrior could be a significant variant for the screening. |
|
