SQL Server find common records in a column shared by two tables

SELECT Number FROM [db1].[dbo].[Table] INTERSECT SELECT Number FROM [db2].[dbo].[Table]


MySQL filter by multiple where values

SELECT * FROM cards WHERE ftCertNumber in (700000004741,

add as many values as you need

SQL Server management studio export results

go into “Query”->”Query Options…”, grid tab, and check “include column headers when copying or saving results”

Right click on grid results and click “Save Results As” and save it.

If your results are not in grid format (which they should be), right click where you write the query, hover “Results To” and click “Results To Grid”

Phone test number

+1 40-VOIP-INFO  (408-647-4636)



calling the 408 number says that “This number has been changed to the 631 number, but either number works.

Create a free website or blog at WordPress.com.

Up ↑