Monthly Archives: June 2011

Calculate Execution and Cpu Time in SQL 2005

SET STATISTICS TIME ON Select * from TableName — Or Any Query SET STATISTICS TIME OFF It Results: =============== SQL Server parse and compile time: CPU time = 31 ms, elapsed time = 141 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms.

Dynamically add and delete row from html table using jQuery

Here we will use jQuery for Row insertion and deletion. Adding New row: Consider we have following HTML table with ID=”tbl” ID Name Age Action ID Name Age If we want to insert row then we have to add new row to the table. We can add table row in following way.

Page 1 of 11