How to view ddl in sql server Videos

• 1. Refresh View Definition in SQL Server - SQL Server Tutorial
• 2. SQL Server Programming Part 16 - DDL Triggers
• 3. Find Text in All objects definition in SQL Server - SQL Server Tutorial
• 4. Introduction To Database & SQL Server- DDL & DML Command in Hindi & English
• 5. How to Disable/Enable DDL and DML Triggers in SQL Server - TSQL Interview Question
• 6. SQL SERVER 6 --- DDL,DROP,DELETE,UPDATE,INSERT

Refresh View Definition in SQL Server - SQL Server Tutorial

User Comments

Kris Maly commented on 11 Jul 2015

Thanks for educating the community Click the link to view the script Refresh View Definition by using sp_refreshview in SQL Server //www.techbrothersit.com/2015/02/refresh-view-definition-by-using.html Thanks a bunch

krismaly commented on 09 Mar 2015

Nice video on topic Refresh View Definition and narrator has good knowledge on topic and explained very well and recommend others to watch. Thanks for educating the community Please keep producing such videos

Kris Maly commented on 11 Jul 2015

Important point is whenever base table is altered to view the view user to refresh by using Exec sp_refreshview ViewName

SQL Server Programming Part 16 - DDL Triggers

User Comments

shareef 4518 commented on 16 Nov 2015

i have a table with the column name minimumStockLevel, how can i fire a trigger when it reaches to minimum level?

shareef 4518 commented on 30 Nov 2015

Thank you :)

WiseOwlTutorials commented on 18 Nov 2015

+shareef 4518 You could add an after update trigger to the table, checking if the stock level has reached its minimum level and then perform whatever code is necessary. An after update trigger is an example of a DML, rather than a DDL trigger. DML triggers are covered in this video https://youtu.be/WBmE4Utu6P4Hope that helps!

Bee Honey commented on 15 Dec 2014

That is a very good explanation and demo thank you for sharing...:) 

WiseOwlTutorials commented on 16 Dec 2014

You're welcome and thank you for watching!

Find Text in All objects definition in SQL Server - SQL Server Tutorial

User Comments

krismaly commented on 09 Mar 2015

Thanks for clearly explaining sys.sql_modules and syscomments with an example. Keep doing some more such short videos on sys... Thanks

TechBrothersIT commented on 10 Mar 2015

+krismaly Thanks Kris, for watching the videos and kind words. Sure will do more videos. Made some Excel related videos over the weekend. Would love to hear from you about them.

Introduction To Database & SQL Server- DDL & DML Command in Hindi & English

User Comments

Shaik Annu Ahmed commented on 05 Jul 2015

nice explanation superb good job can i have a favor of getting the ppt if u want to just mail me at [email protected]

Shaik Annu Ahmed commented on 05 Jul 2015

wht's the difference between truncate and delete and update and alter by using alter i can update know

Aditya Konarde commented on 29 Jun 2015

Sql is structured query language... Not sequential query language.

How to Disable/Enable DDL and DML Triggers in SQL Server - TSQL Interview Question

User Comments

krismaly commented on 09 Mar 2015

Narrator know the subject very well and explained Disable/Enable DDL and DML Triggers clearly with examples. Anybody would learn from this video. Thanks a lot for educating community

Kris Maly commented on 11 Jul 2015

Thanks for educating us Script How to Disable/Enable DDL and DML Triggers in SQL Server //www.techbrothersit.com/2015/02/how-to-disableenable-ddl-and-dml.html Thanks alot

SQL SERVER 6 --- DDL,DROP,DELETE,UPDATE,INSERT

User Comments

Berh Elektrik commented on 26 Nov 2014

teşekkürler hocam