由买买提看人间百态

topics

全部话题 - 话题: fieldid
(共0页)
l*****o
发帖数: 61
1
来自主题: Statistics版 - 求教个SQL的问题
有一组数据,数据结果如下:
Year FieldID Ntreatment Replication Nform Ntiming Yield
2009 ST001 100 1 AA Spring 182
2009 ST001 100 2 AA Spring 186
2009 ST001 100 3 AA Spring 176
2009 ST001 150 1 AA Spring 190
2009 ST001 150 2 AA Spring 198
2009 ST001 150 3 AA Spring 172
2009 ST001 200 1 AA Spring 200
2009 ST001 200 2 AA Spring 195
2009 ST001 200... 阅读全帖
l**o
发帖数: 3
2
来自主题: Database版 - help on store procedure of db2
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
3
来自主题: Database版 - help on store procedure of db2
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
d******y
发帖数: 3668
4
那还真和弥勒佛有缘呢,呵呵
孟庭苇的宝宝也是正月初一生的
http://f.dadunet.com/redirect.php?areaid=72&fieldid=112&subjectid=3096
s***f
发帖数: 173
5
来自主题: BuildingWeb版 - ASP 和DATABASE一问
其实主要是关于数据库的.
比如我有一个PAGE叫CREATE EVENT.ASP, 通过SUBMIT这个PAGE,
我想要在下一个PAGE(叫SHOW EVENT.ASP)中显示CREATE EVENT中选择的项目.
具体说就是, 在CREATE EVENT.ASP中有很多CHECKBOX(比如, FIRST NAME--CHECKBOX
LASTNAME--CHECKBOX EMAIL--CHECKBOX..), 那么我要在SHOW EVENT.ASP中显示CREATE
EVEN.ASP中已经选择了的CHECKBOX的选项的名字(比如FIRST NAME, EMAIL..), 并且后面
还要再加上TEXTBOX从而让USER去INPUT(比如就变成了,FIRST NAME -- TEXTBOX, LAST
NAME -- TEXTBOX..).
而且我被要求一定要将把被CHECK过的CHECKBOX的名字存储到DATABASE中. 我本来打算这
么做: 一个TABLE叫FIELD, 包括FIELDID,FIELDNAME.
但是我发现,如果这么做的话,比如第一次,我存储的结果是:
h***i
发帖数: 11
6
来自主题: Database版 - pls help me in this Sql query
hi, DB experts. here i have an problem to create this query:
i have a table:
T1 {fieldID, fieldvisitTime, fieldUserID, fieldIP}
now i want:
get the last visit time and its corresponding IP for each userID.
I think it's possible to make this query in one SQL sentence. but how?
thanks in advance!!!!!!!!!!!!
m**c
发帖数: 90
7
来自主题: Database版 - pls help me in this Sql query

Should you group by all fields instead of just fieldUserID:
... GROUP BY fieldUserID, lastTime, fieldID
by
k*******a
发帖数: 772
8
来自主题: Statistics版 - 求教个SQL的问题
I guess you need group by year fieldID
l****u
发帖数: 529
9
来自主题: Statistics版 - 求教个SQL的问题
proc sql;
create table ylddiff as
select DISTINCT A.Year, A.FieldID, A.NForm, A.NTiming
(共0页)