SSMS Tutorial (SQL Server Management Studio) - Feature Demonstration
ฝัง
- เผยแพร่เมื่อ 28 พ.ค. 2024
- SSMS (SQL Server Management Studio) is a popular SQL editor that comes with SQL Server.
It has a range of features that let you work with SQL and databases more effectively. Yes, it can run SQL and show the tables in your database, but you can do much more with it.
In this video, you'll see a range of features of SSMS, starting with connecting to the database, and including running queries, scripting objects to SQL, and more.
See the timestamps below for the full list of features included in the video.
Timestamps:
00:00 Start
00:40 Connect
01:14 Main window
01:40 Object explorer
01:57 New query editor
02:58 Execute query
03:33 Object explorer refresh
04:51 Run multiple queries
05:18 Select query
05:37 Intellisense
07:38 New tab
08:56 Script new tab
09:58 Save script
10:28 Open script
10:50 Dock windows (tab groups)
11:40 Results to text, grid, or file
12:43 Copy to Excel
/// RESOURCES
📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: www.databasestar.com/sql-road...
✍️ Learn how to design a database: databasestar.mykajabi.com/edd
📧 Contact me here: www.databasestar.com/contact/
📝 Database Design Exercises: bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: bbrumm.gumroad.com/l/oqggau - วิทยาศาสตร์และเทคโนโลยี
I've been struggling with how to make query with sql in ssms, but it seems clear after watching this video. Thanks a lot
Glad it helped!
This video was great! Will definitely watch more of his videos on SQL.
Awesome, thank you!
Thank you so much. You have been helpful
No problem, glad it helped!
Great Video I learned a lot. Keep making good videos.
Glad to hear it!
woww your talent is god gifted
Thanks a lot!
This was very helpful..thank you
Glad it was helpful!
I wish I could like this video a hundred times. Great great content!
Thanks, glad you like it!
Hi, thanks for this video - as i am completely new to working on the server management studio - is there a way to export entire tables to excel at once?
No problem! You should be able to right-click on a table and select Export Data, then follow the steps.
Really good video.
Thanks!
Can SSMS 2008 be used to manage SQL Server 2019 or newer? Cos I still love the UI of SSMS 2008
Good question. I assume it can. But I’m not sure.
Hi, thank you for this. However, I installed the ssms and after creating a new database, each time I try to import data into the database, the import and export wizard doesn’t pop up. I’ve tried uninstalling and reinstalling to no avail. Can you help out on what could be wrong? Thank you.
You're welcome! Oh that's a strange one. I'm not sure why that would happen unfortunately.
Hey there, God bless your efforts.
I a a newbie sql learner with a simple enquiry.
Where can i find a table with its properties that i have already created in sql managment studio?
Thanks for taking care of this.
Thanks! You can find your existing tables using the panel on the left of the window. You can expand the entries to see what tables have been created.
Thank you 😊
You're welcome!
Thank you.
You’re welcome
Can we create materialized view by using ssms
I think materialised views are only available on Oracle and not SQL Server.
I want to write a new code,How do i open a New tab on SSMS .?
You can click on the New Query button on the toolbar.
hello please say best sql server for docker?
What do you mean?
Hey, would you be able to assist me on my homework for SSMS? im willing to pay
What homework would you have with SSMS? I can help answer questions but won't be able to do your actual homework!
Hi … I can assist you if still you are looking for