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

Сентябрь 11, 2017

Промокод на скидку 15% на все курсы ITVDN- H94BCAB
Полные видео курса- https://itvdn.com/ru/video/ssms_tsql?utm_source=yb_promo_ssms

Мы продолжаем знакомство с процедурными расширениями языка Transact-SQL. В этом уроке речь пойдет о курсорах, хранимых процедурах и пользовательских функциях. Вы научитесь создавать свои процедуры и функции.

Благодарим всех за лайки, перепосты, добавление в избранное!

http://itvdn.com – видеопортал по обучению программированию

А также подписывайтесь на нас в социальных сетях:

https://vk.com/itvdn
https://www.facebook.com/ITVDN.EDU
https://twitter.com/ITVDN/
https://www.linkedin.com/company/itvdn
https://plus.google.com/u/0/ ItvdnEDU...

Свои предложения присылайте на почту: [email protected]

21 9

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

comments powered by Disqus

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

1268 54

395,650 просмотров

8:4

Clustered vs. Nonclustered Index Structures in SQL Server

Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries.

Blog post on primary key vs. the clustered index:
http://voluntarydba.com/post/2012/10/02/The-Primary-Key-vs-The-Clustered-Index.aspx

CREATE INDEX statement reference:
http://technet.microsoft.com/en-us/library/ms188783.aspx

ALTER INDEX statement reference:
http://technet.microsoft.com/en-us/library/ms188388.aspx

Index navigation internals by example:
http://sqlblog.com/blogs/paul_white/archive/2011/08/09/sql-server-seeks-and-binary-search.aspx

Sample index data is from the AdventureWorksLT2008R2 sample database:
http://awlt2008dbscript.codeplex.com/releases/view/46169

Visit my channel for more database administration videos:
https://www.youtube.com/voluntarydba

Subscribe to get notified about my latest videos:
https://www.youtube.com/voluntarydba?sub_confirmation=1

Read additional content on my blog:
http://voluntarydba.com

Follow on Twitter:
https://twitter.com/voluntarydba

Like on Facebook:
https://facebook.com/voluntarydba

6360 82

318,631 просмотров

13:50

SQL. 1. Введение

1 урок курса по SQL — языку программирования для оперирования реляционными базами данных.

В этом уроке я расскажу о том, что такое реляционная база данных и о структуре таблиц в таких базах..

JOIN QUIZGROUP PARTNER PROGRAM: http://join.quizgroup.com/.

3529 92

278,788 просмотров

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

274,199 просмотров