CIB Point Microsoft SQL Server 2012 хранимые процедуры, функции, триггеры

Май 6, 2014

59 1

3,945 просмотров

comments powered by Disqus

1:8:26

Использование Оконных функций в MS SQL Server 2012, часть 1

Вы все еще используете курсоры? Тогда это видео-урок для Вас!

71 1

2,835 просмотров

17:45

DML triggers in sql server Part 43

In this video we will learn about triggers in sql serevr. There are 3 types of triggers
1. DML triggers
2. DDL triggers
3. Logon trigger

DML triggers are fired automatically in response to DML events (INSERT, UPDATE & DELETE). DML triggers can be again classified into 2 types
1. After triggers (Sometimes called as FOR triggers)
2. Instead of triggers.

After triggers, fires after the triggering action. The INSERT, UPDATE, and DELETE statements, causes an after trigger to fire after the respective statements complete execution. INSTEAD of triggers, fires instead of the triggering action. The INSERT, UPDATE, and DELETE statements, causes an INSTEAD OF trigger to fire INSTEAD OF the respective statement execution.

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/09/dml-triggers-part-43.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/09/part-43-dml-triggers.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

1265 54

394,895 просмотров

15:31

Видеокурс по SQL Essential. Урок 8. Хранимые процедуры. Пользовательские функции

Промокод на скидку 15% на все курсы ITVDN- H94BCAB
Ссылка на полный курс — http://itvdn.com/ru/video/sql-essential?utm_source=yb_promo_sqless

Для того, чтобы оптимизировать работу базы и не отправлять на сервер большие объемы SQL запросов, можно создать хранимую процедуру, которая будет представлять блок кода, хранящийся на сервере для неоднократного запуска со стороны клиента. В этом видео уроке по SQL Вы изучите тонкости написания хранимых процедур, а также научитесь создавать функции, которые также помогут оптимизировать и упростить работу с данными.

137 13

15,686 просмотров

16:50

SQL 2008 Series: Introduction to Stored Procedures

This Video tutorial describes stored procedures. It is a tutorial on 101 of stored procedures. Stored procedures in SQL are very useful in certain situations. This video briefly describes on how to write a stored procedure.

Stored Procedure also called as sprocs are basically a bunch a T-sql statements bundled up.
They are generally called using the EXEC command.

Stored procedures can take one or more parameters.

SQL server also has its own stored procedures. These are called as System stored procedures or system stored procs.
example: sp_who2

If you learn SQL, you will love the concept of stored procedures. These SQL tutorials cover some basic to a little advanced concepts of stored procedures.

http://www.creativecommit.com

147 9

74,761 просмотров

19:7

Scalar user defined functions in sql server Part 30

In this video we will learn about
1. User Defined Functions in sql server
2. Types of User Defined Functions
3. Creating a Scalar User Defined Function
4. Calling a Scalar User Defined Function
5. Places where we can use Scalar User Defined Function
6. Altering and Dropping a User Defined Function

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/09/scalar-user-defined-functions-in-sql.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-30-user-defined-functions.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

698 26

273,735 просмотров