C# DateTime Format
Date and Time in C# are handled by DateTime class in C# that provides properties and methods to format dates in different datetime formats. This article blog explains how to work withRead More…
SQL delete statement where date is greater than 30 days
replace {TABLE} with the target table name replace {DATE} with the date field.
Executing set of SQL queries using batch file?
Save the commands in a .SQL file, ex: ClearTables.sql, say in your C:\temp folder. Contents of C:\Temp\ClearTables.sql Then use sqlcmd to execute it as follows. Since you said the database is remote, use the following syntax (after updating for yourRead More…
How to Move Database Files to Another Drive
ObjectiveTo move the SQL database .mdf and .ldf files to another drive on the server. EnvironmentPrimary Product OS : Windows 2012 ServerPrimary Product Module : Microsoft SQL 2012 Procedure Launch Microsoft’s SQL Server ManagementRead More…