DELETE FROM %t WHERE [timestamp = 0x%k[ AND %w]][%r[%j%k][%r[%w][%rtimestamp_required]]]
[%k]DELETE FROM %t[ WHERE %w]
UPDATE %t SET {%c=%v,} WHERE [timestamp = 0x%k[ AND %w]][%r[%j%k][%r[%w][%rtimestamp_required]]]
[%k]INSERT INTO %t[({%c,})] VALUES ({%v,})
SELECT TABNAME,TABDESC,NUMCOLS,TABTYPE,TABLABEL,OWNER,COLTYPE,COLWIDTH,COLNULL,COLNAME,COLDESC,COLLABEL,COLSCALE FROM TABLES,COLUMNS WHERE TABNAME=COLTBNM AND TABNAME = %n[ AND OWNER=%o][%r AND OWNER=USER]
select o.name, NULL, count(c.id) , o.type, NULL, u.name from sysobjects o, sysusers u, syscolumns c where u.uid=o.uid and o.id=c.id and (o.type='U' or o.type='V' or o.type='S')[ and substring(o.name,1,DATALENGTH(%n)+abs(ascii(%n)-35)) = %n][ and u.name = %o][%r[ and (u.name=%d or o.type='S')][%r[%j%n and (u.name=user_name() or o.type='S')][%r[%b and u.name=user_name()]]]] group by o.id,o.name,u.name order by o.name, u.name
select c.type, c.length, CHAR( (c.status & 8) + ASCII('Q')), c.name, NULL,NULL,0 from syscolumns c, sysobjects o, sysusers u where o.name = %n and c.id = o.id and u.name = %o and u.uid = o.uid [and UPPER(c.name) = UPPER(SUBSTRING(%s,CHARINDEX('.',%s)+1,255))]
select %s from [%o.]%n
%z!TC COMMIT
%z!TC ROLLBACK
CREATE TABLE %t ({%x,}[%i,timestamp])
%n %f [%g[%b][%r[%e][%rNULL]]]
%n
%n %f [%bnot null][%r[%e][%rnull]]
%n
[%j%s[%z!ES declare @usn varchar(30)declare @yes char(2) select @usn=user_name() if @usn='dbo' or suser_id()=(select suid from master..sysdatabases where dbid=db_id()) begin setuser '%s' select @yes='Y' end else select @yes='N' ]]drop table %t[%j%s if @yes='Y' setuser @usn]
[%j%s[%z!ES declare @usn varchar(30)declare @yes char(2) select @usn=user_name() if @usn='dbo' or suser_id()=(select suid from master..sysdatabases where dbid=db_id()) begin setuser '%s' select @yes='Y' end else select @yes='N' ]]drop view %t[%j%s if @yes='Y' setuser @usn]
