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 8086If 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?)
1875after 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
Explain about sql server login?
What is resource db in sql server?
Explain what are commit and rollback in sql?
What are the types of indexing?
Explain indexing and what are the advantages of it?
What is difference between getdate and sysdatetime in sql server 2008?
What does it mean to normalize data?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What happens if null values are involved in boolean operations?
What type of locking occurs during the snapshot generation? : sql server replication
What is the difference between a primary key and a unique key? Are they the same?
What is the purpose of indexing?
Explain the microsoft sql server delete command? : SQL Server Architecture
Do comments need to go in a special place in sql server 2005?
How do I create a stored procedure in sql server?