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 3468
What is the maximun sixes of .mdf in sql server 20051 1973
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?3 2308
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?)683
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?928
what is isolation level at dead lock?988
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 do630
How much memory that we are using in Logshipping Concept?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Why do you want to join software field as you have done your BE in Electronics?
SQL Server Architecture ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
how many no of arguments can be passed in procedures and functions
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Delete duplicate rows without using rowid.
Explain Capacity planning to create a database? and how to monitor it?
How do use Having,Group by,Group function in SQL?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.