a***h
发帖数: 29 | 1 how to register SQL Server in intranet
there are three servers in a intranet. Server A and B are
SQL Servers run on NT,
Server C is the router connecting Server A, B, and other
clients.
I use "New SQL Server Registeration Wizard" in Server A, but
there is no availab
le server in the step "Select a SQL Server", i suppose
Server B's Name should app
ear in this step. what should i do if i want to register
Server B in Server A? |
|
a***h
发帖数: 29 | 2 how to register SQL Server in intranet
there are three servers in a intranet. Server A and B are
SQL Servers run on NT,
Server C is the router connecting Server A, B, and other
clients.
I use "New SQL Server Registeration Wizard" in Server A, but
there is no available server in the step "Select a SQL
Server", i suppose Server B's Name should appear in this
step. what should i do if i want to register Server B in
Server A? |
|
l*****c
发帖数: 33 | 3 我在建一个网站,在设计上有一个问题,请各路高手帮忙
初步的方案:
用ACCESS 2000 数据库,每一个注册用户拥有自己独立的Access数据库, usr1.mdb,
usr2.mdb... 如果假定这个网站可能有1万个用户,那么最后会有1万个MDB file. 每个MDB
file size可能从1M 到1G不等.
问题1: 如果100个用户同时上站,SERVER打开100 MDB file 会不会死球?
问题1: 数据库维护更新(比如COMPACT)很费时，如果今后要修改结构也很困难(尽管可以
在server上通过程序来实现）
优点1:便于控制每一个人的数据库的SIZE
优点2:各用户的数据文件独立
第二个方案:
用SQL server数据库,每一个注册用户在这个数据库里有一个独立的TABLE.我对SQL
SERVER不很熟悉
问题1: 怎样控制每个TABLE的大小
问题2: 如果平均每个用户都有10M, 1万个用户之后这个SQL 数据库将会非常大(100G),理
论上讲用于web server的SQL SERVER可以装载多大的数据库文件?
问题3: 100人同时使用同一个SQ |
|
c******n
发帖数: 6 | 4 Hi All,
I have one database in one SQL server in domain A, and I want to
transfer/copy/migrate it to another SQL Server in domain B. The problem is
that even I can access SQL Server A from .NET visual studio project in domain
B, I cannot find it when I try to register it in SQL Server in domain B. The
instance of server A is simply not in the list in enterpise manager.
Then, I tried to backup the specific database in SQLSERVER A and tried to
restore it in B based on that file, but it seems not w |
|
c**t
发帖数: 2744 | 5 declare @sql varchar(1000)
set @sql='select * from TBALE'
execute @sql
for example, i would like to generate insert and update statements for all
the tables in my db1 database. Need these scripts in other code.
Thanks.
Will do it in Toad. it's a vely basic & simple question.
any reply will be appreciated! |
|
M*****r
发帖数: 1536 | 6 首先，这可能吗？
我想运行
rc = OCIStmtPrepare(p_sql, p_err, (text*)"start tt.sql",
(ub4)12, (ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT);
程序虽然可以运行，但tt.sql中的语句没有执行（创建一个表，插入一些数据）。手头的
例子，如果是一句sql语句，可以正确运行。这个tt.sql是由其它程序自动生成的，所以
想自动运行它(实际中，可能有上百个)。
多谢！ |
|
o******5
发帖数: 29 | 7 The SQL part btween SQL server and Oracle is similar. You have to pay more
attention to PL/SQL which is Oracle's own procedure lanuage. Oracle PL/SQL
programming by Steven Feuerstein is a very good one. |
|
d****e
发帖数: 2856 | 8 Since M$ declared they will drop the support of Embedded SQL for C (ESQL/C)
in the furture versions of SQL Server after SQL Server 2000, what are the
alternatives when porting the existing applications which uses the ESQL/C?
Do we really have to rewrite the ESQL in ADO, OLE DB or ODBC? It sucks. |
|
s******n
发帖数: 34 | 9 我不是一定要用GO...只是问问有没有类似这样的分开sql语句的符号。
我是把所有要执行的语句（包括创建sp)放在一个文件里的，然后读取整个文件放到
string， 调用ado api执行。
我主要是不想parse文件， 找出有几条语句， 然后一条一条执行。
实际上是通过ado api执行一个batch sql, 但是这个格式不知道是怎样的。
我只知道sql server是通过加一个GO. |
|
q**j
发帖数: 10612 | 10 其实也不是新手了。写SQL query好几年了。但是对sql serve其他的部分基本一无所知
。想改变一下这种不良现象。请问哪里有比较好的关于ms sql server 2005的资料看。
最好是可以下载的pdf或者其他文件。
另外这个ms sql 2005为什么都没有online doc呢？2000版还有。哪里去找online doc
？多谢。 |
|
m*********y
发帖数: 127 | 11 installSqlServer:
[sql] Executing resource: C:\EdifecsSetups\install\database\schema\
dist\SqlServer\Create_Enablement_User.sql
[sql] Failed to execute:
[sql] USE Master
BUILD FAILED
C:\EdifecsSetups\install\database\schema\build\build.xml:476: The following
error occurred while executing this line:
C:\EdifecsSetups\install\database\schema\build\build.xml:480: The following
error occurred while executing this line:
C:\EdifecsSetups\install\database\schema\build\build.xml:83: ja |
|
|
B*****g
发帖数: 34098 | 13 1. access应该还不能用partition by。
2. 你的做法没问题，过时而已。
3. sql server好久没搞了，最近因工作需要才又搞了几下，不过我不看sql server的书
。看有没有其他sql server大拿跳出来给你建议。
4. sql server 2011就要出来了，呵呵。 |
|
g******3
发帖数: 115 | 14 装了oracle或sql server的xdjms能不能给我验证一下这个sql有没有我mysql下报的错
误，
SQL: select a.title,a.username,b.adddate from table a,(select max(adddate)
adddate from table where table.title=a.title) b
另外请高人指点，我这个sql有什么不足之处，
select * from testpost a where a.adddate = (select max(adddate) from
testpost b where a.title = b.title) |
|
|
s******r
发帖数: 1524 | 16 Never use Teradata before and will touch it now. I know there are some
structure differences between teradata and oracle. Now I am more interested
in for database user, sql, what's the difference between them.
I have a very old sql bible which covers oracle, DB2, sql server but no
teradata.
Any suggestion? Thanks, |
|
k*****n
发帖数: 361 | 17 我们公司太落后不肯花钱,局域网上用的两个main server 版本还是SQL server 2000
特地用select @@version查了下是8.0版本
我自己电脑装了SQL server 2000和2005 with SSAS/SSIS
现在想问我能用我电脑上的2005版本连接2000的server数据库做BI project吗?
2000的enterprise manager里能看到局域网server,但是2005的configuration manager
/SQL server 2005 services里啥都没有(SQL server,browser,login都没有),但是打开
05的managerment studio能看到此server并且能query
BIDS里建SSAS project,data source test connection能成功,但是最后deploy时还是
说不能成功连接服务器
请问这种情况到底能不能用05的SSAS/SSIS等功能啊? |
|
k**g
发帖数: 1558 | 18 用了dynamic sql,还是出错。在with前加 了semicolon第二个error没有了，但是还是
有incorrect syntax near 'u:'
DECLARE @sql nvarchar(500)
SET @sql = 'BULK INSERT MSCIDAILY FROM u:\DAILY_'+(CONVERT(VARCHAR(8) ,
GETDATE(),112)+'.csv')+' WITH (FIRSTROW = 2,FIELDTERMINATOR = '';'',
ROWTERMINATOR = ''\n'')'
EXEC(@sql)
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'u:'.
Msg 319, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'with'. If this statement is a common
table expression or an xmlnamespaces clause,... 阅读全帖 |
|
C***7
发帖数: 448 | 19 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 grilled :-)
Email: i***********[email protected] (Frank)
欢迎转告推荐! |
|
B*****g
发帖数: 34098 | 20 总结一下，其实大家把问题想太复杂了，尤其是咱用oracle的兄弟，其实就是个简单的
SQL。我其实是想大家用recursive SQL做。
yhwang，你写个recursive sql吧，俺写的似乎太复杂
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
写一个SQL，找出next N business days (N>0)。
假设已有fucntion isBusinessDay(date), return 1 for business day and 0 for
non-business day.
可以用任何数据库，不许假设M天之内必有N个business days。
第一个打出来的发双簧包，答案符合ANSI的包子加倍。 |
|
y****9
发帖数: 144 | 21
then
then
Learning SQL server now :-) Based on your sql structure; the following
works in SQL Server 2005
WITH t(d,n)
AS ( SELECT getdate(), case when day(getdate())%3=0 then 1 else
0 end
UNION ALL
SELECT t.d+ 1, t.n + case when day(t.d +1)%3=0 then 1 else
0 end
FROM t
WHERE t.n < 10
)
select min(d) from t
group by n
order by 1;
-----------------------
2012-01-06 13:27:25.843
2012-01-09 13:27:25.... 阅读全帖 |
|
a*z
发帖数: 294 | 22 Thank you, T4 and coolbid.
The reason for 32bit SQL server on 64bit OS is because I have a 32bit SQL
server (dev version) and I know it is good (I use it on a 32bit XP os for
years). Now my laptops are 64bit Win7 and I hope to install a SQL server
under win7.
coolbid: can you kindly share which version of 64bit SQL you are using? Is
it commercial? I use the server mainly for self study.
Thanks to both of you again. |
|
e****e
发帖数: 2740 | 23 【 以下文字转载自 JobHunting 讨论区 】
发信人: evence (硬猫), 信区: JobHunting
标 题: Java+SQL or C++/SQL
发信站: BBS 未名空间站 (Tue May 15 14:00:45 2012, 美东)
learning SQL
and want to learn a programming language, which one is better java or C++
for a market analyst |
|
g***l
发帖数: 18555 | 24 没人用C++了，一看这么问的，就知道是外行，什么语言不能接SQL，这不是最基本的么
，数据操作都要SQL，一般去面试人会问是什么后台,ORACLE, DB2,还是SQL SERVER，然
后会问.NET FRAMEWORK AJAX MVC3，当然JAVA那边也是一大堆实用的东西 |
|
P***n
发帖数: 174 | 25 最近才开始学习SQL把，基本的去w3cschool等几个网站上搞清楚了
现在开始学stored procedure
发现http://www.boobooke.com/bbs/thread-272667-1-1.html （播布客）的oracle的这一套视频非常强大，但是我想学的是T-SQL的，找了下，网上也搜索了下，要么就是很基本的T-SQL的教程，我都会了，要么就是针对某个具体问题的Stored procedure的某个人的博客的讲解。
请问有没有比较系统的T-SQL stored procedure的教程？书籍和网络视频都行
我想学的几个方面是
1. scheduled job with notificaitons, alerts, including data ETL,
generating reports,
2. scheduled backup, mirroring, and replication
我也不是太懂，有些术语乱写的，大概就是这一类的自动化作业相关的Stored
procedure
麻烦各位推荐下把 |
|
m******u
发帖数: 12400 | 26 re
信区: Database
标 题: Re: 学习Oracle的开始喽 - SQL/PLSQL (ZZ from CINAOUG)
发信站: BBS 未名空间站 (Mon Sep 14 15:58:00 2015, 美东)
SQL server工资低些。我做了15年SQL Server DBA. 另外做SQL Server DBA的老印特多
。 |
|
m******u
发帖数: 12400 | 27 re
信区: Database
标 题: Re: 学习Oracle的开始喽 - SQL/PLSQL (ZZ from CINAOUG)
发信站: BBS 未名空间站 (Mon Sep 14 15:58:00 2015, 美东)
SQL server工资低些。我做了15年SQL Server DBA. 另外做SQL Server DBA的老印特多
。 |
|
c*****d
发帖数: 6045 | 28 如果是写pl/sql代码，当然是sql developer胜出了
光名字就说明问题了，developer
用sqlplus写200行的pl/sql都会被累死
如果是db administration，毫无疑问是sqlplus
sql |
|
|
i****a
发帖数: 36252 | 30 MS SQL Server 容易入门. 自学习用, SQL Express + Management Studio. windows下
安装点 next next next 就行
Oracle 从安装到管理都需要 advanced 的LUNIX知识
T-SQL 和 PL-SQL 基本概念是相同的. 初学者学 T 还是 PL 无所谓. |
|
c*********e
发帖数: 16335 | 31 学数据库,刚开始要学sql,这是基本功。什么t-sql,pl-sql都没有sql重要。 |
|
x*****g
发帖数: 764 | 32 Below is what I got from running a query to create Database Auti
Specification:
"Msg 33075, Level 16, State 3, Line 3
Granular auditing is not available in this edition of SQL Server. For more
information about feature support in the editions of SQL Server, see SQL
Server Books Online."
This simply means there is no way to do it in SQL Server Express
log. |
|
c*****d
发帖数: 6045 | 33 【 以下文字转载自 JobHunting 讨论区 】
发信人: p0830 (AnnieJ), 信区: JobHunting
标 题: F家DS,analytics电面面经，贡献一个sql相关
发信站: BBS 未名空间站 (Sun Mar 9 17:51:08 2014, 美东)
因为太弱了所以面试官都没接着问，火急火燎地敷衍了我一下半小时不到就挂电话了。。
估计十分失望。。
这个职位在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 ... 阅读全帖 |
|
B*****g
发帖数: 34098 | 34 【 以下文字转载自 JobHunting 讨论区 】
发信人: Roseleaf929 (RL), 信区: JobHunting
标 题: 五月份免费SQL培训时间
发信站: BBS 未名空间站 (Mon May 5 00:43:46 2014, 美东)
大家好！为了方便一些学生朋友，特别安排在五月中旬考完考试之后：
Time: May 13(Tue) 6:00pm-8:00pm Session1
May 15(Thur) 6:00pm-8:00pm Session2
Session 1 (SQL 基础，DML&DDL，Database tables, 各种joins)
Session 2(Analysis Syntax, Null value 的处理，create table & Temporary Table
, Common Table Expression, Subquery, View, Stored Procedure)
需要做的准备：
①安装SQL SERVER:
http://www.mitbbs.com/clubarticle_t/DBA_BI_Clu... 阅读全帖 |
|
Y***e
发帖数: 1030 | 35 rt, SQL 初学者。 接到一个assessment, 要做sql 测试，是sql 和json 文件。请问哪
里有server 能做的？
谢谢！ |
|
d**********3
发帖数: 1186 | 36 Hello PASS Chinese Members,
This Thursday(Jun 19), we will hold SQL PASS Global Chinese Monthly Meeting
for Jun 2014.
Meeting Agenda,
Community Updates
SQL Tech Discussion:
You can ask any questions(SQL Technology--DBA, DEV, BI, BIG Data; looking
for jobs; Interviews...) you have, based on the questions we will have a
group discussion. you can bring questions in the meeting or submit
querstions to d******[email protected] ahead of the meeting.
Date and Time
Jun 19, 2014 8:00 PM - 9:00 PM CDT
Jun 19,... 阅读全帖 |
|
d**********3
发帖数: 1186 | 37 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... 阅读全帖 |
|
l******9
发帖数: 579 | 38 【 以下文字转载自 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*****m
发帖数: 215 | 39 同一个服务器上不同schema之间数据转换，挺复杂的逻辑，pl-sql可以写的很模块易维
护，老板楞要用ab initio，说是比pl-sql领先40年，易开发，容易documentation.问
题是我做细节设计，所有的query都我来写，然后交给AI程序员用ai实现.其实我设计完
成后，如果用pl-sql,程序开发已经完成了，现在还要几个星期，有问题都来问我，我
不会ai,也不想学。数据源data model比较蠢，不同的东西装在一个table里。
destination schema data model 类似，sql复杂无比，ai 程序员说，same source
and destination table pair之间只能有一个ai graph,建议split destination table
into two.我倒是支持改data model,因为本来就是错误的设计。问题是另外一个不同
的AI ETL JOB也在用这个table, AI程序员说改那个AI ETL JOB需要几个星期，我说不
就是改个table name吗，几分钟的事儿，他说改个table name是个很大... 阅读全帖 |
|
d**********3
发帖数: 1186 | 40 【 以下文字转载自 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 |
|
d**********3
发帖数: 1186 | 41 【 以下文字转载自 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 |
|
l******9
发帖数: 579 | 42 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
was truncated or one or more characters had no match in the target code page
.".
(SQL Server Import and Export Wizard)
I have created the destination table
CRE... 阅读全帖 |
|
c**********6
发帖数: 26 | 43 渴望求职？转行？进修？
申请BI工作有面试无结果？我们可以你帮助您！
成功只差一步！
祝贺国内医学博士晶女士，住家多年后参加培训已成功获得第一份商业智能好工作！
祝贺美MBA丽女士，住家多年后已成功获得第一份商业智能好工作！
祝贺美化学博士陆先生，已成功转行获得高薪稳定的商业智能BI工作！
USA BI Training Star 面向全美各地；在线商业智能职业培训 (773) 982 - 8168
我们的培训给希望求职转行进修的朋友一个新的选择。
短平快职业培训课程：
• SQL Server (SQL, SSIS, SSRS, SSAS)
• Oracle
• SAS 9.x (based, advanced, workshop/project in bank/insurance)
• ETL Informatica PowerCenter Developer 9.x
• IBM Cognos 10.x,
【报名电话】（773） 982 - 8168
【报名电邮】[email ... 阅读全帖 |
|
j*******7
发帖数: 6300 | 44 Extending SQL Server to Also Now Run on Linux
Today I’m excited to announce our plans to bring SQL Server to Linux as
well. This will enable SQL Server to deliver a consistent data platform
across Windows Server and Linux, as well as on-premises and cloud. We are
bringing the core relational database capabilities to preview today, and are
targeting availability in mid-2017.
https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-serv |
|
H******6
发帖数: 51 | 45 sqlpass Saturday Night SQL VC - May Webinar
Title: Myths and Truths about SQL Server Transaction
Abstract:
This session is well suited for DBAs and Developers who are constantly
exposed to production environment because the session covers the common
issues many neglect without recognizing. We demonstrate examples of
incorrect development methodologies and analyze internal transaction logs in
multi-transaction cases. After identifying the common mistakes, we will
cover the best practice to avoid ... 阅读全帖 |
|
L*********r
发帖数: 92 | 46 There are a lot of ways to connect ASP.net to SQL server. It is depend on
your use case to pick up the suitable approach.
Impersonate: This approach has problem if the client is not in the same
Window domain. But it has the advantage that different client has different
permission to access SQL server.
Built SQL Server user name/pwd into connection string: This approach is not
safe in view of security. All clients have the same permission to access SQL
server.
Change the identity of ASP.net worke |
|
y********o
发帖数: 2565 | 47 我用了我的电脑名字加SQL Server名字，现在症状不一样了。瞧：
An error has occurred while establishing a connection to the server. When c
onnecting to SQL Server 2005, this failure may be caused by the fact that un
der the default settings SQL Server does not allow remote connections. (prov
ider: Named Pipes Provider, error: 40 - Could not open a connection to SQL S
erver)
哦，yes, mine is express. 那我干脆从在防火墙上将1433洞口也凿开试试。 |
|
d****g
发帖数: 1542 | 48 【 以下文字转载自 Database 讨论区 】
发信人: dufeng (dufeng), 信区: Database
标 题: SQL Navigator for oracle可以连team foundation server 2010吗？
发信站: BBS 未名空间站 (Wed May 23 23:11:36 2012, 美东)
目前是SQL Navigator与VSS 6.0
准备升级到TFS 2010,还能用SQL Navigator吗？google了一下，好像SQL Navigator 6.
2支持TFS 2008。
有大侠用过吗？
如果不支持的话，只能在vitual studio里建一个database project了？
多谢。 |
|
B*****g
发帖数: 34098 | 49 【 以下文字转载自 Database 讨论区 】
发信人: lakewest (lake), 信区: Database
标 题: 【隆重推出】北美华人SQL Server User Group (CINASSUG)
发信站: BBS 未名空间站 (Thu Jun 7 23:25:39 2012, 美东)
北美华人SQL Server User group
Chinese in North America SQL Server User Group (CINASSUG)
CINASSUG：
https://groups.google.com/group/chinese-in-north-america-sql-server-user-
group-cinassug?hl=en
重要以数据库知识为主， 相关知识为辅助， 根据知识点和市场需要分为下边的track,
a. Application Dev, 包括database application development 以及相关的.NET
framework
b. DBA, 这个不用解释了
c. BI/DW architecture,... 阅读全帖 |
|
|
