Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
6 6494If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
3 3852Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
1421after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
1678IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
1322
Do you know what is rank function?
Using the customer, and order table in northwind database, please write a query to produce xml?
What are the advantages of mirroring?
What is subquery explain with example?
What happens if null values are involved in boolean operations?
What is the simplest way to create a new database in ms sql server?
How to list all columns in a table using odbc_columns()?
What is clr ddl trigger?
how many clustered indexes can be created on a table? : Sql server database administration
Do you know what are the reporting services components?
What is indexed view? How to create it?
What is optimization and its types?
How to run sql server 2005 books online on your local system?
How to create database with physical files specified in ms sql server?
Can you explain various data region available in ssrs with their use?