your are really good at this, you are not in a rush you take your time and explain every step of the way. Your really helping with this good work. No matter how tough the topic once i go through you tutorial i understand perfectly
Thank you so much for posting this video. I have a final exam coming up and I've been leaning heavily on your videos to get me through this semester of SQL Server 2012 !
@15:43...So can I think of it like this... If new row that is trying to be inserted DOES HAVE a DateOfDeath in the Actor table then send them the error message. If however, the ActorID of the row trying to be inserted does not have a DateOfDeath in the Actor table, then rows get inserted from `tblActor` to the `inserted` table. And then from the `inserted` table they get inserted into the `tblCast` table Do I have that right? Is that basically what is going on behind the scenes?
Hi, Your online tutorial is really good, clear and efficient. the only problem is when I try to open your 'Movie' database which I download from your website as .sql file using SQL Server 2012, the queries are completed with errors. The result is that I only get few tables which is far form complete. Do you have any solutions? Thanks. Oh, by the way, when I open the movie.sql file , there is a error box saying something like " some bites are replaced with .... saving will not keep the original content" I don't know whether this gives you additional clue.
Hello Andy, thanks fro your these videos, they are really educating. I have an update version of Movie data that was used in this video. i do get an error : The column 'FullName' cannot be modified because is it either a computed column or is the result of a union operator. How do i get around this error message. hope to hear from you soon.
Hi Jose, you can run Python code using the sp_execute_external_script system stored procedure,. You might find this page useful docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15 as it explains the pre-requisites for executing Python in SQL Server, I hope it helps!
I want to write a query in trigger like: whatever i updated/deleted/inserted in table 1 that updated old data of table 1 should transfer to table 2... how can i write? please help
Hi, your tutorial are really good .I have one doubt in this tutorial how we are able to rollback because we never begin transaction anywhere pls somone reply thanks in advance
My TSQL test is tomorrow and your videos are my lifeline. Thanks a lot for your work.
Good luck with your test!
your are really good at this, you are not in a rush you take your time and explain every step of the way. Your really helping with this good work. No matter how tough the topic once i go through you tutorial i understand perfectly
This man is an actual legend
:D thanks Emiel!
Indeed
Thank you so much for posting this video. I have a final exam coming up and I've been leaning heavily on your videos to get me through this semester of SQL Server 2012 !
sir very quality teaching for SQL tutorials.....awesome.....all your videos are very crystal clear....thanx a lot...thnx...
Your videos are super simple and easy to understand! Thank you :)
EXCELLENT AS USUAL Andrew!!
Thanks a lot
Thanks! :D
Good work! Keep it up.
this tutorial is absolutelly great, keep up the good work, really helpfull
Thank you this really helps me prepare for my exam!
great explanation! thanks a lot!
Thanks for the video. It helped me a lot.
Thank you.....
You're welcome again!
thank u again i know ur vids are a bit older but still useful
Thank you!
That was great
Those poor Star Trek red shirt people :-( ......LOL, great video Andrew, thanks :-)
'tom cruise as random redshirt' hahaha
@15:43...So can I think of it like this... If new row that is trying to be inserted DOES HAVE a DateOfDeath in the Actor table then send them the error message.
If however, the ActorID of the row trying to be inserted does not have a DateOfDeath in the Actor table, then rows get inserted from `tblActor` to the `inserted` table. And then from the `inserted` table they get inserted into the `tblCast` table
Do I have that right? Is that basically what is going on behind the scenes?
Thx for the video. One question - how could you rollback transaction (15:42) within trigger while none was opened ?
Good Article. Thank you.
Could you please share knowledge on Locking and Isolation levels in SQL Server
Hi, Your online tutorial is really good, clear and efficient. the only problem is when I try to open your 'Movie' database which I download from your website as .sql file using SQL Server 2012, the queries are completed with errors. The result is that I only get few tables which is far form complete. Do you have any solutions? Thanks.
Oh, by the way, when I open the movie.sql file , there is a error box saying something like " some bites are replaced with .... saving will not keep the original content" I don't know whether this gives you additional clue.
Videos are great.Please share the movie database link. Thanks..
***** Thank you :).
Hello Andy, thanks fro your these videos, they are really educating. I have an update version of Movie data that was used in this video. i do get an error : The column 'FullName' cannot be modified because is it either a computed column or is the result of a union operator. How do i get around this error message. hope to hear from you soon.
Great! Can the BEGIN END include running some python code?
Hi Jose, you can run Python code using the sp_execute_external_script system stored procedure,. You might find this page useful docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15 as it explains the pre-requisites for executing Python in SQL Server, I hope it helps!
Can i use both the After and Instead Of triggers at the same time?
I want to write a query in trigger like: whatever i updated/deleted/inserted in table 1 that updated old data of table 1 should transfer to table 2... how can i write? please help
Hi, your tutorial are really good .I have one doubt in this tutorial
how we are able to rollback because we never begin transaction anywhere
pls somone reply thanks in advance
WiseOwlTutorials Thank u thanks a lot keep doing this great stuff
Sir can u tell us ,HOW to send Email using SSMS ??
*****
sir can u please upload a video on this topic,means how to configure email?
Please..