I'm looking for tips / tricks for everyday usage of 0xDBE. Thougth maybe a general discussion of tips and tricks that everyone has figured out may help out several users
I am using MSSQLServer and have been using management studio for database management, just for some background.
What I am trying to figure out right now is how to just query a table without having to fully qualify it. For example, say I have several databases connected. I want to query all employees on the employee table in myDB.dbo.employees.
I can do this by using "SELECT * FROM myDB.dbo.employees"
but what i want to do is query using "SELECT * FROM employees"
In management studio I can do this just by selecting the schema, then right-clicking for a new query.
Also, if anyone knows of a keyboard shortcut to execute a query. I'm sure there is one but I don't know what it is.