初学者学生PL / SQL到T-SQL [英] beginner student PL/SQL to T-SQL
问题描述
我正在完成一个开始的SQL课程，在那里我们在Oracle
数据库上学习并转换到在SQL Server上工作简单。接下来的更多
高级课程将在PL / SQL中，但我知道我将在工作场所研究SQL
服务器，所以我的问题是我是否应该服用这个课程。
我将从所涵盖的基本理念中受益，或者它会为我的过渡更加困难吗？这部分是浪费时间和金钱吗？我会更好地获得一本书和自我教学
我自己？我知道在更大的意义上学习一些东西并不一定是浪费，但我的意思是从我的目标是能够使用Sql
Server，将这个课程有用吗？
谢谢。
Hi,
I''m finishing up a beginning SQL class where we learned on an Oracle
database and the transition to working on SQL Server is easy. The next more
advanced course will be in PL/SQL, but I know I will be working on SQL
Server in the workplace, so my question is if I should take this course.
Will I benefit from the basic philosophies that will be covered, or will it
just make a transition for me more difficult? Will it be partly a waste of
time and money and I''d be better served getting a book and self teaching
myself? I know that in a greater sense learning something isn''t necessarily
a waste, but I mean from the perspective of my goal of being able to use Sql
Server, will this course be useful?
thanks.
推荐答案
JAK（NO **** @ hotmale。 com）写道：
JAK (NO****@hotmale.com) writes:
我正在完成一个开始的SQL课程，我们在Oracle数据库中学到了这一点，并且转向使用SQL Server很容易。下一个
更高级的课程将在PL / SQL中，但我知道我将在工作场所中使用SQL Server，所以我的问题是我是否应该采取这个课程。我是否会受益于将要涵盖的基本理念，或者它是否会让我的过渡变得更加困难？它会不会浪费时间和金钱，而且我会更好地获得一本书和自学自学？我知道在更大程度上学习某些东西并不一定是浪费，但我的意思是从我能够使用Sql Server的目标来看，这门课程会有用吗？
I''m finishing up a beginning SQL class where we learned on an Oracle
database and the transition to working on SQL Server is easy. The next
more advanced course will be in PL/SQL, but I know I will be working on
SQL Server in the workplace, so my question is if I should take this
course. Will I benefit from the basic philosophies that will be covered,
or will it just make a transition for me more difficult? Will it be
partly a waste of time and money and I''d be better served getting a book
and self teaching myself? I know that in a greater sense learning
something isn''t necessarily a waste, but I mean from the perspective of
my goal of being able to use Sql Server, will this course be useful?
我没有Oracle的经验，但从我开始使用SQL Server的Oracle用户看到的问题来看，出现了
是相当大的差异。 Oracle支持SQL Server
不支持的语法，反之亦然。什么可能对性能有好处？
Oracle在SQL Server中可能不太好，反之亦然。
那些有两种引擎经验的人可能有更多要补充的，但是我的直觉反应是，如果你想学习SQL Server，那么
试着找一个关于SQL Server的课程。
-
Erland Sommarskog，SQL Server MVP， es **** @ sommarskog.se
SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp
我同意Erland你应该找到一个Transact-SQL课程或
书，因为这是你将要使用的。您的大部分SQL知识都适用于这两种产品，但在PL / SQL与Transact-SQL的声明性和过程性元素之间存在差异非常重要。我的观察结果是PL / SQL是一种程序性语言，而不是
Transact-SQL。
我的Oracle体验是有限（主要是DBA），我首先学习了Transact-SQL
。也许有人不得不从PL / SQL过渡到
Transact-SQL可以提供更多的洞察力。
-
希望这会有所帮助。
Dan Guzman
SQL Server MVP
" JAK" < NO **** @ hotmale.com>在消息中写道
新闻：******************** @ twister.rdc-kc.rr.com ...
I agree with Erland that you should probably find a Transact-SQL course or
book since that is what you''ll be using. Much of your SQL knowledge is
applicable to both products but the differences are significant once to get
into the declarative and procedural elements of PL/SQL vs. Transact-SQL. My
observation is that PL/SQL is a much more procedural language than
Transact-SQL.
My Oracle experience is limited (mostly DBA) and I learned Transact-SQL
first. Perhaps someone who has had to make to transition from PL/SQL to
Transact-SQL can provide more insight.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JAK" <NO****@hotmale.com> wrote in message
news:By********************@twister.rdc-kc.rr.com...
我正在完成一个开始的SQL课程，我们在Oracle数据库中学到了这一点，并且很容易过渡到使用SQL Server。下一个
更高级的课程将在PL / SQL中，但我知道我将在工作场所中使用SQL Server，所以我的问题是我是否应该采取这个课程。我是否会受益于将要涵盖的基本理念，或者它是否会让我的过渡变得更加困难？会不会浪费时间和金钱，而且我会更好地获得一本书并自我教学？我知道在更大程度上学习某些东西并不一定是浪费，但我的意思是从我能够使用Sql Server这一目标的角度来看，这门课程会有用吗？ />
谢谢。
Hi,
I''m finishing up a beginning SQL class where we learned on an Oracle
database and the transition to working on SQL Server is easy. The next
more advanced course will be in PL/SQL, but I know I will be working on
SQL Server in the workplace, so my question is if I should take this
course. Will I benefit from the basic philosophies that will be covered,
or will it just make a transition for me more difficult? Will it be partly
a waste of time and money and I''d be better served getting a book and self
teaching myself? I know that in a greater sense learning something isn''t
necessarily a waste, but I mean from the perspective of my goal of being
able to use Sql Server, will this course be useful?
thanks.
Dan Guzman写道：
Dan Guzman wrote:
我同意Erland你应该可能会找到一个Transact-SQL课程或
本书，因为这是你将要使用的。您的大部分SQL知识都适用于这两种产品，但这些差异对于PL / SQL与Transact-SQL的声明性和过程性元素之间的区别非常重要。我的观察结果是PL / SQL是一种比Transact-SQL更加程序化的语言。
我的Oracle经验有限（主要是DBA），我学习了Transact-SQL <首先。也许有人不得不从PL / SQL转换到Transact-SQL可以提供更多的洞察力。
I agree with Erland that you should probably find a Transact-SQL course or
book since that is what you''ll be using. Much of your SQL knowledge is
applicable to both products but the differences are significant once to get
into the declarative and procedural elements of PL/SQL vs. Transact-SQL. My
observation is that PL/SQL is a much more procedural language than
Transact-SQL.
My Oracle experience is limited (mostly DBA) and I learned Transact-SQL
first. Perhaps someone who has had to make to transition from PL/SQL to
Transact-SQL can provide more insight.
好建议。但架构差异是一个更大的攀升。
使用SQL Server你不能指望Oracle的多版本化b / b
使用SQL Server你可能会发现一个不同的NULL行为
和产品之间的许多其他重大差异。
-
Daniel A. Morgan
大学华盛顿
da******@x.washington.edu
（将''x''替换为''u'来回复）
Good advice. But the architecture differences are an even larger climb.
With SQL Server you can not expect Oracle''s multiversioning
With SQL Server you will likely find a different behavior of NULL
and many many other significant differences between the products.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace ''x'' with ''u'' to respond)
这篇关于初学者学生PL / SQL到T-SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
