d**********3
发帖数: 1186 | 1 Hello All Community Members,
Coming back from SQL PASS 2014 Summit, I really enjoyed the summit to meet
so many new and old friens and I do feel proud to be a member in this
community. Also, your feedback and suggestion always motivate us to build a
better community to serve back to you and many other people.
For the year of 2014, we have had 9 times monthly meeting and technical
sharing sessions so far.(Will have 1 or 2 in the remaining months) and Book
Club Activity was kicked off starting fro... 阅读全帖 |
|
d**********3
发帖数: 1186 | 2 【 以下文字转载自 TransferToCS 俱乐部 】
发信人: derekdai1213 (derek.dai), 信区: TransferToCS
标 题: 免费讲座SQL Server CDC
发信站: BBS 未名空间站 (Mon Feb 23 22:57:25 2015, 美东)
Please register for SQL PASS Chinese Monthly Meeting for Mar 2015， SQL
Server CDC on Mar 3, 2015 7:30 PM CST at:
https://attendee.gotowebinar.com/register/5867817944757950209
SQL Server CDC
After registering, you will receive a confirmation email containing
information about joining the webinar.
PASS Community |
|
j*****n
发帖数: 1781 | 3 【 以下文字转载自 Database 讨论区 】
发信人: jackrun (Michael Jackson is dead :((), 信区: Database
标 题: 招工：SQL Server developer w. SSIS
发信站: BBS 未名空间站 (Thu Oct 1 23:00:50 2009, 美东)
Our Company needs a SQL Server Developer, H1 sponsorship is possible.
Junior to Middle level.
SQL Server 2005/2008, 2+ years exp. Best to have Data warehouse experience,
we have 5TB+ data and it is growing very fast.
Minimum 1 year SSIS experience required.
SSRS/SSAS are plus.
You must be a multitask person can handle some stress.
O |
|
y*******g
发帖数: 6599 | 4 一个table中的key是auto increment, 从1到十万
随机删除一 row
要求写出sql语句找出被删的row的key
不用sql的话是老题目了,把数字加起来或者xor什么就好了.
用sql还能做这个么? 要怎么写?
谢谢 |
|
a******5
发帖数: 199 | 5 Is this T-SQL of SQL Server or just ANSI-SQL?
I've never seen the syntax before. |
|
s******f
发帖数: 3984 | 6 EE毕业，完全不会SQL。最近面试屡屡在这上面受挫。虽然知道SQL的基本语句和简单，
但是从来没有在实际的地方练过手，不知道大家是怎么学习应用的SQL？谢谢，最佳答
案有包子。 |
|
s**********e
发帖数: 63 | 7 *Solved in SAS;
*Q1;
proc sql;
title1 "ID with average salary"
title2 ">department average";
select id, sal, avg(sal) as avgsalary format=dollar11.2;
from emp
group by department
having sal>avg(sal);
order by id;
quit;
*Q2;
proc sql;
create table lists as select vendor_id, count(good_id) as list from table1
group by vendor_id
quit;
proc sql;
select vendor_id from lists where list>(select list from lists where vendor_
id=002);
quit; |
|
r***8
发帖数: 86 | 8 朋友公司在招聘SQL SERVER DBA，需要懂 .NET 开发
上市公司，福利很好，必须有三年以上经验，
有意请发RESUME 到r********[email protected]
an international media company with market-leading businesses in education
is seeking a Database Administrator for the team located in NJ office.
Extensive hands-on VLDB experience in MS SQL Server 2005 and/or 2008 is
required.
The ideal candidate will have worked as part of a team on large-scale .NET
applications. Candidate will be responsible for performance monitoring,
tuning, and daily support of a miss... 阅读全帖 |
|
e****y
发帖数: 271 | 9 【 以下文字转载自 Database 讨论区 】
发信人: eulogy (eulogy), 信区: Database
标 题: SQL Server 2012什么时候会开始流行？
发信站: BBS 未名空间站 (Tue Jul 17 17:47:33 2012, 美东)
刚在学SQL Server 2008 Essential Training
发现学校的MSDN里面已经有2012版下载了
不知道有没有必要下载下来试用？
MS已经开始有2012版的考试了：
MCSA exam461+462+463
http://www.microsoft.com/learning/en/us/certification/cert-sql- |
|
i***0
发帖数: 8469 | 10 Our healthcare client has 4 openings for .Net Developers that have strong
back-end skills in SQL. These are all 1 year contracts working on an
explanation of benefits/payments projects. Our client is ready to hire today
! The requirements are below, please let me know if I can tell you about
this in more detail!
Technical Experience:
Understanding of the software development life-cycle
Ability to collaborate and work within a Development Team, as well as
operate independently
Ability to work eff... 阅读全帖 |
|
y*****8
发帖数: 6 | 11 别……我就想问这咋面啊……
Java or SQL 选一个，对自己算法没信心才选的SQL |
|
c********t
发帖数: 5706 | 12 哈哈。PL SQL还是纯sql?
language |
|
m******y
发帖数: 588 | 13 Our group has openings for 2 Senior SQL Server Database Engineers and 1
Junior position. If you are interested, please contact m******[email protected]
Primary Responsibilities:
•Create databases from the ground up. Determine business requirements
, create logical models, build physical models and plan system architecture.
•Work with software engineers and data engineers to ensure the
overall application design is optimal.
•Conduct design and code walkthroughs, peer reviews, and prod... 阅读全帖 |
|
s*********s
发帖数: 35 | 14 悲剧了。全程就一道SQL题。其实不外乎group by, join等等。。。
可是我就是对那些个facebook的term都不熟悉，比如说什么home load, scroll load，
什么要在news feed里放一个广告，一天能显示多少个广告。。。
总而言之我真的不知道为什么平时工作中所有SQL的问题我都能解决。。。可是面试的
时候我总像个SQL初学者。。。
这应该怎么办。。。 |
|
T*****n
发帖数: 223 | 15 【 以下文字转载自 Seattle 讨论区 】
发信人: TangMen (唐门), 信区: Seattle
标 题: Expedia Hiring for SQL Server Developer
关键字: Expedia Job Developer
发信站: BBS 未名空间站 (Thu Feb 27 19:07:22 2014, 美东)
Below is the job description. If interested, you can search/apply for the
position through below link or you can email me if you want a referral.
URL: http://expediajobs.com/job_search/
Search Job by ID: 27785
Responsibilities include:
•Performing logical and physical data modeling.
•Assessing business rules.
... 阅读全帖 |
|
s****e
发帖数: 1180 | 16 借宝地问个面试中的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... 阅读全帖 |
|
l*********u
发帖数: 19053 | 17 【 以下文字转载自 Working 讨论区 】
发信人: mirthcyy (百无聊赖), 信区: Working
标 题: Hiring SQL SERVER developers
发信站: BBS 未名空间站 (Wed Mar 5 19:12:38 2014, 美东)
hello,
We have 5 openings for SQL SERVER developers.
2 Database Engineers
2 Sr. Database Engineers
1 Database Architect
All the positions requires working experiences on SQL Server. Database
Modeling/design on OLTP system is a must. Procifient in writing stored
procedure, functions, triggers etc. Good at performance tuning. SSIS and
SSRS are a plus.
Positions... 阅读全帖 |
|
p***0
发帖数: 233 | 18 因为太弱了所以面试官都没接着问，火急火燎地敷衍了我一下半小时不到就挂电话了。。
估计十分失望。。
这个职位在data&analytics部门下不是sde所以主要考sql，面试官说sde部门的会主要
关注python。
电话打过来先问了为什么喜欢fb，接着马上on-line coding, 原题如下：
survey_log (uid, action, question_id, answer_id, q_num, timestamp)
action = 'show', 'answer', 'skip'
answer_id = when action=answer, null for skip and show
q_num is the numeral/order of the question in the session
uid, eventtype, quid, aid, qorder, timestamp
5, 'show', 285, null, 1, 141425411
5, 'answer', 285, 124124, 1, ... 阅读全帖 |
|
|
s*******1
发帖数: 343 | 20 将来想从事比较稳定的工作，想往dba方面转，但是一般都是做开发很多年经验的人内
部转。所以想从pl/sql dev着手开始找工作。
本人master,明年春季想做intern.现在的学生都是在刷题,找工作。尤其是java/pathon
。自己并不想从事java搬运工的工作。感觉发展前途有限。加之自己是大龄学生，31岁
。想找个有发展空间，并且相对稳定的工作。
但是不确定pl/sql对于没有经验的人，入门难不难。感觉找intern的话，刷题找个java
码工，还是不算特别特别难。pl/sql找intern形势会怎样呢？ |
|
l******9
发帖数: 579 | 21 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: error run SQL query from pyodbc python 3.2.5
发信站: BBS 未名空间站 (Thu Jun 19 12:04:26 2014, 美东)
I am working on pyodbc in Eclipse (4.3.2v20140221-1852) with PyDev on Win 7.
My python is 3.2.5.
At my code:
cursor.execute("select top " + str(1) + " a.my_id, a.mycode" +
"from my_table as a where a.mycode = ?", aGivenCode)
I got an error :
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server
Driver]
[SQL Ser... 阅读全帖 |
|
l******9
发帖数: 579 | 22 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: run SQL stored procedure from python
发信站: BBS 未名空间站 (Sat Aug 2 20:53:01 2014, 美东)
I need to run a SQL server 2008 R2 stored procedure from Eclipse pydev with
python 3.2 on win 7. If I run the stored procedure from management studio,
it works well.
But, if I run it from ptython , it does not work.
sql_str_test = """
DELETE FROM [my_db].[dbo].[my_table] -- this line works
EXEC [my_db].[dbo].[m... 阅读全帖 |
|
f********i
发帖数: 546 | 23 请问该用什么教材？
有什么课程？
看了一下http://www.w3school.com.cn/sql/ ， 一天就看完了，难道就这么点内容吗？
初学者不知道下一步学习的方向了
另外，是不是要学习一下SQL 的软件呢？ 比如MYSQL, SQL SERVER, ORACLE 等等，该
学哪一个？
lz目的是找金融方面的公司做数据分析方面的工作。
谢谢！！！
另外，宣传培训班的请绕道，lz打算自学，不报培训班。 |
|
D*********d
发帖数: 125 | 24 《Microsoft SQL Server 2012 T-SQL Fundamentals》当年看过老版的，难易度对于你
应该合适。最好结合sql server边看边玩。 |
|
l******9
发帖数: 579 | 25 【 以下文字转载自 Programming 讨论区 】
发信人: light009 (light009), 信区: Programming
标 题: check time table created in IBM SQL Aginity workbench ?
发信站: BBS 未名空间站 (Fri Oct 31 18:37:40 2014, 美东)
My question may be simple, but, I have been searching the answer for a long
time.
How to check the data and time that a table was created in IBM Netezza SQL
from Aginity workbench ?
It is very easy to find this in MS SQL server, but, I cannot figure this out
in Netezza.
Any help would be appreciated.
thanks ! |
|
l******9
发帖数: 579 | 26 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'
ESCAPECHAR ''
)
AS
SELECT *
FROM admin.my_table
I logged in as admin in the database. But, I got error:
Exception captured: System.Data.Odbc.OdbcExce... 阅读全帖 |
|
l******9
发帖数: 579 | 27 I need to so a sql query on IBM netezza sql database from Aginity workbench
on win7.
My query:
SELECT *
from table1 AS c ,
table2 AS b
where CAST(c.id as int) = b.id
in table1, id is character varying(20) and in table2, id is int.
Table1:
id value1 value2
'985' 'casdqwdc' '654.3184' // they are all char
Table2:
id value1
985 694381 // id is int, value1 is int
I got error:
ERROR [HY000] ERROR: pg_atoi: error in "id": can't parse "id"
Any help would be apprec... 阅读全帖 |
|
l******9
发帖数: 579 | 28 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: pypyodbc error access netezza SQL server on win7
发信站: BBS 未名空间站 (Sun Dec 21 10:15:22 2014, 美东)
I need to access IBM netezza SQL database from python on win 7. I have
installed Eclipse and python 3.2, pydev, and pypyodbc https://pypi.python.
org/pypi/pypyodbc/1.3.3). It worked well for MS SQL server.
But, it got error for IBM netezza.
import pypyodbc
conn = pypyodbc.connect("DRIVER={NetezzaSQL};SERVER={my_server_name};
D... 阅读全帖 |
|
m*****g
发帖数: 131 | 29 准备学SQL， 考古也找到了前辈们罗列的SQL的学习资料。想问一下，有必要考个SQL的
证书什么的吗？如果是entry level找工作的话。谢谢各位大牛了！ |
|
o*****t
发帖数: 6 | 30 【 以下文字转载自 Chicago 讨论区 】
发信人: oldroot (oldroot), 信区: Chicago
标 题: 内推sql reporting analyst
发信站: BBS 未名空间站 (Mon Mar 16 20:45:35 2015, 美东)
芝加哥西北郊，mid-senior level，you should have lots of experience in sql
queries and stored procedures in Sql Server or comparable env. Good skills
in ssrs and ssis. Good knowledge in table creation and maintenance. Very
good benefits. 如果有兴趣，请站内信箱联系。 |
|
m****b
发帖数: 178 | 31 各位大神，去ICC培训两个月SQL能找到工作吗？帮朋友问的。她computer engineering
的ms毕业，有C++，python，数据结构和算法的基础，刷过leetcode简单题，但没有一
点 SQL基础。她从去年12月毕业一直到现在找工作一直不顺利。不知道她去ICC培训两
个月SQL在加州找到工作概率大不大？谢谢各位。 |
|
s**********g
发帖数: 3 | 32 请问大家有靠谱ICC推荐吗？关于SQL，Databese的？
职位面向SQL Developer, database analyst, sql server dba之类的？
为了找工作，实在没办法啊，OPT快过期了，还没找到工作，只能上ICC贼船了，起码先
找到工作把身份搞定啊，不然待不下去了。想留在美国，谢谢大家！ |
|
w***y
发帖数: 6251 | 33 我还遇到另外一个sql题，是看面经里的。也不会做 ／／汗
SQL：一个学生enrollment table，里面的数据是
studentID, courseID, grade
求每个学生的最好成绩，和对应的courseID。如果highest grade有duplicate怎么办？
这个好像涉及到对每个group进行rank，然后取top K, 也是一种常见的题目。 怎么做
呢？ 我在网上搜的答案，有的SQL支持 类似row_number() 这种function，好像mysql
是没有的，需要自己定义local variable 去做。 我想不明白有duplicate怎么处理，
是不是写一个case 来判断？ 今天现学的case statement，还有点搞不定 |
|
发帖数: 1 | 34 有了解SQL Developer的吗，做这行前景怎么样啊，难度如何？ 本人是freshman in IT
field， 想请教一下，听说这个上手容易，不过会越做越难，是这样吗。对于新人立
志于是SQL 数据库方向的有什么建议吗，如果有做SQL Developer 的来现身说法就更好
了！ 谢谢！ |
|
s**********3
发帖数: 256 | 35 【 以下文字转载自 Database 讨论区 】
发信人: sunnybird123 (Walk with the Earth Mother.), 信区: Database
标 题: SQL server DBA needed
关键字: SQL DBA
发信站: BBS 未名空间站 (Wed Sep 7 14:11:34 2016, 美东)
Mid or Senior DBA
Location: Westchester, NY
Health Care / Hospital Full time employee
Function include:
1. Database administration
2. Report development
3. SSIS, SSRS
4. Write SQL scripts, SP, functions |
|
b**********a
发帖数: 269 | 36 用的是intel nuc，系统是win 7, 32-bit，安装SQL的时候弹出This SQL Server setup
media is not supported on a X86 system, To continue, run the SQL server
setup media that matches your system.
有人遇到过这问题吗？ |
|
m********u
发帖数: 3942 | 37 地点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... 阅读全帖 |
|
T*****y
发帖数: 74 | 38 this is email I received from our SUGI Yahoo grop
Hi, all, if interested, please send your resume to d****[email protected]
(same position as posted before but revised).
SQL/Business Objects Programmer
Contract position for a SQL/Business Objects Programmer
6 months with possibility of extension; fast-paced large marketing company;
start immediately; good pay.
Location: Chantilly, VA
Responsibilities
Develop and modify complex SQL queries based on ad hoc user requests.
Become a subject m |
|
c*****0
发帖数: 3 | 39 MS SQL 2008 R2 ). Must have done lot of SSIS, EDW design on SQL Server 2008.
Candidate should live in USA. Work from home opportunity.
Developer - ETL & Data Warehouse
Seeking multiple BI / Data Warehouse Developer / Architects for a global
fortune ten technology client to work on the Microsoft BI Platform. The
candidates need to be dynamic, mature, ambitious, creative, and
autonomous
as the team is Senior Level and experienced in building ETL and data
warehouse. Main... 阅读全帖 |
|
P*******T
发帖数: 8 | 40 ----------------- NEW HIRE -----------------
Client: Major Chinese bank
Location: Midtown, Manhattan
Position: SQL Server developer (Contract position)
Responsibility:
• Develop software systems using SQL Server
• Diagnose and correct programming errors
• Work with other team members on test of software systems
• Maintain Extract/Transform/Load (ETL) routines using SSIS
• Create, maintain and develop documentation
Qualifications:
• Graduate of a University-le... 阅读全帖 |
|
m****s
发帖数: 18160 | 41 【 以下文字转载自 WashingtonDC 讨论区 】
发信人: javabear (bear kids), 信区: WashingtonDC
标 题: 招middle level .net/SQL developer
发信站: BBS 未名空间站 (Wed Oct 31 17:32:08 2012, 美东)
ASP.NET/C#/JavaScript/HTML/SQL Server, 3 yrs experience
偏重 back end, better have SQL Server Admin experience like backup/restore/
schedule job, etc.
Location: 395 交 route 7 (Alexandria VA)
Salary: 60k - 70k/yr
站内联系, if you are interested. |
|
g********s
发帖数: 3652 | 42 Our team has a long term contract position for Oracle SQL developer. The
company is a S&P 500 company and located in central NJ.
If anyone interested, please send your resume to me , and I can forward to
hire manager.
Job Requirements/Education:
Bachelor's degree in a computer science or related field is required.
Minimum of 5 years development experience with Oracle databases. Experience
and expertise with Oracle and relational database concepts is required.
Proficiency with advanced SQL PL SQL... 阅读全帖 |
|
发帖数: 1 | 43 Need SQL Server DBA.
SQL Server DBA Position Description - The position is supporting client
based applications running within an IaaS/SaaS cloud environment. - You will
be performing analysis and development for the databases supporting these
systems, as well as supporting team members for application and systems
support. - Applications are running in a variety of states and support is
needed for replication, back up and restoration of data across
geographically disperse locations. This include... 阅读全帖 |
|
h**k
发帖数: 662 | 44 要把一个access里的sql 转化到sql server.
在access
select tbl.field1 as field1x, "" as field2x into newtable.....
"" as field2x 部分怎么在SQL Server里面实现那？ |
|
j*****n
发帖数: 1781 | 45 【 以下文字转载自 Database 讨论区 】
发信人: jackrun (Michael Jackson is dead :((), 信区: Database
标 题: 招工：SQL Server developer w. SSIS
发信站: BBS 未名空间站 (Thu Oct 1 23:00:50 2009, 美东)
Our Company needs a SQL Server Developer, H1 sponsorship is possible.
Junior to Middle level.
SQL Server 2005/2008, 2+ years exp. Best to have Data warehouse experience,
we have 5TB+ data and it is growing very fast.
Minimum 1 year SSIS experience required.
SSRS/SSAS are plus.
You must be a multitask person can handle some stress.
O |
|
|
t*******e
发帖数: 684 | 47 楼主其实说得很对，关系型数据库还是需求量最大，70 年代到现在40 年了，还会继续
个50年，传统BI也是基于sql的。现在都是被大数据忽悠的，都想进大 IT公司赚大钱。
大数据是从SQL进化和退化出来的，没有SQL的基础，干好大数据很难。 |
|
l*****n
发帖数: 608 | 48 貌似没有这个协会，而且举办者也不是arizona的
我收到这个邮件之后和他们重新确认了，这个是一个网络培训的活动。在他们之前举办
的活动里面，要求参加者捐赠一定数额之后才能收到他们发给的材料（pdf和视频）
他们后来给我的邮件里面解释说，F2和F1学生可以免费参加，不需要交钱或者强制的捐
赠；H4的没有提到。我的理解是，他们是一个商业培训组织，希望通过一两次免费的培
训增加自己的知名度，但是并不是一个志愿者组织，也不是AZ统计协会。
PHX这里有非常多的统计就业机会，但是一般会要求有一定的专业背景和软件应用基础
。比如，统计的硕士学位，SAS 或者R的运用经验，数据库的知识也是很重要的。但是
，他们培训的是微软的SQL软件，虽然我知道的不多，我个人认为这个软件的前景远远
没有其他开源的，基于linux的数据库运用范围广。而且段时间的一两个小时也不是特
别有用。
他们开办的俱乐部倒是非常有用。http://www.mitbbs.com/club_bbsdoc/DBA_BI_Club.html
我从里面收益良多，非常感谢他们的分享。
还有linkedin的群
http://www.link... 阅读全帖 |
|
|
K****n
发帖数: 2485 | 50 遇到这样一个问题，需要编一段SQL指令，在任意给定的电话号码（包括国家代码，为
一整串数字，没有任何分隔符号）中识别出它的国家代码。所有已知国家代码在一个表
格中已经给出。
原题目如下，计算费率的部分已经解决，但如何确定国家代码的部分很头痛。貌似主要
难点在于无法区别代表美国的“1”与代表多米尼加的“1809”这样非常近似的区号。
其他区号的比较可能用LIKE %语句就能实现吧。
请SQL大拿们指点一下，多谢！ ：）
There are two tables in a telecom SQL Server database – Customers and Rates
as shown below:
Customers
PK CustomerPhoneNumber varchar(15)
CustomerType int -the type of customer
Rates
FK CustomerType int - the type of customer
Count |
|
