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 8257If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
3 5133Insert 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?)
1941after 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?
2138IF 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
1871
What is the sql case statement used for? Explain with an example?
Explain transaction isolation levels in sql server?
How the authentication mode can be changed?
Can you name a few encryption mechanisms in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Give an example of SQL injection attack ?
What are the different types of replication are there in sql server 2000?
Why are sql functions used?
Explain what are the database objects? : SQL Server Architecture
How to get all stored procedures in sql server?
What is a domain constraint give an example?
What are the different types of data sources in ssrs?
What are filegroups in sql server?
What are the different types of backups that exist?
What is database replication?