Answer Posted / elumalai.k
select @@rowcount
select count(*) from tablename
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
Explain about Joins?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Can we add a cpu to sql server?
Please explain what is “asynchronous” communication in sql server service broker?
What is the return type of executeupdate ()?
How to access the deleted record of an event?
What are the restraints imposed on the table design by a merge replication?
Using the customer, and order table in northwind database, please write a query to produce xml?
Explain “@@rowcount” and “@@error” in sql server?
What are the options which must be set to allow the usage of optimistic models?
Explain primary key, foreign key and unique key?
What are the new security features added in sql server 2012? : sql server security
What is an example of a foreign key?
Explain timestamp datatype?
How to include date and time values in sql statements?