Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
UPDATE MyTable SET CCExpDate = RIGHT('00' + Left(CCExpDate,2),2) + Right('00' + Cast((Cast(Right(year(getdate()),2) as smallint) + 2) As Varchar),2) WHERE (Cast(Left(CCExpDate,2) as smallint) <= (Month(GetDate())-1) AND Cast(Right(CCExpDate,2) as smallint) <= Cast(Right(Year(GetDate()),2) as Smallint) OR Cast(Right(CCExpDate,2) as smallint) < Cast(Right(Year(GetDate()),2) as Smallint) ) AND CCNo like '387845635%'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to restore sql 2005 database on sql 2008 server from mdf when older copy of database already on new server||5||103|
|How can I exclude some wording in a like statement?||39||83|
|Unable to save view in SSMS||21||83|
|Need to merge 3 large tables into one Table in SQL server||2||37|
Join the community of 500,000 technology professionals and ask your questions.