Monday, 19 July 2021

Sql Query Mail

 send queries to mail daily schedule to on time

https://www.brentozar.com/archive/2014/10/send-query-results-sql-server-agent-job/

query

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Case studies

 https://drive.google.com/drive/folders/1uOX7A6r5SDN6NXhVtHc4lNWRYOwjhtE1

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • interview Harsco(enviri)
     Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
  • Duplicate records find and delete
     Check duplicate count based on 3 columns combo select EMPID,FORMinfoID,FormName,Count(*) as counts from tbl_FilesMigrationLogs  group by Em...