Man, the most clear and concise instructional video I’ve found. You did a great job with the walk through and really walked us through it. Didn’t have skip a second… I LOVE SQL !!!, I’m happy you’re showing love back to the tech community.
In my opinion, this is the most clear, brief but very explanatory video, just straight to the point. Thanks so much, I managed to complete my assignment with your help.
I often find my self coming back to your channel. Videos are very simple and easy to understand. I am not a full time dev, been trying to get a promotion by developing on the side of my regular work and using the results to speed things up. Thank for the videos and hope you get many more subscribers.
Thank you so much ,I am new to SQL have been trying to create table but it was giving error 208, went through a lot of videos but nothing helped.This is the only video that helped me create my first table. Thank you so much SQL Guy 😊😊
Loved the video. I have a question please : I have a table that has two columns;Id & tag names and another table that has much more info but they have the tagnames in it. I want to query every single element in table 1 to find if it exists in table 2. I want this query to run every 5 minutes. How can I do that? thanks in advance
Thanks, glad you enjoyed it. I'd turn this into a stored procedure and schedule it. For the query, there are a few ways. You could use a cursor to loop through table 1 and query table 2 and depending on the result it do the next step. Alternatively you could use a Left JOIN to search for any missing values. It depends on a number of factors, cursors aren't great and try to avoid them where possible. It also depends on table size etc but I'd look at those two options
I notice you use the abbreviation "tbl" for table. I wrote this in a draft design spec recently and my new boss ("who knew the job inside out") had never heard of such a thing and made me change it to TABLE telling the rest of the team that it wasn't a thing. I feel a sense of vindication that The SQL Guy uses it too.
does anyone know why when I create the table, it doesn't show up under the tables option in the left. I switched the top left thing to the name of my database I was using but it still doesn't show up and I'm not sure how to reopen the query I made under it.
All I get when running something similar is "Incorrect syntax near 'FirstName' _" and no new table to be found. Following exactly what I'm seeing in the video so I'm unsure as to what I'm doing wrong.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Man, the most clear and concise instructional video I’ve found. You did a great job with the walk through and really walked us through it. Didn’t have skip a second… I LOVE SQL !!!, I’m happy you’re showing love back to the tech community.
Thanks for the great comment. Really glad that it helped
In my opinion, this is the most clear, brief but very explanatory video, just straight to the point. Thanks so much, I managed to complete my assignment with your help.
Thanks, thats a great comment. I'm glad the video has helped
I often find my self coming back to your channel.
Videos are very simple and easy to understand.
I am not a full time dev, been trying to get a promotion by developing on the side of my regular work and using the results to speed things up.
Thank for the videos and hope you get many more subscribers.
Perfect tutorial just subbed
I've noticed many SSMS Videos do not describe about the primary key, this has helped thanks
Glad it helped. Thanks a lot
You just gained a subscriber, can’t wait to explore more of your videos..keep up the good work
Glad you enjoyed it! Lots more coming soon
best ever ... finally someone who knows what he's doing...!!!
Thanks, glad you enjoyed it! More to come soon too
You are a best Teacher, thank you
Very nice. Brief and precise videos. It helped me a lot in understanding of table creation with SQL queries.
Excellent, thanks a lot. Glad it helped
Thank you so much ,I am new to SQL have been trying to create table but it was giving error 208, went through a lot of videos but nothing helped.This is the only video that helped me create my first table. Thank you so much SQL Guy 😊😊
Glad it helped you! Long may it continue
You saved my assignment, thank you
Great news
Very helpful, clear and to the point! Many thanks
found this very helpful. thanks
amazing !!!
Finally, understood what is going on with creating tables
Glad it helped, I've got a few more table related tutorials coming out soon too
Thank you for the video, your instruction is way better than my professor explanation.
Glad it helped!
VERY useful thank you
very nice explination. hoping you will upload more video
Thanks, glad you liked it. Yes more coming soon so stay tuned
There’s a hot topic in my company about people saying varchar as ‘varkar’ and ‘varchar’ .. I noticed you said varchar, most of people do the same.
Yes we have similar discussions. Who knows! I guess it changes from country to country. Maybe it's what you hear first!
Great presentation
Thanks, glad you enjoyed it
finally found a tutorial
Thanks man!
No probs
Please, could you help me with a question?
What is the diference between
Create type [...] as table
and
create table ()
?
Thanks
Awesome!
Cheers, appreciate it
Loved the video. I have a question please : I have a table that has two columns;Id & tag names and another table that has much more info but they have the tagnames in it. I want to query every single element in table 1 to find if it exists in table 2. I want this query to run every 5 minutes. How can I do that?
thanks in advance
Thanks, glad you enjoyed it.
I'd turn this into a stored procedure and schedule it.
For the query, there are a few ways. You could use a cursor to loop through table 1 and query table 2 and depending on the result it do the next step.
Alternatively you could use a Left JOIN to search for any missing values.
It depends on a number of factors, cursors aren't great and try to avoid them where possible. It also depends on table size etc but I'd look at those two options
I notice you use the abbreviation "tbl" for table. I wrote this in a draft design spec recently and my new boss ("who knew the job inside out") had never heard of such a thing and made me change it to TABLE telling the rest of the team that it wasn't a thing. I feel a sense of vindication that The SQL Guy uses it too.
I love tbl_ !!!
Any naming convention is better than nothing though so I guess TABLE works too
Thank you
You're welcome, hope they help
Why did you add the [Id] column using ALTER TABLE, when you had already defined [Id] as a column in the CREATE TABLE syntax above it?
does anyone know why when I create the table, it doesn't show up under the tables option in the left. I switched the top left thing to the name of my database I was using but it still doesn't show up and I'm not sure how to reopen the query I made under it.
when inserting percentages into a table, do you set the column up as int?
All I get when running something similar is "Incorrect syntax near 'FirstName' _" and no new table to be found. Following exactly what I'm seeing in the video so I'm unsure as to what I'm doing wrong.
Closed my connection then reopened it and everything worked. Not quite sure why but I won't complain. That you very much sir.
Which software you use? Mysql ?
Microsoft SQL Server
The video isn't clear here
LOL "Unless you're five, nobody cares about half years"
Glad my joke made someone laugh!
Don't know how all have commented but bro it is impossible to see anything what u r displaying u should use Magnifier
Yes, I've changed that with later videos. Thanks for the feedback though
Hi nice work, by the way can you help me how to create table operator in sql developer
I've got a tutorial on SQL Operators. Let me know if that helps
video good
How can i insert adress
You could have at least zoomed into the screen so we could see what your typing
Video 🎥 and voice is not clear.
Knowledge is best but volume is very slow this video
It doesn't work
It does work. Which bit isn't working for you
🤥🤥🤥
🤥🤥🤥
🤥🤥🤥