Mail us : admin@kokchoon.com
kokchoon.com

Menu

Skip to content

Monthly Archives: February 2021

05Feb/21

C# DateTime Format

February 5, 2021C#kokchoon

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…

04Feb/21

SQL delete statement where date is greater than 30 days

February 4, 2021Databasekokchoon

replace {TABLE} with the target table name replace {DATE} with the date field.

04Feb/21

Executing set of SQL queries using batch file?

February 4, 2021Databasekokchoon

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…

04Feb/21

How to Move Database Files to Another Drive

February 4, 2021Databasekokchoon

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…

Recent Posts

  • Privacy Policy – Malaysia Calendar
  • Privacy Policy – JB Traffic
  • C# DateTime Format
  • SQL delete statement where date is greater than 30 days
  • Executing set of SQL queries using batch file?

Recent Comments

    Archives

    • December 2022
    • June 2022
    • February 2021
    • May 2020
    • April 2019
    • February 2019

    Categories

    • C#
    • Database
    • Privacy Policy
    • Sharepoint
    • Windows

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Copyright © kokchoon.com
    Powered by WordPress , Designed and Developed by templatesnext
    MENU