Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?
Submitted by: AdministratorSELECT count( * ) as totalrecords FROM employee
This will display total records under the name totalrecords in the table employee
use COUNT_BIG
Returns the number of items in a group.
@@ROWCOUNT
Returns the number of rows affected by the last statement.
Use this statement after an SQL select * statement, to retrieve the total number of rows in the table
Submitted by: Administrator
This will display total records under the name totalrecords in the table employee
use COUNT_BIG
Returns the number of items in a group.
@@ROWCOUNT
Returns the number of rows affected by the last statement.
Use this statement after an SQL select * statement, to retrieve the total number of rows in the table
Submitted by: Administrator
Read Online .Net Database Job Interview Questions And Answers
Top .Net Database Questions
| ☺ | Explain How do we separate business logic while creating an ASP.NET application? |
| ☺ | Explain What are good ADO.NET object(s) to replace the ADO Recordset object? |
| ☺ | Explain What is the .NET datatype that allows the retrieval of data by a unique key? |
| ☺ | Explain similarities and differences between the Java and .NET? |
| ☺ | Explain What are cursors? Name four type of cursors and when each one would be applied? |
Top Dot Net Technologies Categories
| ☺ | MSF Interview Questions. |
| ☺ | .Net Architecture Interview Questions. |
| ☺ | ASP.Net MVC Interview Questions. |
| ☺ | Entity Framework Interview Questions. |
| ☺ | C# (Sharp) Programming Language Interview Questions. |
