|
k********o
发帖数: 236 | 2 【 以下文字转载自 JobMarket 讨论区 】
发信人: kittyhello (HelloKitty), 信区: JobMarket
标 题: Sr. SQL Data Developer with Python
发信站: BBS 未名空间站 (Thu Jan 3 15:11:03 2019, 美东)
Financial client in NYC
Experience: 5+ years large data process and analysis experience using SQL.
Knowledge and Skills Required: Very strong in SQL, proficient in Python,
primary database is Sybase. Familiar with JSON, Unix, Bash Script. Java
experience is optional.
Hands on experience in processing and analyzing large scale Dataset. Hands... 阅读全帖 |
|
t*****e
发帖数: 1700 | 3 我用sql server做一些简单的sql查询。现在我有一个独立的memberID 列表（来自于其
他地方），我怎么查询一些这些memberID在sql server table里的信息呢?
如果只有一个，两个memberID，我可以用where clause,但是这个列表很长，where不可
能解决。
谁来指点两下 |
|
g*s
发帖数: 2277 | 4 1.把MEMBERID LIST COPY到EXCEL COLUMN A
2.在EXCEL B1 CELL，用EXCEL CONCATENATE FUNCTION写好针对A1一个MEMBERID的query
3.把B1的query拷到COLUMN B下面各行
4.把COLUMN B拷到EDITOR，存成1 个 SQL文件
5.在SQL SERVER上RUN这个SQL
6.要是要结果看起来象一个语句运行出来的话，用grep把结果行选出来。
link |
|
A*********u
发帖数: 8976 | 5 把你的列表作成一个local table
select a.memberid as amemberid, b.memberid as bmemberid,
whateverothervariable
from localtable as a, servertable as b
where a.memberid=b.memberid
我用sql server做一些简单的sql查询。现在我有一个独立的memberID 列表（来自于其
他地方），我怎么查询一些这些memberID在sql server table里的信息呢?
如果只有一个，两个memberID，我可以用where clause,但是这个列表很长，where不可
能解决。
谁来指点两下 |
|
s**********o
发帖数: 14359 | 6 【 以下文字转载自 DotNet 讨论区 】
发信人: smallburrito (smallburrito), 信区: DotNet
标 题: 免费讲座：SQL Server技术交流系列Data Warehouse入门07/25 周(转载)
发信站: BBS 未名空间站 (Wed Jul 25 19:05:01 2012, 美东)
发信人: smallburrito (smallburrito), 信区: Programming
标 题: 免费讲座：SQL Server技术交流系列Data Warehouse入门07/25 周三9PM EST
发信站: BBS 未名空间站 (Wed Jul 25 19:04:36 2012, 美东)
GOOGLE GROUP【CINASSUG】【CINAOUG】
SQL Server技术交流系列
1. Data Warehouse modeling and lifecycle, data vault, kimball and Inmon
by James Yang
07/25 周三9PM EST
http://www.anymeeting.co... 阅读全帖 |
|
h****n
发帖数: 298 | 7 SQL Developer
I am looking for a developer with lots of experience developing high
transaction, OLTP systems. I am less interested in people who have lots of
experience developing reporting systems (DTS, SSIS, etc.)
I am looking for a seasoned developer who has at least 5 years’ experience
with SQL Server. Of that, I am expecting to see someone with at least 2+
years’ experience with SQL Server 2005 or 2008. This is bare bones
experience. I am expecting much more than this. Experience at M |
|
j********r
发帖数: 96 | 8 We are seeking candidates with very current, very solid Networking & SQL
skills for a W2 contract position that will last for a year or more.
If interested contact: J**[email protected]
Pay Rate: $30 per hour + benfits(medical, dental, vision, 401k)
We have interview times set up for qualified candidates for next Wednesday,
February 2nd, so if you are interested contact us asap.
Candidates MUST have:
- Enterprise / large Network experience
- Very solid SQL knowlege and experience
- Very solid and... 阅读全帖 |
|
h****n
发帖数: 298 | 9 SDET Role: - this one is more SQL focused, because this is primarily a
database application
3+ years of previous Test\SDET experience.
Ability to clearly communicate concerns about code and collaborate with devs
and PMs to effectively solve software challenges
High level of personal accountability and “self-starter” attitude in order
to make progress in ambiguous situations
Capability to problem solve by not only identifying bugs, but also narrowing
down the list of bugs to identify the root of ... 阅读全帖 |
|
h****n
发帖数: 298 | 10 1. 5+ years’ of proven experience on database design and architecture at
the enterprise scale
2. Strong experience in Writing complex T-SQL and Stored procedures
3. Indexing strategies & tuning
4. Ability to analyze performance issues in an OLTP system and efficiency in
solving complex problems, ability to experiment different methodologies.
5. Proven knowledge of Performance tuning and scaling up database
6. Concurrency, blocking and contention handling in OLTP system
7. Deep knowledge of SQL i... 阅读全帖 |
|
S*******h
发帖数: 7021 | 11 This is a full-time position located in Redmond, WA. Send a copy of your resume in .txt to my mitbbs email if you are interested in.
SQL server Solutions Engineer
Qualifications
Education and Experience:
•Bachelor's or Master's degree in Computer Science, Information
Systems, or equivalent
•Minimum 4-6 years experience
Knowledge and Skills:
•Expertise in Windows, SQL Server and hardware (servers, storage,
networking).
•Strong analytical and problem solving skills.
•... 阅读全帖 |
|
|
m********u
发帖数: 3942 | 13 地点Redmond，感兴趣可以站内或者邮件 [email protected]
We are looking for a strong engineer who is passionate about working on Data
and is expected to:
• Design systems to store and process data in a way that can be used
by applications, people and BI systems using Azure Managed Services.
• Make architectural and technical decisions; architect the Data v2
platform.
• Implement the data transformation jobs using latest Azure
technologies.
• Innovate on tools and processes that simpl... 阅读全帖 |
|
W***Z
发帖数: 9 | 14 【 以下文字转载自 JobMarket 讨论区 】
发信人: WYXNZ (婉约小娘子), 信区: JobMarket
标 题: 求好心人refer 工作： B2B,EDI,SQL,webMethods 相关
发信站: BBS 未名空间站 (Fri Mar 21 13:02:00 2014, 美东)
听闻贵版好心人多，求好心人refer 工作： B2B,EDI,SQL,webMethods 相关，先谢过哈
，最好是在 Houston
先介绍下我的背景哈，计算机相关专业本科，有近七年工作经验，有身份，对一下领域
非常专业和熟悉
1.develop in webMethods platform
2.data format: EDI,XML,cXML,IDOC
3.Database: SQL,Oracle
4.Protocal: FTP, AS2(HTTP/HTTPS)
5.Logistic process folow, order process flow
非常感激~ |
|
d****0
发帖数: 263 | 15 7294: SQL Database Support Technician
Employment Type Full Time/Regular
Location VA - Alexandria
Job Description & Responsibilities
Description:
This is a database administration/troubleshooting position rather than a
developer position. Person will have to learn VSE’s agile development
platform, SQLDBI from Chainbridge Technologies, thoroughly and be able
to support a large suite of solutions in production and coming to
production down the road. Person will have to be able to docume... 阅读全帖 |
|
|
b*******s
发帖数: 636 | 17 我来说说吧。这4个里面我用3个，Transact SQL没用过，不过SQL我用过一段时间。
Java 和 c# 其实相似之处很多，目前Java的人多好几倍，不过我还是更喜欢C#。java
主要是起步早，另外跨平台的确做的更好一些。不过这两个如果没有基础还是比较难入
手的。搞熟了的话应该可以找到相应的工作吧。
如果什么基础都没有，transact sql 应该相对比较容易，虽然我自己不会。但是你学
这个没前途，数据结构什么的不明白，找不到工作的。开始还要搞数据库的一些基本概
念也挺麻烦的。
容易程度上VB也比较简单，可惜随着被微软摒弃，VB已经大势已去。vb我是从vb for
dos开始用的，一路下来，可惜后来的VB.net跟传统的VB差十万八千里，所以我直接改C
#了。过去用vb的人转vb.net的也不是很多，所以vb.net没什么前途了。
不是要打击你啊，码工没前途，吃青春饭的，所以实质上跟部分妇女从事的特殊行业很
相似啊。而且虽然入手不是很难，没有一点基础的话也不是那么简单，尤其是自学。 |
|
m**a
发帖数: 119 | 18 【 以下文字转载自 Database 讨论区,原文如下 】
发信人: mula (mumu叫的牛蛙), 信区: Database
标 题: sql server
发信站: Unknown Space - 未名空间 (Wed Nov 3 16:21:51 2004) WWW-POST
what's the difference between the following two? What's MSDE?
Microsoft SQL Server 2000 Service Pack 1 Desktop Engine (MSDE) 1.0
Microsoft SQL Server 2000 Service Pack 1 Database Components 1.0 |
|
o***g
发帖数: 2784 | 19 你的.sql文件里面是啥？
如果都是sql语句的话，就是文本文件，用编辑器打开，分开就好了
不会2.6M就一条sql语句吧
spl |
|
q****g
发帖数: 12 | 20 我用jdbc操作 sql server下的 database时，
遇到一个奇怪的现象：比如说一个简单的语句：
SELECT id, attr
INTO tempTB
FROM TB
WHERE (...)
ORDER BY attr
返回的tempTB 有的时候根本不是按照attr排序的，
确切地说，只是部分排序。比如说如果数据范围[1，1000]，
输出的结果可能是 992 993,...1000, 876，877，878，。。
我多run几次，有时候又能输出正确排序后的结果。
有人遇到过这种情况么？到底怎么回事啊？
难道是sql server安装有问题？
但是我的机器刚刚重装过，以前用这个sql server的安装文件
也装过，从来没有碰到过这种问题。 |
|
s****h
发帖数: 3979 | 21 After installing Microsoft SQL Server 2005 for developer, I can't find SQL
Server Management Studio.
Actually, the only item under "Microsoft SQL Server 2005" is "configuration
tools"
What's the matter? |
|
s****e
发帖数: 1180 | 22 借宝地问个面试中的sql的问题。
We have two tables, students (student ID, student name, student age, student
zip) and courses (course name, course time) .
The information in the parentheses are the schema.
We want to get how many students enroll all the classes starting at 11:00 AM?
the interviewer mentioned something like many to many join.
the interviewer mentioned something like "dimensionalize" in SQL. I am
wondering who knows any SQL book on this, and can introduce it me?
Thank you so much for your consi... 阅读全帖 |
|
s****e
发帖数: 1180 | 23 借宝地问个面试中的sql的问题。
We have two tables, students (student ID, student name, student age, student
zip) and courses (course name, course time) .
The information in the parentheses are the schema.
We want to get how many students enroll all the classes starting at 11:00 AM?
the interviewer mentioned something like many to many join.
the interviewer mentioned something like "dimensionalize" in SQL. I am
wondering who knows any SQL book on this, and can introduce it me?
Thank you so much for your consi... 阅读全帖 |
|
o****n
发帖数: 72 | 24 1. SQL Talk
2. SQL Plus
3. SQL Navigator
Any particular reasons? |
|
l***u
发帖数: 157 | 25 Dynamic SQL Format 1 statement
Description
Use this format to execute a SQL statement that does not produce a result set and does not require input parameters. You can use this format to execute all forms of Data Definition Language (DDL).
Syntax
EXECUTE IMMEDIATE SQLStatement {USING TransactionObject} ;
Parameter Description
SQLStatement A string containing a valid SQL statement. The string can be a string constant or a PowerBuilder variable preceded by a colon (such as :my |
|
l*****y
发帖数: 8 | 26 I know there is a MS SQL server 6.5.
anybody can tell me whether there is SQL 4.0 or SQL 4.5 exist?
thanks |
|
h*****l
发帖数: 184 | 27 【 以下文字转载自 Software 讨论区,原文如下 】
发信人: hanibal (ganggang), 信区: Software
标 题: Re: SQL下如何转移tempdb
发信站: The unknown SPACE (Tue May 2 17:31:56 2000) WWW-POST
In SQL Server 7, tempdb is the only database that you can
move using the
ALTER DATABASE command:
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'tempdev', Filename = 'newpath/tempdb.mdf)
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'templog', Filename = 'newpath/templog.ldf)
The changes will not take effect until the SQL Server is
restarted. |
|
d**i
发帖数: 83 | 28 Hi, everyone
I am learning sql/plus programming, can you tell me some books good for
programmer or some tutorials online? actually, i am quite familiar with sql,
but i find out oracle add lots of commands and functions in sql/plus. |
|
h****r
发帖数: 2056 | 29 Try to use batch SQL like
"begin
insert into table1 values('0', 0);
insert into table1 values('1', 1);
end /"
it works fine in SQLPLUS as a SQL statment,
but use it in ODBC programming it will not works fine,
any shrimps has experiences on it, please share your
idea, thanks a lot. |
|
c********x
发帖数: 93 | 30 我以前在java下用mysql jdbc存取mysql
现在我想把数据库从mysql换成sql server 2000
除了需要把mysql jdbc换成sql server jdbc,
还需要改动从前的代码吗？
我指的是那些insert, delete, select等sql语句。
谢谢先！ |
|
y**t
发帖数: 13 | 31 I'm installing SQL server2000 on my machine. Everything goes ok, untill the
last "Finish" button. But after that nothing happens, I checked the "start->
Programm", there is no SQL server there, and I go to control panel, Add/Remove
Programms, to check there is also no SQL server there. What's wrong?
I used "Advanced options"->"Server and Client Tools"->"Default"->"Custom"->
"Customize the settings for each service"->"Mixed
Mode"->"MultiProtocwl"->"Licensing Mode/Per Seat for 30 devices"-""Fisish |
|
y***e
发帖数: 39 | 32 To register SQL Server B in Enterprise Manager, right click "SQL Server Group"
and click "Register Sql Server..." (cannot remember exact name.)
To back up the database, an easy way is use stored procedures:
sp_dttach_db [dbname]
sp_attach_db [dbname] [filename]
if you don't have active connection on A, you can just find the [dbname].MDF
file and copy it to server A and use sp_attach_db directly. This skips the log
file of course. For details, check out these two commands in Books Online.
Another |
|
m**h
发帖数: 22 | 33 asp运行正常
sql server 运行正常
在ODBC Driver里设置了File DSN, 产生了一个名字叫sqlserver.dsn 的文件
运行下面这段code:
<%
'Create a connection object
Set cn = Server.CreateObject("ADODB.Connection")
'Open a connection; the string refers to the DSN
cn.Open "FILEDSN=sqlserver.dsn"
%>
出错信息如下:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'xxx\IUSR_xxx' 登录失败。//(xxx is the server name)
/myweb/testasp.asp, line 13
Any idea? thanks |
|
p*p
发帖数: 80 | 34 You can restore the backup file of SQL 7 directly into SQL 2000, no problem.
2000 |
|
k******r
发帖数: 2300 | 35 When I tried to uninstall the SQL server 7.0, I was told sqlservr.exe is in
use. But I couldn't delete the sqlservr.exe from Task manager. Actually, I
have closed all the applications when I uninstalled the SQL server. I wonder
what is the proper way to uninstall the SQL server under Win2000. Any idea to
do the trick? Thanks so much! |
|
g********r
发帖数: 187 | 36 Oracle8.X doesn't allow dash '-' in its SQL request. I need to do some minus
operation in SQL, how to write the SQL?
Thank you. |
|
d****t
发帖数: 362 | 37 For your sugguestion.
I am starting working on a online business project, which is supposed to
support all kinds of International features. MS Visual Studio.net and SQL
Server are techniques to be used. The VS.net has International support
built-in. But I am not sure if the English version of SQL Server will have
problem to have international features, such as non-English characters, and
locale date-time formats etc. Based on my knowledge, the English version of
SQL server will not support, say |
|
p***n
发帖数: 635 | 38 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: payan (沛岩), 信区: Java
标 题: MS SQL Server JDBC Driver Problem
发信站: Unknown Space (Sun Aug 17 02:35:53 2003) WWW-POST
I am using MS SQL SERVER JDBC DRIVER under Weblogic 7 to call an MS SQL Server
stored procedure. The stored procedure returns a xml string like this:
...
...
...
so far so good.
the problem comes up when there is some characters like "'" is contained in
the string, e.g.,
Let's go and have fun
Then the SP c |
|
a***d
发帖数: 3 | 39 Code
strcpy(s, "SELECT * FROM ");
strcat(s, exp_name);
EXEC SQL PREPARE q FROM :s;
EXEC SQL EXECUTE q ;
Error
sql error Too few arguments in line 62.
不明白呀，有什么好办法把table的名字很好的放进query里吗？
用using的话带引号，很烦人
thanks in advance :) |
|
c**t
发帖数: 2744 | 40 Using sp.
exec desiredsql tbname
declare sql varchar(255)
..
set @sql='select * from ' + @tbname
execute (@sql)
.. |
|
j******t
发帖数: 11 | 41 【 以下文字转载自 Statistics 讨论区,原文如下 】
发信人: jackycat (黄小幺), 信区: Statistics
标 题: question about SQL in Access
发信站: Unknown Space - 未名空间 (Thu Sep 2 09:31:38 2004) WWW-POST
How can I write some SQL queries in Access? Under "Queries"? I only see two
options there: 1. Create query in Design view; 2. Create query by using
wizard. None of them leads to some place where I can write SQL. Any help
will be appreciated. |
|
y*l
发帖数: 334 | 42 刚完成安装，想启动SQL Query Analyzer, 结果说SQL SERVER does not exsit or
access denied. 同时发现SQL server 服务管理器：the service did not start due
to a log failure.从没用过此等软件，高手见笑了。多谢一切指点。 |
|
s****r
发帖数: 36 | 43 How does a Java application insert data into SQL server?
Can Java application talk to SQL Server directly via JDBC? If Yes, is JDBC
Driver included in SQL Server package?
Thanks for help! |
|
a*******t
发帖数: 891 | 44 after some headache, I found there are at least two strange (or by design)
behaviors in FoxPro.
1. the following statement runs in FoxPro, but not in SQL Server
select ID, sum(charges), invoiceDate
from tableA
group by ID
what FoxPro does is execute this as max(invoiceDate), while SQL Server refuses
to run the statement unless I put in the "max".
2. this statement runs in both FP and SQL Server, but with different results.
select ID, invoiceDate
from tableA
where ID not in (select ID from tableA |
|
l*******b
发帖数: 1 | 45 【 以下文字转载自 JobHunting 讨论区,原文如下 】
发信人: lokforjob (工作寻找中), 信区: JobHunting
标 题: strong SQL skills?
发信站: Unknown Space - 未名空间 (Wed Jun 8 15:40:50 2005) WWW-POST
后天要去面试一个职位，要求strong SQL skills。虽然用过ｓｑｌ，但是对这个strong
SQL skills还是有点捉摸不透，到底这个ｓｔｒｏｎｇ，说的是在什么方面要很强？都需
要注意哪些方面，ｓｑｌ牛人多指点指点。谢谢！ |
|
s*******e
发帖数: 76 | 46 thanks,how about sql anywhere?
is SQL Advantage a subset of SQL anywhere |
|
M*****r
发帖数: 1536 | 47 In SQL Server 2K5, schema is introduced.
Any comparison to Oracle's schema?
SQL Server 2K5:
Server
Database
Schema
Login -- User account
Oracle:
Server
Database
Schema -- User account
What's the benefit of adding the schema layer? Why it is not designed like
Oracle's? (I may have some mis-understanding for the concept)
Also, in SQL Server, login and user account are different? What the benefit? |
|
q****g
发帖数: 12 | 48 我用jdbc操作 sql server下的 database时，
遇到一个奇怪的现象：比如说一个简单的语句：
SELECT id, attr
INTO tempTB
FROM TB
WHERE (...)
ORDER BY attr
返回的tempTB 有的时候根本不是按照attr排序的，
确切地说，只是部分排序。比如说如果数据范围[1，1000]，
输出的结果可能是 992 993,...1000, 876，877，878，。。
我多run几次，有时候又能输出正确排序后的结果。
有人遇到过这种情况么？到底怎么回事啊？
难道是sql server安装有问题？
但是我的机器刚刚重装过，以前用这个sql server的安装文件
也装过，从来没有碰到过这种问题。 |
|
m*******s
发帖数: 9 | 49 想学SQL, 请教几个基本问题, 谢谢指教.
1)MySQL 和Microsoft SQL Server 是一回事吗?
2)在Visual Studio 2005 里能编译SQL 吗?
3)一般需要装哪些软件. |
|
b*h
发帖数: 353 | 50 我的机器是 XP HOME EDITION 的， 请问微软的 SQL SERVER 2005可以装在上面吗，
还是要求 PROFESSIONAL XP？
另外我在它的网站上看到 “Microsoft SQL Server 2005 Express Edition”和 “SQL
Server Management Studio Express”， 我应该装哪个？还是两个都要安装？
多谢了。 |
|
