sql query to return differences between two tables
( SELECT * FROM table1 EXCEPT SELECT * FROM table2) UNION ALL ( SELECT * FROM table2 EXCEPT SELECT * FROM table1)
sql-server-2008
How to create a table from select query result in SQL Server 2008 [duplicate]
Use following syntax to create new table from old table in SQL server 2008 Select * into new_table from old_table
SQL Server query to find all permissions/access for all users in a database
This is my first crack at a query, based on Andomar’s suggestions. This query is intended to provide a list of permissions that a user has either applied directly to the user account, or through roles that the user has. /* Security Audit Report 1) List all access provisioned to a sql user or windows … Read more
How to drop all tables in a SQL Server database?
You can also delete all tables from database using only MSSMS UI tools (without using SQL script). Sometimes this way can be more comfortable (especially if it is performed occasionally) I do this step by step as follows: Select ‘Tables’ on the database tree (Object Explorer) Press F7 to open Object Explorer Details view In … Read more
SQL Server Management Studio, how to get execution time down to milliseconds
What you want to do is this: set statistics time on — your query set statistics time off That will have the output looking something like this in your Messages window: SQL Server Execution Times: CPU time = 6 ms, elapsed time = 6 ms.
SQL Server Configuration Manager cannot be found
If you happen to be using Windows 8 and up, here’s how to get to it: The newer Microsoft SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program. It is not a stand-alone program as used in the previous versions of Microsoft Windows operating systems. SQL Server Configuration Manager doesn’t appear … Read more
SQL Server. How to refresh the intellisense? [duplicate]
Ctrl + Shift + R will refresh Intellisense.
How to write UPDATE SQL with Table alias in SQL Server 2008?
The syntax for using an alias in an update statement on SQL Server is as follows: UPDATE Q SET Q.TITLE = ‘TEST’ FROM HOLD_TABLE Q WHERE Q.ID = 101; The alias should not be necessary here though.
“Prevent saving changes that require the table to be re-created” negative effects
Tools –> Options –> Designers node –> Uncheck “ Prevent saving changes that require table recreation “.
Check if a row exists, otherwise insert
I assume a single row for each flight? If so: IF EXISTS (SELECT * FROM Bookings WHERE FLightID = @Id) BEGIN –UPDATE HERE END ELSE BEGIN — INSERT HERE END I assume what I said, as your way of doing things can overbook a flight, as it will insert a new row when there are … Read more