说明:
In this comprehensive video you will learn the features of SQL Server Management Studio (SSMS). You will start with connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will learn about the many feature of SQL Server Management Studio. Install SQL Server Developer Edition: https://www.youtube.com/watch?v=05ZivSteGJg Install SQL Server Management Studio (SSMS) https://www.youtube.com/watch?v=CqpURYqK_wU SQL Server Management Studio (SSMS) | Full Course TABLE OF CONTENTS 0:00 - Intro 0:26 - Installing SSMS 0:09 - Introduction and Prerequisites 1:19 - Connecting to SQL Server 3:15 - Multiple Connections 4:12 - Different Types of Connections 6:08 - Object Explorer 8:51 - Opening a Query Window 9:33 - Exploring the Query Window 10:54 - Executing SQL 12:43 - Executing SQL with F5 13:18 - SQL Intellisense/Autocomplete 14:30 - Multiple SQL Statements 16:04 - RowCount 16:49 - Multiple Query Windows 17:17 - Database Objects in the Object Explorer 18:10 - Dragging a Table into SQL 18:31 - Back to Rowcount 19:13 - Scripting a Table to a New Window 20:54 - Scripting a View to the Clipboard 22:07 - Errors and Red Squiggly Underlines 22:23 - Intellisense - Refresh Local Cache 24:14 - Altering a View 24:45 - Saving Files 25:41 - Opening a File 26:24 - Docking a Window 27:12 - Previewing Records 27:29 - Editing Rows 29:23 - Creating a New Table 29:51 - Properties Window 30:44 - Refreshing the Object Explorer 31:18 - Scripting from an Object Window 32:07 - Script Table as Insert 33:01 - Dragging Columns into Query 33:52 - View Dependencies 34:24 - Table Properties 35:00 - View Designer 35:52 - View Dependencies 36:44 - Script a Stored Procedure 37:36 - Script the Execute of a Stored Procedure 38:14 - Scripting a Function 39:01 - Database Security 40:06 - Server Security 41:50 - Other Server Folders 42:30 - Job Activity Monitor 43:48 - Job Activity Monitor - Auto Refresh 44:32 - Actual Execution Plan 45:52 - Live Statistics 46:14 - Include Client Statistics 47:01 - Parse Query 47:50 - Estimated Execution Plan 48:36 - Query Options 49:23 - Results to Grid, Text, and File 50:12 - Copy Results to Excel 51:38 - Code Snippets 53:41 - Surround With 54:22 - Other Right Click Options 55:58 - Pinning Windows 56:21 - Template Browser 1:00:12 - Adding Custom Templates 1:01:19 - SQL Profiler 1:04:34 - Azure Data Studio 1:05:27 - Increasing Grid Fonts 1:07:27 - Line Numbers and Line Wrap 1:09:16 - Query Shortcuts 1:10:02 - SP_Help 1:10:54 - Projects and Solutions 1:12:34 - Vertical Editing 1:14:04 - Help Documentation - F1 1:14:52 - Splitting the Query Editor 1:15:51 - Object Explorer Details 1:17:31 - Registered Servers 1:19:40 - Database Reports 1:20:23 - Color Coded Connections 1:21:39 - Conclusion YOUTUBE NEWS UPDATES https://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS https://www.sqltrainingonline.com/ SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! https://www.youtube.com/user/sqltrainingonline?sub_confirmation=1 SUBSCRIBE TO OUR EMAIL LIST! https://www.sqltrainingonline.com/ LET'S CONNECT! LinkedIn: http://linkedin.com/in/joeyblue SQLTrainingOnline: https://www.sqltrainingonline.com/
准备下载方式
http://unidownloader.com 网站是单独下载视频或音轨的最佳方式。如果您想避免安装程序和扩展。
UDL Helper 扩展是一个方便的按钮,嵌入YouTube、Instagram和OK.ru网站,用于快速下载内容。
UDL Client(适用于 Windows)支持900多个网站、社交网络和视频托管网站的最强大解决方案。包括源中可用的任何视频质量。
UDL Lite–从移动设备访问网站的便捷方式。借助此功能,您可以将视频直接下载到智能手机上。
最佳质量格式为全高清(1080p)、2K(1440p)、4K(2160p)和8K(4320p)。屏幕分辨率越高,视频质量也越高。然而,还有其他因素需要考虑:下载速度、可用空间和设备性能。
浏览器/电脑不应完全冻结!如果发生这种情况,请通过视频链接进行报告。有时视频无法以合适的格式直接下载,因此我们增加了将文件转换为所需格式的功能。在某些情况下,此过程可能会主动使用计算机资源。
您可以使用网站或pwa应用程序 UDL Lite 将视频下载到智能手机上。也可以使用 UDL Helper 扩展通过二维码发送下载链接。
最方便的方法是使用UDL Client 程序,该程序支持将视频转换为MP3格式。在某些情况下,MP3 也可以通过 UDL Helper 扩展下载。
此功能在 UDL Helper 扩展中可用。确保在设置中选中“显示视频快照按钮”。相机图标应出现在播放器的右下角“设置”图标的左侧。单击它时,视频中的当前帧将以 JPEG 格式保存到您的计算机中。
完全不要花钱。我们的服务对所有用户都是绝对免费的。没有PRO订阅,下载视频的数量或最大长度没有限制。