b*********l
发帖数: 466 | 1 I used teradata and mssql for 1 year.
A little bid difference in daily work.
SQL are more powerfull than Proc SQL.
Usually it can handle huge amount of data for processing.
Some syntax discrepancy due to different database company.
eg. Oracle SQL and Tera SQL and DB2 SQL
Usually just some differences in Function Name. |
|
r**********d
发帖数: 510 | 2 proc sql is a tiny subset of the standard SQL. it is just for data
manipulation.
SAS is not a RDMS, so it doesnt have a lot of db features.
different RDMSes have their own variations of SQL.
this doesn’t even include their stored procedures, such as pl/sql, t-sql.
sas doesn’t have triggers, cursors etc. |
|
c******y
发帖数: 3269 | 3 You are right about "需要把所有的数据都带到服务器或者本地" if it is SAS
implicit SQL-passthrough, in the means of libname, without in-database
processing.
To resolve the issue, there are several approaches.
1. views/stored procedures as you mentioned, which requires additional
maintenance and only fits for "frequently-used" joins.
2. implicit SQL-passthrough with in-database processing, which requires
knowledge on additional SAS syntax, and has a limitation on the usage.
3. explicit SQL-passthrough, which only pa... 阅读全帖 |
|
x****o
发帖数: 142 | 4 【 以下文字转载自 TransferToCS 俱乐部 】
发信人: xxzhao (Hello USA), 信区: TransferToCS
标 题: 【免费讲座】2/28 Session: Introducing SQL Server on Linux
发信站: BBS 未名空间站 (Fri Feb 24 20:28:46 2017, 美东)
Dear PASS Chinese members,
We have an exciting webinar lined up for you next Tuesday night! Here are
the details:
Topic: Introducing SQL Server on Linux
Speaker: Zhen Zhang
Date & Time: Tue, Feb 28, 2017 8:00 PM - 9:00 PM CST
RSVP URL:
https://attendee.gotowebinar.com/register/3587065807077502467
Session Abstract:
To demons... 阅读全帖 |
|
y****w
发帖数: 3747 | 5 如果or的话，那你还是先学sql server吧，上手容易，环境容易搭，而且m$的教材也很
好。
至于sql之类，有本讲sql server internal的书专门介绍sql server sql的，你去
amazon搜一下应该很多， |
|
z********c
发帖数: 1268 | 6 【 以下文字转载自 Actuary 讨论区 】
发信人: zhangyustc (??), 信区: Actuary
标 题: a sql analyst position
发信站: BBS 未名空间站 (Fri Dec 3 14:41:39 2010, 美东)
一个recruiter发给我的, 好象找的很急, 跟actuarial science没什么关系, 权当参考了.
It is located in New York, NY.
Position: Technical Analyst
Overview:
The Technical Analyst will be responsible for enhancing, maintaining and
supporting a variety of software applications (both off the shelf and in‐
house apps) primarily within Royce & Associates’ Marketing & Communication
Department that all... 阅读全帖 |
|
y*****8
发帖数: 6 | 7 之前投了网申，给了成绩单，给邮件说要电面，让选preferred programming language
，Java和SQL选一个，我选了个SQL，难道拿SQL面么？请问SQL咋个面法？有啥注意要点
么？
求版内大牛解答啊~~~~ |
|
l******9
发帖数: 579 | 8 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL debug step into a store procedure from another one
发信站: BBS 未名空间站 (Mon Jun 30 11:04:12 2014, 美东)
I have to debug a store procedure on SQL server 2008 R2 on Microsoft sql
studio.
In my SQL query, I have to call two store procedures :
EXEC @return_value = [my_database].[dbo].[store_procedure1]
in [my_database].[dbo].[store_procedure1], I need to call another procedure:
execute @return_status = store_procedure2
in debu... 阅读全帖 |
|
l******9
发帖数: 579 | 9 【 以下文字转载自 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 | 10 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: Truncation error import csv file to SQL table
发信站: BBS 未名空间站 (Wed Apr 29 15:28:46 2015, 美东)
I would like to import a .csv file into a SQL Server 2008R2 database table
on Win 7.
It has one column and one row.
File1:
name
runeocnu 430274 sjunosnv djduenvop 934m ljfonm3
I got error:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "NAME" returned status value 4 and status text "Text
w... 阅读全帖 |
|
m****s
发帖数: 18160 | 11 【 以下文字转载自 Seattle 讨论区 】
发信人: hanxin (招聘专员), 信区: Seattle
标 题: 招SQL dev in Redmond town center
关键字: SSRS,SSIS,T-SQL
发信站: BBS 未名空间站 (Tue Apr 2 12:02:01 2013, 美东)
Qualifications:
• 5+ years of proven experience in designing, developing and
shipping production quality web based user experiences
• Proven record of managing high volume transactional services
on the Internet and a strong background involved in developing software
products and services.
• Exper... 阅读全帖 |
|
c*****5
发帖数: 10 | 12 【 以下文字转载自 JobHunting 讨论区 】
发信人: chp2015 (chp2015), 信区: JobHunting
标 题: Opening: SQL Server ELT Developer @Maryland
发信站: BBS 未名空间站 (Tue Jan 20 11:49:45 2015, 美东)
Sponsor H1B and GC.
However, the company is not E-verified.So we can't support OPT extension.
The company is located at Columbia, MD. Local candidates are preferred.
Thanks.
------------------------------------------
SQL Data Warehouse Developer
Consortium Health Plans (CHP)
Position Summary
Consortium Health Plans is looking for an exp... 阅读全帖 |
|
a******u
发帖数: 4 | 13 IT Star Up 公司， 位于 San Diego Downtown， Data Science Team 诚聘 SQL
Analyst。
详细的 Job Description 如下： 有意者请将Resume发至 [email protected]
/* */ 谢谢！
We’re looking for an awesome SQL Analyst to join our Data Science team. If
you love to dig deep into big data, extract meaningful relationships, and
share your insights with others, this is the perfect role for you.
SweetLabs is a company driven by data insights. As a Data Science member,
you will be a part of a small, agile team using the latest techn... 阅读全帖 |
|
h********8
发帖数: 7355 | 14 【 以下文字转载自 LosAngeles 讨论区 】
发信人: CLuo7 (只羡鸳鸯不羡仙), 信区: LosAngeles
标 题: LA公司招IT人员： MS SQL Dev/DBA
发信站: BBS 未名空间站 (Tue Oct 11 18:50:33 2011, 美东)
LA公司招IT人员： MS SQL Dev/DBA
The candidate will be joining a 5-DBA team, focusing on MS SQL 2005/2008 T-
SQL developement(70%), while doing DBA work on the side(30%). 公司已经有5名
DBA，需再招一人重点在 T-SQL development上
需5年Dev经验，5年DBA经验
公司已在 Nasdaq 上市12年,零售业，业绩稳定(最近股票逆市上涨)，可办H1,绿卡.
地点：Culver City, CA 90066
限LA local only
有兴趣者email联系，初入门者请勿扰，因为会有4个 Senior DBA 对你进行技术问题全面面
试... 阅读全帖 |
|
|
|
c***3
发帖数: 20 | 17 Looking for a SQL development team member that supports the Energy
Compensation System (ECS) for the Division of Energy Employees Occupational
Illness Compensation (DEEOIC) at the US Department of Labor (DoL). The
position is on site at the DoL facility at 3rd and Constitution in
Washington DC and is conveniently located near the Judiciary Square Metro
station. This is a full time SQL Developer position.
The selected candidate will perform the following:
Deliver Monthly reports
Directly partic... 阅读全帖 |
|
c***3
发帖数: 20 | 18 Looking for a SQL development team member that supports the Energy
Compensation System (ECS) for the Division of Energy Employees Occupational
Illness Compensation (DEEOIC) at the US Department of Labor (DoL). The
position is on site at the DoL facility at 3rd and Constitution in
Washington DC and is conveniently located near the Judiciary Square Metro
station. This is a full time SQL Developer position.
The selected candidate will perform the following:
Deliver Monthly and on-demand reports
D... 阅读全帖 |
|
a****g
发帖数: 9 | 19 我把image存在sql server 里，存的时候没有问题。但当我用ASP页想DELETE image
record 的时候, 遇到麻烦。症状是：
1. DELETE 小的 Image (<50k), 没有问题。
2 当image超过100k后，我就DELETE不掉了。SQL server 就死了。我用的方法是在ASP页
内生成一个SQL command, send 到 SQL server.
如果我把同样的 SQL command 直接在 SQLserver里 run, 就可以DELETE掉。
是不是我的那里设支不对？请高手给点意见。 |
|
a***h
发帖数: 29 | 20 SQL Server数据同步复制
网上有一个SQL Server A. 每天晚上12点将数据复制到SQL Server
B中(此SQL Server与网上的那个SQL Server
A不在同一处,两者通过ISDN拨号相连). 要求: Server B 计算
Server A 一天来新增的数据, 并且将计算结果回写Server A.
请问: 应用Snapshot, Transcation,还是Merge 同步方式?
注意: 如果12:00时将 Server A 的数据载到 Server B, 当Server B
完成计算时可能已是2:00时了, Server A 的数据又有所更新, 这时
应如何将 Server B 的计算结果回写 Server A? |
|
b****e
发帖数: 1 | 21 各位大侠,
我现在想用embedded SQL对一个Oracle 8i 的表进行update,
我在C文件中嵌入如下语句:
#include
#define MAX 18
exec sql begin declare section;
char user_name[30], user_pwd[10];
char etitle[10];
int esalary;
exec sql end declare section;
int main()
{
int i;
strcpy(user_name, "*****");
strcpy(user_pwd, "***");
exec sql connect :user_name identified by :user_pwd;
exec sqp declare emp cursor for
select title, salary from employee, works
where employee.eid = works.eid;
exec sql open emp;
for (i=0; i |
|
z*q
发帖数: 29 | 22 As I know, to use batch insert/update, you should use
record/collection/table_of_record type in PL/SQL, just like the following:
forall i in tbl_interval_meter.first .. tbl_interval_meter.last
INSERT INTO interval_meter_temp VALUES tbl_interval_meter (i);
Your begin end code will work in PL/SQL, but is not a batch sql, it is just a
block in PL/SQL.
Hope it is useful. |
|
e****c
发帖数: 10 | 23 Now I try to migrate my Visual Basic Application from MS SQL to My SQL, but i
met problem when i use crystalreport which connects My SQL . Below is my code:
CrystalReport1.Connect = "DSN=TestDB;uid=amy;pwd="
CrystalReport1.Destination = 0 ' 0-window 1-printer
CrystalReport1.ReportFileName = CrystalReportDir &
"\CrystalReport\Tracking\test.rpt"
sql = "select * from Score"
CrystalReport1.SQLQuery = sql
CrystalReport1.Action = 1
When this program execute the last line of code, following error |
|
b******u
发帖数: 676 | 24 I have an SQL server database host on the server. And I have a tiny Access
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S |
|
e**f
发帖数: 1 | 25 I received a copy of SQL server 7 backup file, but I only have SQL server 2000
and SQL server 6.5.
Where can I download SQL server 7 (trial) software?
Thanx. |
|
t*******y
发帖数: 57 | 26 这几天真是见了鬼了
在Linux下单独写个standalone的java程序用JDBC访问oracle一点问题都没有
换写成servlet来通过JDBC访问oracle竟然只能做"select .."这样的sql访问
用什么insert/update/desc之流的sql命令通通给我出错,
说什么java.sql.SQLException: SQL string is not Query
ft,明明直接把那些sql命令放入sqlplus执行和放在standalone的java程序里面
执行一点问题都没有.google了半天没有啥结果.
这个到底啥原因有人知道么?难道用servlet调用jdbc数据库还有权限限制?
用perl写的cgi调用数据库也一点问题都没有呀. |
|
f*****8
发帖数: 118 | 27 我最近卸载安装的SQL Server2005，不知道是顺序不对还是别的什么原因，造成的结果
是在start menu上面仍然可以看到SQL Server2005的entry,试着运行会出错。在
control panel的add/remove programs里已经找不到SQL Server2005的条目了。我试着
重装SQL Server2005,但是每回都出错。 现在我如何把系统里剩下的SQL Server2005卸
载掉？我试过了手动删除文件，但是重新安装的时候还是装不上。
谢谢！ |
|
s****s
发帖数: 12 | 28 我是我们全公司唯一懂一点儿SQL的了， 我们老板总试图让我用SQL去做一些分析，
他认为SQL比我们用的统计软件快。 可是我不知道怎么做， 而且也不确定用到底快
不快。
我们要做的是有一个test group, 另外有一个control group， 我们想给每一个在
test group里的人找一个最相近的control。我的想法是这样的：
两组数据里的变量都一样， 比如年龄（）， 身高， 体重。 首先 ，对每一个
test group里的人， 计算每一个在control group里的人与他的距离（就是 sum of
squares of the differences in those variables between the test and control)
， 然后找出距离最小的那个就是他的control。 大家说这种计算用SQL快吗？ 有更
好的方法吗？ 如果不适合用SQL, 我要怎么convince老板阿？ |
|
j*****n
发帖数: 1781 | 29 have a temp table to capture the result if ur dynamic SQL returns data set.
eg.
CREATE TABLE #result
(rowCount int)
DECLARE @sql varchar(max)
SET @sql = 'select count(1) from tbl'
INSERT INTO #result
EXEC(@sql)
use @@rowcount if @sql stores a DML |
|
a*******t
发帖数: 891 | 30 I need to rephase my question. I want to get the error out of the execution.
So if the I do
SET @SQL = 'Wrong SQL command'
EXEC(@SQL)
and I want to capture the error message
There are some types of errors that'll stop the query execution, so I can't
even get the @@error after the execution.
Anyway, I am going to have to use the OnError event for that SQL Task in
SSIS. I was trying to avoid it because I have a lot of SQL Task in this
package.
Thanks anyway |
|
a*******t
发帖数: 891 | 31 it behavies the same as exec()
just for example, if I do:
declare @sql nvarchar(512)
set @sql = 'update statistics abc'
exec sp_executesql @sql
select @@error
the query will fail because it cannot find table abc, it'll stop executing
before I can do the select @@error
the only way this can work is if
begin try
exec sp_executesql @sql
end try
begin catch
select @@error
end catch
but a business requirement is to consider SQL Server 2000, so, try catch is
out of the options |
|
B*****g
发帖数: 19 | 32 我觉得问题其实在于go是不是一个sql query. 也许Go只是sql server(我想你说得是MS
sqlserver，对吧）的一个软件命令，所以如果你通过ado让server按照sql来执行，恐
怕不行。
就好像dir是系统命令，如果你让ado传给sql server，不会通过。
不一定对，楼主参考。 |
|
y****9
发帖数: 144 | 33 New to SQL server ( just try to learn it as an Oracle DBA), did a test about
recovering a db, can someone tell me how to do a complete recovery in the
following case:
1. big_table reference point:
1> select max(id) from big_table;
2> go
-----------
2000000
2. Backup database testdata
3. insert several records into table big_table in the testdata database
1> select max(id) from big_table;
2> go
-----------
2000003
4. Shutdown the instance
5. delete the ... 阅读全帖 |
|
B*****g
发帖数: 34098 | 34 【 以下文字转载自 I485 讨论区 】
发信人: CLuo7 (只羡鸳鸯不羡仙), 信区: I485
标 题: LA公司招IT人员： MS SQL Dev/DBA
发信站: BBS 未名空间站 (Tue Oct 11 20:13:09 2011, 美东)
LA公司招IT人员： MS SQL Dev/DBA
The candidate will be joining a 5-DBA team, focusing on MS SQL 2005/2008 T-
SQL developement(70%), while doing DBA work on the side(30%). 公司已经有5名
DBA，需再招一人重点在 T-SQL development上
需5年Dev经验，5年DBA经验
公司已在 Nasdaq 上市12年,零售业，业绩稳定(最近股票逆市上涨)，可办H1,绿卡.
地点：Culver City, CA 90066
限LA local only
有兴趣者email联系，初入门者请勿扰，因为会有4个 Senior DBA 对你进行技术问题面
试. You will be ... 阅读全帖 |
|
a*z
发帖数: 294 | 35 Can you kindly give me some help on my problem?
I hope to install SQL 2005 (32bit) under Win7 64bit OS. The system says that
it is not compatible.
I tried to install SQL 2012 RC0 and 2008 R2 (evaluation version) but failed.
Is there some trick to install? Can you kindly advice some link about how
to install either one?
Does the XP mode help? If I install the SQL into XP-mode, can Excel connect
to the SQL server?
When I google the subject and find a link charging about $2.97 for the
instruction o... 阅读全帖 |
|
|
|
l******t
发帖数: 660 | 38 SQL Server入门系列
1. introduction to sql server DBA
By Steve Yu, 07/17号周二9点， EST
http://www.anymeeting.com/CINASSUG1&rslt=77a3bf40-d488-4eaf-8f7
2. Introduction to Sql Server developer
07/25 周二9点， EST
3. Introduction to Sql Server BI developer
TBD
SQL Server技术交流系列
1. Data Warehouse modeling and lifecycle, data vault, kimball and Inmon
TBD |
|
B*****g
发帖数: 34098 | 39 事实胜于雄辩，coolbid必须参加
认为sqlplus好的，请举出10种sqlplus能干而sql developer不能干的，10种sqlplus效
率高而sql developer效率低的。
认为sql developer好的，请举出10种sql developer能干而sqlplus不能干的，10种sql
developer效率高而sqlplus效率低的。 |
|
c*********e
发帖数: 16335 | 40 java里面，查询数据库还是要写sql query.看来要查询数据库，还是最基本的sql语言
来得快，尤其是有index的时候。
一个java war,建立table,删除表格（create,update,delete)的一行什么的，java可以
有自己的方式，但是query table,java只能借助最基本的sql语句。比如找出数据库里
年薪大于5万的员工，列表，为了快速得到结果，还是要用sql.
c#可以用linq来做。 |
|
A*********n
发帖数: 637 | 41 工资大概在6.5W~7.5W之间,看你跟经理商量的情况.最好不需要H1B,当然也有例外.
地点在DALLAS.有兴趣的朋友请站内联系,留下您的邮件地址,谢谢!
Job Description
The job includes support of all aspects of databases/database
application code throughout the development/QA and production deployment,
expert skills in T-SQL and stored procedures, and the management of claims
production systems which includes loading data to production systems and
maintaining data to and from clients.
SQL programming/database manipulation and extraction
Create T-... 阅读全帖 |
|
s**********o
发帖数: 14359 | 42 没啥出息，混碗饭吃
upgrade a MCITP:Database Administrator (SQL Server 2008) certification and/
or MCITP:Database Developer (SQL Server 2008) certification to MCSE:Data
Platform (SQL Server 2012) you'll need to do the 3 exams 457, 458 and 459.
If you would like to upgrade a MCITP:Business Intelligence Developer (SQL
Server 2008) certification to MCSE:Business Intelligence (SQL Server 2012)
you'll need to do the 3 exams 457, 458 and 460. |
|
|
d**********3
发帖数: 1186 | 44 Hello My Friends,
Happy New Year to you and your family.
Next Thursday, we will hold SQL PASS Global Chinese Monthly Meeting for Feb
2014.
Time: @8PM~9PM CST on Feb 20, 2014
Instructor: Louis Li
Meeting Agenda,
Month Updates
Technical Session: Working with XML in SQL Server
What is XML
Generating XML Output
Querying XML data
XML Index Introduction
XML deep dive
Q&A
---------=========Registration Information========------------
Please register for SQL PASS Global Chinese Month... 阅读全帖 |
|
G********r
发帖数: 3161 | 45 不知道的发在这里合不合适，我有一个IDB(Integrated Database)，目前只包括四个部
门的数据已经有300万条记录了，我们主要是用PC SAS处理数据，请教一下有经验的前
辈，对于大数据，是不是应该多用Data step而不是SQL啊，我目前测试的结果是Data
Step明显快于SQL，但是又很想用SQL，因为很多东西用SQL要简洁得多，比如说我要把
每个部门的最大值，最小值加到每个人的数据上，SQL一个语句就做出来了，Data Step
要最大值做一个dataset，最小值做一个Dataset，然后跟主数据Merge起来，至少三步
。请教前辈在处理大数据方面的经验。谢谢了。 |
|
l******9
发帖数: 579 | 46 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL debug step into a store procedure from another one
发信站: BBS 未名空间站 (Mon Jun 30 11:04:12 2014, 美东)
I have to debug a store procedure on SQL server 2008 R2 on Microsoft sql
studio.
In my SQL query, I have to call two store procedures :
EXEC @return_value = [my_database].[dbo].[store_procedure1]
in [my_database].[dbo].[store_procedure1], I need to call another procedure:
execute @return_status = store_procedure2
in debu... 阅读全帖 |
|
l******9
发帖数: 579 | 47 【 以下文字转载自 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 | 48 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: Error of SQL query on IBM netezza SQL database from Aginity workbench
发信站: BBS 未名空间站 (Fri Dec 5 16:46:56 2014, 美东)
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' // t... 阅读全帖 |
|
c*****5
发帖数: 10 | 49 【 以下文字转载自 JobHunting 讨论区 】
发信人: chp2015 (chp2015), 信区: JobHunting
标 题: Opening: SQL Server ELT Developer @Maryland
发信站: BBS 未名空间站 (Tue Jan 20 11:49:45 2015, 美东)
Sponsor H1B and GC.
However, the company is not E-verified.So we can't support OPT extension.
The company is located at Columbia, MD. Local candidates are preferred.
Thanks.
------------------------------------------
SQL Data Warehouse Developer
Consortium Health Plans (CHP)
Position Summary
Consortium Health Plans is looking for an exp... 阅读全帖 |
|
t*******y
发帖数: 57 | 50 【 以下文字转载自 Database 讨论区 】
【 原文由 tribology 所发表 】
这几天真是见了鬼了
在Linux下单独写个standalone的java程序用JDBC访问oracle一点问题都没有
换写成servlet来通过JDBC访问oracle竟然只能做"select .."这样的sql访问
用什么insert/update/desc之流的sql命令通通给我出错,
说什么java.sql.SQLException: SQL string is not Query
ft,明明直接把那些sql命令放入sqlplus执行和放在standalone的java程序里面
执行一点问题都没有.google了半天没有啥结果.
这个到底啥原因有人知道么?难道用servlet调用jdbc数据库还有权限限制?
用perl写的cgi调用数据库也一点问题都没有呀. |
|
