In MySQL there is no case sensitiveness in Schema Names, but In MS SQL there is case sensitiveness in Schema name, ,,if you are using table name , 'SHUBHAM' So You have to mention the table name in same case as you have specified at the time of creation.
Is MySQL syntax are similar to MS SQL syntax?
In MySQL there is no case sensitiveness in Schema Names, but In MS SQL there is case sensitiveness in Schema name, ,,if you are using table name , 'SHUBHAM' So You have to mention the table name in same case as you have specified at the time of creation.
Is set command also used with update in MS SQL ?
It is slightly different as we use Values can be assigned to variables using the SET statement and we can also do updation by using set
If you have more doubts so you can can join our channel