Script to compare data between two tables
- Kunal Ranpura
- Jul 28, 2019
- 1 min read
-- Show data in table dbtest02 that do not exists in dbtest01
select * from dbtest02.dbo.article
except
select * from dbtest01.dbo.article
top of page
bottom of page
-- Show data in table dbtest02 that do not exists in dbtest01
select * from dbtest02.dbo.article
except
select * from dbtest01.dbo.article
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...
--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...
Comentários