terça-feira, 20 de julho de 2021

Procurar objetos (existeem)

EXEC sp_MSforeachdb 'USE [?]   
SELECT distinct
OBJECT_NAME(cmt.ID) OBJECT_NAME,
db_name() banco,
Case
  WHEN (obj.xtype = ''P'')  THEN ''Stored Procedure''
  WHEN (obj.xtype = ''V'')  THEN ''View''
  WHEN (obj.xType = ''TR'') THEN ''Trigger''
  WHEN (obj.xType = ''FN'') THEN ''Função''
  WHEN (obj.xType = ''U'')  THEN ''Tabela''
  ELSE ''Outros''
END TipoEstrutura
FROM        SYSCOMMENTS cmt
inner join sysobjects obj
on cmt.ID = obj.id
WHERE        TEXT LIKE ''%tbdw0020%'' '


Python - Excel via win32com

import win32com.client
excel = win32com.client.Dispatch("Excel.Application")
excel.DisplayAlerts = False
excel.Visible=False
doc = excel.Workbooks.Open('D:\\Users\\735906\\Downloads\\ticket_FieldService_20190925_055000.xlsb')
doc.SaveAs(Filename="D:\\Users\\735906\\Downloads\\ticket_FieldService_20190925_055000.csv",FileFormat=6)
doc.Close()
excel.Quit()