由买买提看人间百态

topics

全部话题 - 话题: tables
1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)
w*******y
发帖数: 60932
1
KidKraft 2-in-1 Activity Table with Train Set, Legos & Lego-compatible Board
- $59.99 + $5 shipping
Link:
http://kids.woot.com/
Cheapest I've seen this table. It is $89.97 at Amazon and Walmart; $94.99
at Target; $117 at Kohls.
Product Description from Amazon.com
If your children enjoy playing with Legos or train sets, the KidKraft 2-in-1
Activity Table is what you need to keep their play area organized and neat.
Designed for children ages 3 and older, this durable and versatile activity
is the... 阅读全帖
r*****3
发帖数: 143
2
中文名: Pro iOS Table Views
作者: Tim Duckett
资源格式: PDF
版本: 英文文字版/EPUB
出版社: Apress
书号: 1430233486
发行时间: 2012年
地区: 美国
语言: 英文
内容介绍:
If you’re an iOS app developer, chances are you’ll be using table views in
your development projects. Table views are the bread and butter of iOS apps
. With them, you can create everything from the simplest of lists to fully
tricked-out user interfaces.
Table views are one of the most complex components found in UIKit. While
using them for boring standard user interfaces ... 阅读全帖
L******d
发帖数: 2461
3
来自主题: Pingpong版 - 2011 Black Friday Table Tennis deals
Sportspower Titan 2-pc
Where: Sears
Table Top: 1" (25.4mm)
Weight: 243 Lbs
Price: $340+shipping
Stiga ST4100 Indoor
Where: Dicks Sporting Goods
Table Top: 1"
Weight (Lbs): 不详
Price: $400+shipping
Sportspower Vertex 2 Piece
Where: Sears
Table Top: 3/4" (19.5mm)
Weight (Lbs): 179.7
Price: $240+shipping
Stiga ST3100
Where: Dicks Sporting Goods
Table Top: 3/4"
Weight (Lbs): 不详
Price: $230+shipping
Ping Pong Ultra
Where: Sports Authority
Table Top: 3/4"
Weight (Lbs): 不详
Price: $220+shipping
AMF... 阅读全帖
l******l
发帖数: 2651
4
U.S. table tennis mecca in Milpitas
不是所有印度人只靠忽悠。
Source:
http://www.mercurynews.com/other-sports/ci_21014290/bay-areas-l
Pingpong paddles spill out of a laundry bin on the floor of Rajul Sheth's
office in Milpitas -- just a small hint of the large entrepreneurial success
story at work here.
In a quiet corner of the South Bay, just beyond the neatly trimmed, cookie-
cutter neighborhoods, Sheth has turned a boxy warehouse into the country's
biggest table tennis center. In doing so the Indian immig... 阅读全帖
v***v
发帖数: 5504
5
总结
星期五 5:00 pm ~ 10:00 pm
星期六 9:00 am ~ 10:00 pm
========================================================
Please join us for our Grand Opening
Triangle Table Tennis is opening at 4:30 PM on Friday, May 30th
2900 Perimeter Park Drive | Suite 200 | Morrisville, NC 27560
Overflow parking is available at 2000 Perimeter Park Drive, and shuttle
service is provided to and from Triangle Table Tennis from 4:00 – 10:00 pm
on Friday, May 30th
Our ribbon-cutting ceremony will last from 4:45 to 5... 阅读全帖
P****S
发帖数: 2457
6
By Daniel G. Amen, MD
My favorite physical activity is table tennis, which also happens to be the
world's best brain sport. It is highly aerobic and gets both the upper and
lower body moving in every which way — twisting, bending down low, reaching
up high, and shuffling from side to side. Plus, it gives your brain one
heckuva workout.
Also known as "ping-pong," the game is great for hand-eye coordination and
reflexes (cerebellum and parietal lobes). You have to focus (prefrontal
cortex) so you ... 阅读全帖
s****e
发帖数: 1180
7
我有一个问题,有一组tables,
products has productID, productName, price
customer has cumstomerID, customerName,
sale has productID, customerID
面试人问这三个tables哪个是dimension tables, 哪个是fact tables,
我说, products 是fact table, customer 和sale 是dimension tables,那人说不对,
三个tables都是dimension tables.
我看了dynkin的说明就觉得很糊涂.
你们觉得呢?
多谢!:)
s****e
发帖数: 1180
8
我有一个问题,有一组tables,
products has productID, productName, price
customer has cumstomerID, customerName,
sale has productID, customerID
面试人问这三个tables哪个是dimension tables, 哪个是fact tables,
我说, products 是fact table, customer 和sale 是dimension tables,那人说不对,
三个tables都是dimension tables.
我看了dynkin的说明就觉得很糊涂.
你们觉得呢?
多谢!:)
d*******n
发帖数: 109
9
这三个table从一般的理解就是sales是fact table, 其他两个是dimension table.
从本身三个table的特性是这么理解,而且,
从sales table的两个column都是refe到其他两个table的也可以看出这一点。
所以不太理解为什么说三个都是dimension table.
当然实际上fact table都是有一堆fk的。
关于理解multidimensional database, 有时间的话可以看看下面的系列视频
http://www.youtube.com/watch?v=cwpL-3rkRYQ&list=PLrbIyvYCdg0iAU
s********e
发帖数: 893
10
来自主题: Database版 - 给一堆table,怎样能自动生成ERD
一个常见的问题是做一个新的复杂的数据库项目时,很多个table你不知道他们之间都
是什么关系。通过看每个table的constraints和dependecy,可以看到一个table的所有
FK都是reference哪个table的。我目前知道的在Oracle Sql Developer或Sq Server
management studio里都可以这样看到,但是只能一个table一个table的看。我想肯定
有一个tool,可以把这很多个table的关系自动生成一个ERD表,比如Table A的PK跟
Table B的FK自动连起来。请问Sql developer或sql server里都可以做吗?多谢了!
b******n
发帖数: 592
11
来自主题: Programming版 - 问个hash table问题
hash_add(key, value)
index = hash_function(key)
while table[index].key != undefined:
index ++
table[index].key = key
table[index].value = value
hash_find(key)
index = hash_function(key)
while table[index].key != undefined && table[index].key != key:
index ++
if table[index].key == undefined:
return does_not_exist
else
return table[index].value
怎么感觉c+python的乱, add要注意,如果最终size不是预知的话,一旦存储元素超过
60%,table就要double。超过这个效率就回很低。最好的是预先知道多少个元素,按
照n/0.6的大小allocate table
w*******y
发帖数: 60932
12
Free ship for "New Customers"(meaning email that is not in their system per
the promo details) with code FSHNEWAFL
All items in this category an additional 50% off at checkout.
Tailgate Gear:
http://www.dickssportinggoods.com/family/index.jsp?categoryId=1
*Rolling grill does not add to cart, sorry*
I think the best deals are:
Tailgate Gear Oversized Arm Chair $10:
http://www.dickssportinggoods.com/product/index.jsp?productId=3
Tailgate Gear OS Dual Arm Chair $15:
http://www.dickssportinggoods.co... 阅读全帖
s**o
发帖数: 256
13
来自主题: RuralChina版 - Tables:
Table 2.1 Poverty Alleviation Strategies In Rural China
Table 2.2 Four Major Poverty Alleviation Initiatives During ESPAP
Table 2.3: The Design Of Food-For-Work Project
Table 5.1.1: The Comparison Of Two Research Sites
Table 5.2. 1: The Strengthen of Labor Mobility to different level
Table 5.2.2: Different Outcomes Made By Different Organizations On Micro-credit
Table 5.2.3: Ranking order of local perspectives on what constitutes poverty
Table 5.2.4: Local Perspectives On The Causes And Rea
l******9
发帖数: 579
14
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL copy a table into a new table and add a new column
发信站: BBS 未名空间站 (Fri May 23 12:05:22 2014, 美东)
need to copy a table into a new table on SQL server 2008. Also, add a new
column into the new table.
The values of the new column depends on the compare result between the new
table and another table.
Example,
Table1:
col1 col2 col3
abc 346 6546
hth 549 974
Table1_new:
col1 col2 col3 c... 阅读全帖
ak
发帖数: 512
15
来自主题: Database版 - column in table point to another table
question: how to create a column in one table which points to another table?
for example:
column(premises) in table data_rules has its type : rule_type,
rule_type is another table. (see the following two tables).
i saw these two table, but i do not know how create premises
and let it has type(rule_type which points to another table).
would you please write the command for me? thanks!
SQL> desc data_rules;
Name Null? Type
----------------------------------
f********u
发帖数: 572
16
来自主题: Database版 - 合并table的问题大家帮帮忙
有一个Access数据库, 其中有5个table。 这5个table, 其中每两个之间都有2到4个同
样的关键字。 比方说省代码, 区代码, 建筑物代码。
但是每个table中的其它数据fields都是不同的。 每个table包涵的records数目也是不同
的。
现在我想把这5个table合并成一个大table, 其中包含每一个table所有的fields, 所有
的record。
我有点想不清楚应该怎样建立这个relationship。 好像如果只是简单的对应相同的关键
字, 总是把结果table records的数目农的特别大。 感觉很多重复。 我也不太懂。 希
望行家能详细的指点一下我该怎么做? 思路是什么?
谢谢!
x***e
发帖数: 2449
17
来自主题: Database版 - Help on Sql server huge table performance
serious.
上中下三策。
上中已经被你排除了。
now, you need some serious codings and configurations to do.
idea 1) use temp table.
basically, you wanna create a view, including the report table and at least
a temp table.
when people do insert, always insert to the empty temp table first.
then you will get the row count, if the row count is small,
then insert/update it to the report table, if big, danamically create a new
temp table,
and include the 3 table into the view, so the table list in the view grows,
instea
S*******r
发帖数: 44
18
我用beamerposter写poster, 给table加caption以后,table的编号不显示.即
\begin{table}
\caption{Caption}
\label{tab:tab1}
...
\end{table}
pdf文件中是:
Table: Caption
而不是
Table 1: Caption
奇怪的是我引用这个table的时候, "Table~\ref{tab:tab1}"的显示却没有问题
大家有没有遇到过这个问题?
m****r
发帖数: 141
19
I am compiling a LaTeX file with 10 chapters and a table of contents. I have
added the following in the first page.
But why is the table of contents still missing?
thanks !!!
Any help will be appreciated.
This is the main file.
\pdfbookmark[1]{TABLE OF CONTENTS}{table}
\tableofcontents
\addtocontents{toc}{\def\protect\@chapapp{}} \cleardoublepage \
phantomsection
\addcontentsline{toc}{chapter}{LIST OF TABLES}
\listoftables
\cleardoublepage \phantomsection \addcontentsline{toc}{chapter}{LIST OF
F... 阅读全帖
m****r
发帖数: 141
20
I am compiling a LaTeX file with 10 chapters and a table of contents. I have
added the following in the first page.
But why is the table of contents still missing?
thanks !!!
Any help will be appreciated.
This is the main file.
\pdfbookmark[1]{TABLE OF CONTENTS}{table}
\tableofcontents
\addtocontents{toc}{\def\protect\@chapapp{}} \cleardoublepage \
phantomsection
\addcontentsline{toc}{chapter}{LIST OF TABLES}
\listoftables
\cleardoublepage \phantomsection \addcontentsline{toc}{chapter}{LIST OF
F... 阅读全帖
l******9
发帖数: 579
21
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL copy a table into a new table and add a new column
发信站: BBS 未名空间站 (Fri May 23 12:05:22 2014, 美东)
need to copy a table into a new table on SQL server 2008. Also, add a new
column into the new table.
The values of the new column depends on the compare result between the new
table and another table.
Example,
Table1:
col1 col2 col3
abc 346 6546
hth 549 974
Table1_new:
col1 col2 col3 c... 阅读全帖
l******9
发帖数: 579
22
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL copy a table into a new table and add a new column
发信站: BBS 未名空间站 (Fri May 23 12:05:22 2014, 美东)
need to copy a table into a new table on SQL server 2008. Also, add a new
column into the new table.
The values of the new column depends on the compare result between the new
table and another table.
Example,
Table1:
col1 col2 col3
abc 346 6546
hth 549 974
Table1_new:
col1 col2 col3 c... 阅读全帖
c**l
发帖数: 9003
23
Local Table Tennis Community,
Triangle Table Tennis, the new, dedicated Table Tennis Center conveniently
located in the middle of the Research Triangle, is getting ready to open
soon!
We are working hard to prepare for our Center’s Grand Opening on the last
weekend in May, to coincide with the arrival of our Head Coach, Fei-Ming
Tong.
In the meantime, we are pleased to offer several free Open-Play
opportunities prior to our Grand Opening. Although we’ll still be
implementing some of our plan... 阅读全帖
f*****g
发帖数: 15860
24
来自主题: TexasHoldem版 - Maryland Live! to begin table games in April
http://news.yahoo.com/maryland-live-begin-table-games-195127566
ANNAPOLIS, Md. (AP) -- Maryland's largest casino says it's on track to open
live table games in April.
Maryland Live! announced Tuesday that table games like blackjack will begin
on April 11, pending final regulatory approval.
The casino says it will have 122 table games. In addition to that, about 50
poker tables will be added when a two-level poker room is finished by this
summer.
Maryland Live! also says less than 10 percent of t... 阅读全帖
M****N
发帖数: 16093
25
【 以下文字转载自 Music 讨论区 】
发信人: Enterlight (:-), 信区: Music
标 题: 【翻唱】Lighty 音乐剧之二 Empty Chairs at Empty Tables
发信站: BBS 未名空间站 (Mon May 19 16:24:35 2014, 美东)
音乐剧之旅二: Music of the Night还没完全学好又爱上了Michael Ball唱过的这首
Empty Chairs at Empty Tables. 恰好之前找到了一盘Les Mis的卡拉OK伴奏CD 就现学
一下. 电脑风扇很吵 手机的收音效果大受影响 先这么地吧 轻拍...
歌名:
Empty Chairs at Empty Tables
歌词:
There's a grief that can't be spoken.
There's a pain goes on and on.
Empty chairs at empty tables
Now my friends are dead and gone.
Here they talked of revolution... 阅读全帖
g***o
发帖数: 297
26
来自主题: Database版 - for that drop table error
For that drop table error.
I met the same problem with you today.
The situation is that I exported one table called "Contact_LIST_2001" from MS ACCESS into ORACLE, after exported successfully,
I tried to drop this table by using query
DROP TABLE Contact_LIST_2001;
I got the error "the table or view does not exist"
Then I use the query
DROP TABLE "Contact_LIST_2001";
I was successfully dopping that table.
f********u
发帖数: 572
27
来自主题: Database版 - 如果比较两个table?再access里边
两个table, 我想找出一个table里不包含第二个table里的record的所有record。
这么说吧,Table A & Table B有交集。 我要把table A里边不和table B有交集的
records都列出来。请问如果写这个sql?谢谢
m******y
发帖数: 588
28
来自主题: Database版 - Help on Sql server huge table performance
我们有些巨大无比的report table, 每个table有200多个columns, 所有run同样的
report的用户share同一个report table, 用session identifier区分。 有的user不用
filter, 可以generate出来half million records and insert into report table,
有的只有几千几百rows. 因为有很多的insert and update, 所以report table 没有任
何index. 现在问题是:
1 有大的insert 和 update 非常慢。
2 用户之间影响非常大。 如果一个用户report 结果只有几百rows, but another
user has over half million records generated and inserted in the same table,
then 那个用户即使只有几百rows, 做insert, update 也无比的慢。
我现在没法改table structure和logic or hardware, 请
g***l
发帖数: 18555
29
那不就是个TABLE UPDATE的问题么?TABLE里没有RANK COLUMN给你吧,你如果还要去
ALTER TABLE的话,那你这个SP就很外行了,原则是不让你改TABLE,你弄个TEMP TABLE
,RANK完一个放进去,TABLENAME也做成个COLUMN,然后RANK第二个再放进去,最后一次
性显示出来。如果你去ALTER TABLE的话,RUN两次在同一个TABLE加同样的COLUMN当然
会出错,这种做法也很不专业。
r***o
发帖数: 1526
30
来自主题: EmergingNetworking版 - 问个route table的问题
架了个OpenVPN,在client端route table出了点问题,
Windows IP configuration:
Local LAN Adapter
IPv4 Address. . . . . . . . . . . : 10.40.104.11
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 10.40.104.1
VPN Adapter
IPv4 Address. . . . . . . . . . . : 192.168.66.2
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
VPN断开时的route table:
IPv4 Route Table
===========================================================================
Active Route... 阅读全帖
r*****d
发帖数: 54
31
for example we have
\begin{table}
\caption{This is big table}
.
.
.
\end{table}
The result will be
Table 1. This is a big table
.
.
.
However, I want the result to be
Table 8. This is a big table,
how to do this??? Thanks a lot!
h********z
发帖数: 7
32
Hi, 各位朋友同学:
关于latex问题请教。
如何消掉 “TABLE OF CONTENTS” 在“TABLE OF CONTENTS"
的下面。我不知道如何修改 class 文件。
TOC (Table of Contents) format.
Currently, with a defined class file, the generated pdf file as
TABLES OF CONTENTS
DEDICATION................................iii
ACKNOWLEDGMENT............................iv
ABSTRACT...................................vi
TABLE OF CONTENTS...........................viii
LIST OF TABLES...............................xii
How can I remove the "TABLE OF CONTENTS"?
有遇到过这个问题的,可否指教
l******9
发帖数: 579
33
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL combine two tables into one table and add a new column
发信站: BBS 未名空间站 (Thu May 8 14:54:50 2014, 美东)
I need to combine two tables into one. Ans also, add a column (assign an int
value) to the new table on SQL. So that the rows from table1 and ones from
table2 are assigned with different values.
Example,
table1
ID1 ID2 ID3 VALUE
table2
ID1 ID2 ID3 VALUE
table3
ID1 ID2 ID3 VALUE
i need to combine ... 阅读全帖
l******9
发帖数: 579
34
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: keep group of values of SQL procedure in one table
发信站: BBS 未名空间站 (Sat May 24 09:48:08 2014, 美东)
I need to print out a group of values from a procedure on SQL server 2008.
If I use select , it generated a distinct table into the result part of SQL
server 2008 managemetn studio every time the procedure is called.
i need to call the procedure in a loop. I want to print the values into one
table.
Thx!
while
begin
my_proce... 阅读全帖
l******9
发帖数: 579
35
【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: create table on SQL server from python pyodbc
发信站: BBS 未名空间站 (Fri Aug 1 13:19:15 2014, 美东)
am trying to access SQL server 2008 R2 from Eclipse pydev ( python 3.2 ) on
win7 .
I need to create a table on database.
The code can be run well. But, I cannot create tables in the database. If I
print the sql string and run the query from SQL server management studio, no
problems.
import pyodbc
sql_strc = " IF OBJECT_ID('[my_db].[dbo].[my_t... 阅读全帖
h****m
发帖数: 1490
36
来自主题: NextGeneration版 - changing table有什么特别之处?
这几天在看crib,有的是combo,就是crib+changing table
今天Kmart的柜子打折,扛了一个回来,打算给宝宝放衣服的。装好后发现高度挺适合
做changing table的。
又仔细的看了一下和changing table的区别,好像changing table有高起的边,是不是
这样比较安全?
可换尿布的时候大人不就在身边吗?怎么会翻下来?如果真会翻下来,那changing
table的边缘也挡不住的呀。
不知道我理解是不是有误,已有changing table的JMS请说说。
谢谢
X*******6
发帖数: 306
37
我有这样的想法:
我们同时在全国各城市打同样的广告. 三点:
1. 是否同意ABC这样一个道歉? 把 这改了日期和没有签名的广告登上去. 有二个意思,
我们有10 万人在白宫签名,让每个人看到这道歉和他们的意见.二个意思是让大众和媒
体了解为什么华人抗议他们的道歉.
2:是否取 ABC"Kids Table" ? Kids Table是一个很好传遍好的消息给孩子们和大众,我
们从来没有提取消"Kids Table',反而提出: Teaching Kids to love, not to kill.
让孩子爱每个生活在这里的人.希望能有媒体把这些好的教育播发给孩子们. 我们建立
一个网让大家投票. 这样一来,各种人群会认同我们的观点和支持. 11.9,我们在 游行
的时候,一个黑人开大车的司机停下来问我们要这个牌Teaching Kids to love, not to
kill,然后我还给他另外一个: ,他把它们放在 BUS 前面.
3. 解雇Jimmy ..他不适合作主持人,不会引导孩子们做正确的事情. 我们需 要一个有
责任心
,能教育孩子们哪些是 ,可以做,哪些是错误,不能做... 阅读全帖
E********t
发帖数: 4091
38
音乐剧之旅二: Music of the Night还没完全学好又爱上了Michael Ball唱过的这首
Empty Chairs at Empty Tables. 恰好之前找到了一盘Les Mis的卡拉OK伴奏CD 就现学
一下. 电脑风扇很吵 手机的收音效果大受影响 先这么地吧 轻拍...
歌名:
Empty Chairs at Empty Tables
歌词:
There's a grief that can't be spoken.
There's a pain goes on and on.
Empty chairs at empty tables
Now my friends are dead and gone.
Here they talked of revolution.
Here it was they lit the flame.
Here they sang about tomorrow
And tomorrow never came.
From the table in the corner
They could see a world reborn
And ... 阅读全帖
v*****r
发帖数: 1119
39
check the target regular table columns definition with the external table
columns/fields definition. Make sure the load source (external table)
columns length are the same or less than the load target table columns
definition.
The error you got is saying one field in the rejected row in external table
is larger than the corresponding column in the target regular table.
s**m
发帖数: 1564
40
This is about extended property.
Here is background: when a table/column is created/altered/dropped, extended
properties are inserted/updated/deleted. also table's/column's extended
property can be updated later (not via alter table/column syntax) using
below system procedures (or raw insert/update/delete scripts):
sp_addextendedproperty
sp_updateextendedproperty
sp_dropextendedproperty
Here is my goal: now when an extended property is created/updated/dropped, I
want to fire a trigge... 阅读全帖
e**p
发帖数: 4259
41
【 以下文字转载自 Statistics 讨论区 】
发信人: eucp (Inner peace), 信区: Statistics
标 题: 有用excel pivot table和lookup table的么?
发信站: BBS 未名空间站 (Thu Mar 27 01:52:56 2014, 美东)
刚刚自学学会用excel pivot table,但复杂一些功能不会,比如说我建立一个look-up
table,大概是这样的
COUNT Label
AA AUSTRIA Austria
AA BELGIUM Belgium
AA BULGARIA Bulgaria
AA CZECH Czech
AA DENMARK Denmark
AA FINLAND Finland
AA FRANCE France
.....
.....
我要跟另外一个table 联系起来
CTRY AREA UNITS
AA AUSTRALIA ASIA/... 阅读全帖
l******9
发帖数: 579
42
need to copy a table into a new table on SQL server 2008. Also, add a new
column into the new table.
The values of the new column depends on the compare result between the new
table and another table.
Example,
Table1:
col1 col2 col3
abc 346 6546
hth 549 974
Table1_new:
col1 col2 col3 col4
abc 346 6546 1
hth 549 974 0
Table2:
col1
abc
sfsdf
If Table2's col1 appear in Table1 col1, mark col4 as 1 in Table1_new, el... 阅读全帖
l******9
发帖数: 579
43
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL fast search in a 10 million records table
发信站: BBS 未名空间站 (Thu Jul 24 23:26:56 2014, 美东)
I need to do a fast search in a column with floating point numbers in a
table of SQL server 2008 R2 on Win 7.
the table has 10 million records.
e.g.
Id value
532 937598.32421
873 501223.3452
741 9797327.231
ID is primary key, I need o do a search on "value" column for a given value
such that I can find the 5 closest... 阅读全帖
l******9
发帖数: 579
44
【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: create table on SQL server from python pyodbc
发信站: BBS 未名空间站 (Fri Aug 1 13:19:15 2014, 美东)
am trying to access SQL server 2008 R2 from Eclipse pydev ( python 3.2 ) on
win7 .
I need to create a table on database.
The code can be run well. But, I cannot create tables in the database. If I
print the sql string and run the query from SQL server management studio, no
problems.
import pyodbc
sql_strc = " IF OBJECT_ID('[my_db].[dbo].[my_t... 阅读全帖
l******9
发帖数: 579
45
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖
s******e
发帖数: 493
46
来自主题: Java版 - entity bean class for joint table
Got to write entity beans. must use them due to the politics even they suck.
Also the db schema is quite complicated due to the history and some wierd
requirements. It cannot be cahnged :-)
My question is about joint table(maybe it shouldn't be called joint table).
for example, table A has many-many relationship with table B, a joint table
mapping this relationship also has a column to specify the relation type,
which is many-one to the relation type table.
1. Must I have a bean class for the jo
b******e
发帖数: 1861
47
table 2 is denormalized.
Table 1 (A) A is primary key
Table 2 (A, B, C, V), A, B, C is primary key. A is foreign key to Table
1(A), Table 1 to Table 2 is one to many relation
The classes are like below.
Class 1
{
A;
Set
}
Class2
{
Class1 c1;
B;
Set sets;
}
Class3
{
Class2 c2;
C;
V;
}
How can I config the mapping for class1 and class2 and class3 and make
hibernate not to do a separate insert/update for class2 when persistence
class 1 but to insert/update c... 阅读全帖
l******9
发帖数: 579
48
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL fast search in a 10 million records table
发信站: BBS 未名空间站 (Thu Jul 24 23:26:56 2014, 美东)
I need to do a fast search in a column with floating point numbers in a
table of SQL server 2008 R2 on Win 7.
the table has 10 million records.
e.g.
Id value
532 937598.32421
873 501223.3452
741 9797327.231
ID is primary key, I need o do a search on "value" column for a given value
such that I can find the 5 closest... 阅读全帖
l******9
发帖数: 579
49
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖
l******9
发帖数: 579
50
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖
1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)