一本关于MSSQL/SQL SERVER的好书

问题描述

您好，有人可以告诉我关于sql服务器的好书，因为我上大学时曾教过oracle 9i，那是2年前的事，并且知道synatx/关键字存在一些差异，因此希望获得mssql/的第一手知识. sql服务器.

例如考虑考虑以下在oracle
中的触发器语句

hi can any one tell me a good book on sql sever because i college i was taught oracle 9i and that was 2 years back and as know there are some synatx/keyword differnce so would like to get first hand knowledge of mssql/sql server .

for eg consider following trigger statement which is in oracle

create trigger <triggername>
before delete on <tb1>
for each row
begin
insert into <newtablename> values(:old.column1 , :old.column2...)
end </newtablename></tb1></triggername>

现在，此代码将在sql server中产生错误，因为它无法识别旧的关键字，而且语法也围绕冒号

其等效于mssql/sql服务器(我从网络获得/从朋友那里获得帮助)

now this code would give error in sql server as it wont recognize old keyword also syntax around colon

its equivalent for mssql/sql sever would be(which i got from net/help from friends)

create trigger <triggername>
on <tb1>
for insert
as
declare
@variable1 varchar(10)
select @variable=var form tb1
begin
insert into <newtable> values(@variable)
end  </newtable></tb1></triggername>

因此，作为朋友的朋友可以看到语法和关键字的差异，因此请向我推荐一本有关mssq/sql服务器的好书
谢谢
anoop

so friends as one can see difference in syntax as well as keywords so please suggest me a good book on mssq/sql server
thanks
anoop

推荐答案

这篇关于一本关于MSSQL/SQL SERVER的好书的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！