1 day ago · software

create12

T-SQL script for DBVisualizer to count rows added in last 45 days

1 day ago · software

create11

sql declare @sql varchar8000 select @sql = '' select @sql = @sql + 'select ''+name+'' , count from '+name+ ' where INTERNTIMESTAMP >= dateadddd,-45,getdate unio...

2 days ago · software

compare5

SQL Script sql -- Declare variables for schema UIDs run once DECLARE @uid1 int, @uid2 int SELECT @uid1 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_1' SEL...

2 days ago · software

compare4

sql -- First get the user IDs once optional, for readability DECLARE @uid1 int, @uid2 int SELECT @uid1 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_1' SELE...