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 3412
What is the maximun sixes of .mdf in sql server 20051 1945
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?3 2278
Insert 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?)669
after 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?908
what is isolation level at dead lock?968
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do612
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
how to overcome kernel isssues
SQL Server Architecture ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
how many no of arguments can be passed in procedures and functions
after 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?
Tell about MOM Tool(Microsoft Operator Manager)?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
tell me the disaster recovery plan
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How you trouble shoot when any job fails
System variable and temporary variables
How to convert a table data in XML format in sql server?