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.
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.
best ever ... finally someone who knows what he's doing...!!!
Thanks, glad you enjoyed it! More to come soon too
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
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 are a best Teacher, thank you
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
You saved my assignment, thank you
Great news
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
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
Very helpful, clear and to the point! Many thanks
found this very helpful. thanks
Thank you for the video, your instruction is way better than my professor explanation.
Glad it helped!
amazing !!!
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!
VERY useful thank you
Great presentation
Thanks, glad you enjoyed it
very nice explination. hoping you will upload more video
Thanks, glad you liked it. Yes more coming soon so stay tuned
Please, could you help me with a question?
What is the diference between
Create type [...] as table
and
create table ()
?
Thanks
Thanks man!
No probs
finally found a tutorial
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
Awesome!
Cheers, appreciate it
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
when inserting percentages into a table, do you set the column up as int?
Thank you
You're welcome, hope they help
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.
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?
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!
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.
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
How can i insert adress
video good
You could have at least zoomed into the screen so we could see what your typing
Knowledge is best but volume is very slow this video
Video 🎥 and voice is not clear.
It doesn't work
It does work. Which bit isn't working for you
🤥🤥🤥
🤥🤥🤥
🤥🤥🤥