Basic SQL Training - SQL Server sp_help | Quick Tips Ep56

5.0 (3)

23 learners

What you'll learn

This course includes

10.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

sql sp_help tsql ssms sql server management studio sql training online quick hits stored procedure data jobs data jobs SQL Programmer

Full Transcript

In this video I show how to use the SQL Server sp_help procedure to enhance your development. I will walk you through what it is and how you can use it on Tables, Views, and Stored Procedures. I will also show you how to use the shortcut keys ALT+F1 to speed up your development. Finally, I show you how to use is in the development cycle by modifying a view. SQL Server sp_help | Quick Tips Episode #56 TABLE OF CONTENTS 00:00 - Intro 00:08 - sp_help Introduction 01:29 - First use of sp_help 03:43 - Demo of Alt+F1 as a shortcut to sp_help 04:28 - Error using sp_help 06:24 - sp_help on View 07:17 - sp_help on Stored Procedure 07:48 - Using sp_help when modifying a view YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! LinkedIn: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Curso de MySQL intensivo desde cero(Workbench)

⭐ 4.0

6 ratings

12.5 hours

SQL tutorials for beginners/ Oracle Database tutorials.

⭐ 4.0

2 ratings

11.5 hours

Flutter - MySQL Database, API with PHP

Master Flutter & MySQL Integration: From APIs to Dynamic UX! Dive into hands-on tutorials and craft seamless database interactions using Flutter, PHP, and MySQL. Elevate your app development skills with Showbilitix's expert guidance today!

⭐ 5.0

2 ratings

6.3 hours