What is a good way to learn to develop SQL Server(2005) stored procedures? I am primarily a java developer but need to take on SQL Server stored procedure development. I have some basic SQL in my background but nothing major. Any good specific tutorials maybe using the adventure works schema? Or just good reference sites that contain alot of useful syntax.
学习开发SQL Server(2005)存储过程的好方法是什么?我主要是一个java开发人员,但需要承担SQL Server存储过程开发。我的背景中有一些基本的SQL,但没什么大不了的。任何好的特定教程可能使用冒险作品架构?或者只是包含大量有用语法的好参考站点。
I would say either the abundance of good resources or a very useful couple tutorials will be the winner.
我会说,丰富的优秀资源或非常有用的几个教程将成为赢家。
4 个解决方案
#1
Personally there are two ways that I have found to get up to speed quickly.
就个人而言,我发现有两种方法可以快速加速。
- Have real world problems that you need to solve.
- Get a good T-SQL Book. There are numbers of them out there, most of the Microsoft Press ones are good, along with many others.
遇到需要解决的现实世界问题。
获得一本好的T-SQL书。有很多这样的,大多数微软出版社都很好,还有很多其他的。
#2
it depends what you're trying to do really. A good knowledge of SQL is the main requirement. Above that learn about parameters.
这取决于你真正要做的事情。熟悉SQL是主要要求。以上了解参数。
I find most people don't put too much logic in SPs these days. Rather they're just a collection of standard SQL statements using parameters.
我发现这些天大多数人都没有在SP中添加太多逻辑。相反,它们只是使用参数的标准SQL语句的集合。
#3
Just searching for SQL syntax on the internet has pretty much asnwered any question I've had. If nothing else you can always buy a reference book. I have Transact Sql programming by O'Reilly.
只是在互联网上搜索SQL语法几乎已经解决了我所遇到的任何问题。如果没有别的,你可以随时买一本参考书。我有O'Reilly的Transact Sql编程。
Plus, stored procedures are really just
另外,存储过程真的很公正
CREATE PROCEDURE [PROC_NAME]
AS
BEGIN
--ENTER YOUR SQL CODE HERE
END
#4
I always start with MSDN for Microsoft products.In most of the case they are good.
我总是从MSDN for Microsoft产品开始。在大多数情况下,它们都很好。
And there is nothing much specific to learn from Java side for MSSQL SPs as they are seperate entities existing in DB except invoking it from front end.
从Java端学习MSSQL SP没有什么特别之处,因为它们是DB中存在的单独实体,除了从前端调用它。
I would start here.
我会从这里开始。
#1
Personally there are two ways that I have found to get up to speed quickly.
就个人而言,我发现有两种方法可以快速加速。
- Have real world problems that you need to solve.
- Get a good T-SQL Book. There are numbers of them out there, most of the Microsoft Press ones are good, along with many others.
遇到需要解决的现实世界问题。
获得一本好的T-SQL书。有很多这样的,大多数微软出版社都很好,还有很多其他的。
#2
it depends what you're trying to do really. A good knowledge of SQL is the main requirement. Above that learn about parameters.
这取决于你真正要做的事情。熟悉SQL是主要要求。以上了解参数。
I find most people don't put too much logic in SPs these days. Rather they're just a collection of standard SQL statements using parameters.
我发现这些天大多数人都没有在SP中添加太多逻辑。相反,它们只是使用参数的标准SQL语句的集合。
#3
Just searching for SQL syntax on the internet has pretty much asnwered any question I've had. If nothing else you can always buy a reference book. I have Transact Sql programming by O'Reilly.
只是在互联网上搜索SQL语法几乎已经解决了我所遇到的任何问题。如果没有别的,你可以随时买一本参考书。我有O'Reilly的Transact Sql编程。
Plus, stored procedures are really just
另外,存储过程真的很公正
CREATE PROCEDURE [PROC_NAME]
AS
BEGIN
--ENTER YOUR SQL CODE HERE
END
#4
I always start with MSDN for Microsoft products.In most of the case they are good.
我总是从MSDN for Microsoft产品开始。在大多数情况下,它们都很好。
And there is nothing much specific to learn from Java side for MSSQL SPs as they are seperate entities existing in DB except invoking it from front end.
从Java端学习MSSQL SP没有什么特别之处,因为它们是DB中存在的单独实体,除了从前端调用它。
I would start here.
我会从这里开始。