|
t**u
发帖数: 1572 | 2 我agent说先做一般房屋检查，检查的人会说有无白蚁 evidence。
如有pest evidence，再找人检查白蚁。这procedure正确吗？
还是inspection和白蚁检查同时进行？多谢指教
在boston白蚁比较多的区 |
|
r*0
发帖数: 47 | 3 Got wrist injury half way through a game after a few smash. Several weeks
and still not fully recovered. Would appreciate any tips to heal and warm-up
& cool-down procedures. Thanks |
|
w*****y
发帖数: 3900 | 4 http://www.bcsfootball.org/bcsfb/eligibility
Bowl Championship Series Selection Policies and Procedures, 2007-2010 Games:
Automatic Qualification
1. The top two teams in the final BCS Standings shall play in the National C
hampionship Game.
2. The champions of the ACC, Big East, Big Ten, Big 12, Pac-10, and Southeas
tern conferences will have automatic berths in one of the participating bowl
s after the 2006 and 2007 regular seasons.
3. The champion of Conference USA, the Mid-American Conference |
|
b******7
发帖数: 733 | 5 The latest wii hack procedure works on my Wii 4.3U, now I can load game from
USB drive.
I used the 4.3 Softmod Guide from WiiHack |
|
y****i
发帖数: 2108 | 6 方对肖传国的xiao procedure的质疑完全合理。感兴趣的可以google一下,相信从新闻
报道中就可以得出一些结论。注意看英文报道，比较公正些。
简单地说，就是肖在中国草菅人命，把本来应该在大白鼠身上的实验直接用在病人身上
，把处于实验阶段的手术用来营利，然后对结果夸大其词。国外同行请肖去做的同样的
手术结果明显离87%相差太远。
比较可笑可悲的是，肖传国在蹲了半年大牢之后，现在又宣称手术完全不受影响。难道
中国的行医执照没有吊销一说吗？中国人就这么命贱吗？
在中国打假，真的需要勇气。挺周老虎的刘里远朱巨龙还在上窜下跳，魏于全一伙还在
瞄准一切机会反扑，唐骏还是那个唐骏，韩寒也还会是拥有上千万粉丝的韩寒。民智不
开啊民智不开啊。 |
|
p***1
发帖数: 272 | 7 简单说, 这是肖先在美国老鼠上做的, 提出假设, 因为观点独特, NIH 就给钱, 但他没
美国医生执照, 靠他自己根本不可能在美国做clinical trial， 只有回中国试, 再用
中国数据去鼓动老美做clinical trial，狭洋自重, 再杀回中国.
中国数据只有在申请1期有用, 现在像是3期, 是基与J UROLOGY 结果, 和中国数据没太
多关系了. 外科手术有个改进完善过程, 现在的XIAO 术和老鼠上的可能已有改进了,
只不过基本原理类似.
所以XIAO PROCEDURE 作为一个手术方法会有争议, 但基本已活下来了.DETROIT 做了9
个, FLORIDA 做了8 个, 要8个月愈合期.现在这两家在鼓吹, 反对的都没做过. 肖肯定
有吹牛的东西, 但如果全无是处, 老美没那么笨, NIH 再砸2百万往下做.
中国有许多外国人不敢做的手术和药物, 不是所有手术都唯洋大人标准.中国没有IRB,
所以风险手术没有一个监督机制. 好和坏就凭嘴说. |
|
p******t
发帖数: 228 | 8 代码白痴请教fortran问题Orz
自己在试验一个算法，因为以前这方面的程序都是用fortran95写的，所以我现在借用
一下看看。
可是编译时就出现错误：(1) procedures must be either all SUBROUTINEs or all
FUNCTIONs
这个gfortran是gcc4.6自带的，在mac上运行
另外如果在linux下运行gcc4.6自带的gfortran去编译这个程序居然就通过了，不清楚
时啥原因造成的。。。
谢谢 |
|
s*k
发帖数: 144 | 9
Of course you can. But that is not a good database programming
practice.You may need to create too many stored procedures on
server and some only too trivial to bother your DBA to
create and consume system resource of server. |
|
p******a
发帖数: 4 | 10 Thanks. I will use Stored Procedure for SQL only.
As you said , DDL cannot be put in SP.
But I doubt if I can put dynamic SQL in it?
How about CLI? For example, a web search engine needs to
form queries on the fly, can I use SP in this case?
Thanks again! |
|
l**o
发帖数: 3 | 11 we can implement sp on sysbase in java with this way.
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id |
|
l**o
发帖数: 3 | 12 we can implement sp on sysbase in java with this way.
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id |
|
h*****l
发帖数: 184 | 13 一个Stored Procedure原来只要运行两三分钟，
做了些修改以后，要运行半个多小时。
应该如何分析解决问题？
多谢了。 |
|
j****l
发帖数: 6 | 14 I have the following sql command needs to transfer to stored procedure:
select * from book where title " + sTtile + " and author " + sAuthor + " and
date " + sDate;
sTitle and the other three are string. sTitle could be 'is not null' or "like
'%' + @Title +'%' ". It's the same thing for sAuthor and sDate.
I tried to write stored procedue of
... where title @title and author @author and date @date
but it failed.
The purpose of this query is to execute multiple-parameter query.
Your help or sugges |
|
z****a
发帖数: 3 | 15 需要在数据库里写些Stored Procedure / Trigger 来
verify数据的Accuracy和completeness ，数据和Accounting/Finance有关。应该考虑哪
些情况呢?比如说，保证INSERT时不会有duplicate record产生。 除此之外，还应考虑哪
些简单和复杂的senarior呢？谢谢！ |
|
l*m
发帖数: 4 | 16 经常看到optimize stored procedure， 谁能给大体讲一讲啊？
多谢! |
|
aw
发帖数: 127 | 17 DB DESIGN的概念还清楚吧？先把现有的DATA MODEL搞明白。
把SQL语法好好复习一下，STORED PROCEDURE说白了就是包起来的一堆SQL，好的再加点错
误处理之类的。
书AMAZON有一堆，找讲PL/SQL的。有本EXPERT ONE ON ONE口碑不错。 |
|
b******r
发帖数: 1106 | 18 I have a stored procedure
ALTER PROC mysp
@ID int,
@CID int,
@Status varchar(10) = NULL
AS
UPDATE mytable
SET CID=@CID, Status = @Status,
WHERE ID = @ID
declare @ClosureFlag char(1)
set @ClosureFlag = '0'
if @Status = '2'
begin
--update myothertable
delete from myanothertable where CID = @CID
INSERT INTO mythirdtable (CID, 'something deleted')
VALUES (@CID, @message)
-- set the flag for C# code use
set @ClosureFlag = '1'
end
select @ClosureFlag as ClosureFlag
Most time it r |
|
aw
发帖数: 127 | 19 My understanding is that this entire stored procedure is run within a batch so
it should beheave like running in a transaction, if there is any error
updating myothertable and mythirdtable, it should rollback.
这个ASSUMPTION不对，SP就是一堆SQL，你在里面不指定TRANSACTION，它不会给你自动的
。象你这种又是UPDATE又是DELETE，前后还相关的，每步应该查错，如果有，叫它ROLL
BACK。
so |
|
l********n
发帖数: 200 | 20 it did not work...i need something to put in the stored procedure |
|
l********n
发帖数: 200 | 21 do you know if there is a command line to pop-up a message in the stored
procedure?
i don't want to compile and release another EXE file. |
|
l********n
发帖数: 200 | 22 我还是不理解。。。
这个shellexecute放哪里呢？如果放stored procedure，过不了syntax check |
|
x***e
发帖数: 2449 | 23 I do not know the difference of as or is.
For the second question, you'd better use a view instead of stored procedure.
SQL之类）或者就是太晦涩。
常又不能当关键字给goole搜索。 |
|
y********o
发帖数: 2565 | 24 噢，做一个view的话，会省一些typing, 但是还是不如
SQL> show_all_obj JOHNDOE
来得快。
procedure. |
|
m*****g
发帖数: 138 | 25 假如一个Stored Procedure有很多步，有很多数据需要处理，需要运行很长时间
我如何让它运行时返回一些有用信息给用户，
告诉用户正在处理什么数据，正在运行哪一步
而我另外的程序，比如说C#.NET（Win form）可以抓住这些信息
实时显示给用户
谢谢 |
|
j*****n
发帖数: 1781 | 26 今儿我们组里的一哥们遇到一个奇怪的现象：
在query analyzer 里面运行一个query,花了15分钟得到结果，
然后放到把这个query做成一个stored procedure， 除了把where 里面的条件换成了变
量而已，结果需要30分钟才行。
我们的环境是用local的query analyzer 连到 DB server 上。
为什么会有这么大的区别呢？ |
|
c*****t
发帖数: 1879 | 27 No, you misunderstood. Compiled plan doesn't mean its execution plan
would be exactly the same as the direct SQL query execution plan. The
difference thus can lead to performance difference.
I'd suggest you to write a stored procedure that does direct query
and compare. |
|
a*******t
发帖数: 891 | 28 parameter sniffing
it's a pretty oftenly seen problem but it's not very commonly known... M$ is
hidding this from the public...
one of the articles talked about it
http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspx
bascially, you can create a local variable
create procedure usp_myProc
@startdate_in datetime
as
declare @startdate datetime
set @startdate = @startdate_in |
|
e******r
发帖数: 220 | 29 就像用cat可以查看所有table, view.
有没有什么方法查看stored procedures ?
thanks |
|
c**t
发帖数: 2744 | 30 Wrapped a select statement with a stored procedure, not like SQL Server, in
sqlplus, can't simplely: execute sp_Test('param1') to list all records, has
to use cursor. Any sample to list the selections? |
|
t*********i
发帖数: 217 | 31 this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema |
|
j***a
发帖数: 10844 | 32 You can only see the procedure name and passing parameters of those packages
, but not the actual code because they are wrapped. |
|
a******8
发帖数: 46 | 33 Yes. It should be ok to put result into another table then read it in stored
procedure. I'm wondering any other ways can help that. |
|
i****a
发帖数: 36252 | 34 "怎样在固定时间run stores procedure"
sql agent job
"然后把结果存在一个delimited形式的文件里"
write that into your stored proc
再把这个文件放到客户的ftp site
one of the job steps, can use dos command
里, |
|
h**********s
发帖数: 171 | 35 in php/perl/etc, connect to Oracle Database
why need to enclose it in an anonymous block like this?
BEGIN
//call procedure
END; |
|
B*****g
发帖数: 34098 | 36 9i:
call procedure 有一些exception不能handle。有一次一个call proc一点儿error都没
显示，但是error了。加了begin end就出error了。 |
|
g*****y
发帖数: 36 | 37 可以的.stored procedure, function, trigger这些东西MySQL都有 |
|
g***l
发帖数: 18555 | 38 我的SSIS PACKAGE里VENDOR_ID是INT,PASS进去说是TYPE MISMATCH，好像dtsExecCmd只
能接受STRING
create PROCEDURE [dbo].[TestRunMySSISPkg]
@ssisPkgFilePath varchar(500),
@vendor_id int --varchar(5)
AS
begin
DECLARE
@dtsExecCmd varchar(4000)
SET @dtsExecCmd = 'dtexec /F "' + ltrim(rtrim(@ssisPkgFilePath)) + '"'
SET @dtsExecCmd = @dtsExecCmd + ' /SET "\package.Variables[User::vendor_id].
Properties[Value]";""' + @vendor_id |
|
c****y
发帖数: 3592 | 39 我的程序可以跑但是没结果。
rs.Field.Count是有结果的
rs.RecordCount结果是-1(肯定不对)
rs.GetRow或者掉rs结果都是error type mismatch.
我感觉是没有调出东西来？procedure肯定是好的，直接在excel上用connection有结果的
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cmd As ADODB.Command
Dim strConn As String
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Set Cmd = New ADODB.Command
strConn = "Provider=MSDASQL.1;Persist Security Info=True;DSN=pmw;Description
=PMW;UID=pmwreader;Trusted_Connection=Yes;APP=2007 Microsoft Office system;
WSID=BG-R... 阅读全帖 |
|
k**g
发帖数: 1558 | 40 因为我要rank 100个variable,如果一起rank的话，花时间远比100*单个rank的长。所
以想写个stored procedure.
包子以发！ |
|
h*****6
发帖数: 866 | 41 为啥Oracle stored procedure 里面不建议用 temporary table? 谢谢。 |
|
g***l
发帖数: 18555 | 42 我有2千个STORED PROCEDURE，STORE在TFS SOURCE CONTROL里，每周都有几十个
PROGRAMMER UPDATE，怎么DEPLOY简单快捷啊，不用一个一个的COMPILE，SQL SERVER |
|
s**********o
发帖数: 14359 | 43 你这么写会让人笑的，ETL一般不用STORED PROCEDURE，好用SP的，人一看就不是科班
出身的BI，LOL。 SP就要多写多练，多分析实例才行。 |
|
n****e
发帖数: 1403 | 44 MySQL里有几百个tables，现在需要给这些tables都先加一个同名的column to log
changed_timstamp，然后再都生成一个trigger for all 这几百个tables，once any
update on a row，then the column changed_timstamp will be set to now（）。
关键是tables 太多，而且database有可能被drop and recreate结构可能有变化，然后
再给每个table加trigger，如果是manually 加而不是用procedure那就是饿梦啊。 |
|
h*****6
发帖数: 866 | 45 stored procedure running 很慢, 如果把用到的几个tables drop掉，recreate 一
样的tables and indexes，速度就正常一段时间，几天后又会变慢，求建议。 |
|
c*****d
发帖数: 6045 | 46 问题说的不是很清楚
估计是procedure A要select/insert/update/delete table B
然后每次重新建table B能加速执行A的速度？
这样的话肯定是B的statistics有问题 |
|
u*********e
发帖数: 9616 | 47 一个store procedure,以前没事，突然非常非常慢，怎么查原因？我只知道用sql
profiler,可是现在没有access.还有更好的方法吗？ |
|
y*****g
发帖数: 677 | 48 有多个途径实现，看你的精度要求。
1. 用 profiling,
mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT whatstheweatherlike(3);
+-----------------------------------------------------------+
| whatstheweatherlike(3) |
+-----------------------------------------------------------+
| Its 3°C, time is 02:43:25, feels [like] snow is melting |
+-----------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show profiles;
+-----... 阅读全帖 |
|
l******9
发帖数: 579 | 49 I need to run a stored procedure on SQL server 2008.
But, I can only fetch one row from the cursor. After that, the @@FETCH_
STATUS is -1.
DECLARE @my_table TABLE
(
code int not null
);
INSERT INTO @my_table (id)
SELECT DISTINCT a.id
FROM table1 as a
WHERE a.value = 'abc'
ORDER BY a.id ASC
DECLARE t_input CURSOR FOR
SELECT id
FROM @my_table
DECLARE @return_value tinyint
DECLARE @my_id varchar(3)
OPEN t_input
FETCH NEXT FROM t_input... 阅读全帖 |
|
l******b
发帖数: 39 | 50
PL/SQL (Procedural Language/Structured Query Language) statements can be
compiled and executed using DB2® interfaces. This support reduces the
complexity of enabling existing PL/SQL solutions so that they will work with
the DB2 data server.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com |
|
