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 8082If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
3 5025Insert 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?)
1865after 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?
2093IF 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
1805
How to check table values in sql server?
What are sparse columns?
Explain how to integrate the ssrs reports in application?
Can you leave a union at any time?
what is difference between view and Dip.
What do you understand by mirroring and mention the advantages of the mirroring?
What encryption security is available in sql azure?
What is sql server transaction log file?
what information is maintained within the msdb database? : Sql server administration
What is the order in which the sql query is executed?
Why do we use stored procedures in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to automatically create a log when an exception is being received into SQL Server?
What is bit data type?
Which tools are available to manage SQL Azure databases and servers?