谁能为初学者建议一些商店程序练习？ [英] Can anyone suggest some store procedure exercises for beginners?

问题描述

建议一些具有挑战性的练习来学习存储过程

解决方案

创建示例存储过程以插入，更新n删除带参数的记录。



检查存储过程中输出参数的用法。



尝试默认或可选参数并使用如果有价值通过它们在里面



从另一个sp调用一个sp



这些都是在sp。

你可以从SQL PL / SQL的一些基本概念开始，然后从基本类型的存储过程开始。



同样你可以从书店选择书籍你选择sipply阅读书籍5至10分钟并选择书籍作为你的需要，

以下一些书籍/链接是基本的好。

Ivan bayross的PL / SQL

Microsoft SQL Server黑皮书

自学SQL

SQL入门，第2版

http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer .htm [ ^ ]



http://msdn.microsoft.com/en-us/library/bb545450.aspx [ ^ ]



http://www.w3schools.com/sql/default.asp [ ^ ]

Sql Server - 如何在Sql server中编写存储过程 [ ^

Suggest some challenging exercises to learn store procedure

解决方案

create sample stored procedures to insert, update n delete the records with parameter's .

check the usage of output parameter in the stored procedure .

try default or optional parameters and use them inside if there is a value passed

call one sp from another sp

that's all done in sp.

You can start with some basic concept of SQL PL / SQL , then start with basic type of stored procedures.

for the same you can select the book from book store are your choice sipply read the book 5 to 10 min and select the book as your need,
following some books/links are good for the basic.
PL / SQL by Ivan bayross
Microsoft SQL Server Black Book
Teach Yourself SQL
A Primer on SQL, 2nd Edition
http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer.htm[^]

http://msdn.microsoft.com/en-us/library/bb545450.aspx[^]

http://www.w3schools.com/sql/default.asp[^]

Sql Server - How to write a Stored procedure in Sql server[^]

这篇关于谁能为初学者建议一些商店程序练习？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！