Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
SELECT CASE WHEN CAST(GETDATE() AS DATE) = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) THEN 1 ELSE MAX ([' + @ColumnName1 + ']' + ' ) END Output' + ' FROM [dbo].[' + @tableName + ']'
select max (cast(ref as int)) as ref from table1 order by ref
|How to use odbc in vb to connect to ms sql||14||34|
|SQL Syntax help for passing multi-value parameter to a substring up until the first space||2||19|
|Query / Window function ?||3||15|
|ms sql last 8 weeks as columns||5||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!