Mr. Liu thank you for your original video on Identity, it was the most concise and clear training i have found so far. The overview explanation of what each process was physically doing really helped me to look at coding different and it also changed how I am learning about coding. Thanks again.
This has really helped me, Frank. I used to dread many to many and one to many. It never really sunk in. I've bought the full course to support your work. Thank you so much and keep it up!
Frank, Thank you fort another great video tutorial. I have one question, is there a reason why you use an auto incrementing PK on the linking tables for the many to many relationships vs a composite PK based on the two foreign keys? Just curious.
Either way is fine. But if you are concerned about simplicity and flexibility and if you don't mind a little bit data redandency then using auto increment is good. If you are more concerned about data integrity and want to avoid redundancy, then a composite key could be better. I personally value flexibility and simplicity hence I like using auto increment column as PK.
get followng message as result of drop database FirstDB: Msg 3702, Level 16, State 4, Line 1 Cannot drop database "FirstDB" because it is currently in use.
![Beginner to T-SQL [Full Course]](http://i.ytimg.com/vi/cACat4KNncg/mqdefault.jpg)
Mr. Liu thank you for your original video on Identity, it was the most concise and clear training i have found so far. The overview explanation of what each process was physically doing really helped me to look at coding different and it also changed how I am learning about coding. Thanks again.
Thank you for the good words! I am glad my courses have been helpful!
The views nuember of this course is so underrated. I learned so much from this, thanks Mr. Liu!
I love the analogy many students remember one teacher.......Cheers Frank, that made it stick!
This has really helped me, Frank. I used to dread many to many and one to many. It never really sunk in. I've bought the full course to support your work. Thank you so much and keep it up!
Thank you Frank Liu 👍
Thank you, your courses are awesome. ❤
thanks, very good course
Excelent! Thanks for your time!
I am very glad I bought this full course on Udemy ❤😊. Thanks for sharing your knowledge, Frank.
Thanks
Big thanks to you for sharing this valuable learning
Hello Frank. Can you teach us how to create multiple servers to practice backups and restore
Hi upload full course about SQL DBA
Frank, Thank you fort another great video tutorial. I have one question, is there a reason why you use an auto incrementing PK on the linking tables for the many to many relationships vs a composite PK based on the two foreign keys? Just curious.
Either way is fine. But if you are concerned about simplicity and flexibility and if you don't mind a little bit data redandency then using auto increment is good. If you are more concerned about data integrity and want to avoid redundancy, then a composite key could be better.
I personally value flexibility and simplicity hence I like using auto increment column as PK.
@@FrankLiuSoftware Thank you for the reply!
get followng message as result of drop database FirstDB:
Msg 3702, Level 16, State 4, Line 1
Cannot drop database "FirstDB" because it is currently in use.
You need to kill the process first
@@FrankLiuSoftware ruclips.net/video/buA_SOy3uok/видео.html
Very easy to understand, Thank You!
Hi,
Thanks for your teaining,
You had the roughly 7-hour traing for SQL Server and it is unavilable. We have to pay money for that.
BR
I am sorry about that. It was published by mistake.
Bro you totally could have won that lawsuit against Reno
Hi Liu Thanks a Lot for uploading the video..i am expecting advanced sql concepts videos from you...