CodeSmith Community
Your Code. Your Way. Faster!

Truncate Table without stored procedure TIP!

Latest post 10-31-2007 10:48 AM by mathisr. 0 replies.
  • 10-31-2007 10:48 AM

    • mathisr
    • Top 150 Contributor
    • Joined on 03-05-2006
    • Posts 32
    • Points 490

    Truncate Table without stored procedure TIP!

    I've been trying to truncate tables from NetTiers and came up with the following technique that does not require Stored Procedures.

    DataRepository.Provider.ExecuteNonQuery( CommandType.Text, "Truncate Table myTable");

    Be aware I had to include the following Reference to my project: System.Configuration;

     

    secret
    Filed under:
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems