Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 18359 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / alex
string myquery="SELECT * FROM [Employee] WHERE
([Table_Field]<=10 AND [Table_Field]<=20)"
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What command must you use to include the not null constraint after a table has already been created?
What is the log shipping?
How to assign null values to variables or columns?
Write a SQL query in order to merge two different columns into single column?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
what is an index? : Sql server database administration
Do you know the different ddl commands in sql?
explain how to create a new schema in a database? : Sql server database administration
How to make a remote connection in a database?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is pessimistic concurrency?
What are number line correlation administrators will use while working with a subquery?
How to use group functions in the select clause in ms sql server?
What are the purpose of Normalisation?
What is the difference between a unique key and primary key?
