dynamic SQL

1 month ago · software

sql10

Setup sql SET VERIFY OFF FEEDBACK OFF HEADING OFF ECHO ON SET SERVEROUTPUT ON -- Capture argument or default to empty string no prompt COLUMN p_flag_col NEW_VA...

#SQL #PL/SQL #Oracle #functions #dynamic SQL #DBMS_OUTPUT #script automation
1 month ago · software

create12

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

#SQL #dynamic-sql #ASE #T-SQL #dateadd #union-all #dbvisualizer #query-generation
1 month ago · software

create11

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

#SQL Server #T-SQL #dynamic SQL #sysobjects #database scripting #row count