SQL Server
Seek for column name all objects name
select s.name from sysobjects sinner join sys.schemas c on c.schema_id = s.uidinner join syscolumns l on l.id = s.idwhere l.name like '%produc%key%'
Date Functions - Day / Month / Minutes
--// Show the last date less 1 minuteselect DATEADD(MINUTE, -1, DATEADD(DAY,1,getdate()))--// Show the first day from the last monthSelect DateAdd(mm, DateDiff(mm,0,GetDate()), -1) as [Último dia no mês Anterior]--// Show the last day from the last monthSelect DateAdd(mm, DateDiff(mm,0,GetDate()),...