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 4512
What is the maximun sixes of .mdf in sql server 20051 2377
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?3 2874
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?)1014
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?1233
what is isolation level at dead lock?1310
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 do916
How to enter unicode character string literals in ms sql server?
What are different types of roles provided by ssrs?
What do you understand by a view? What does the with check option clause for a view do?
Explain user defined functions?
What are acid properties of transaction?
Can a table have 2 primary keys?
What are “lost updates”?
What is trigger explain with program?
what is hash nonclustered index
What is sqlservr.exe - process - sql server (sqlex?press)?
Is it possible to have clustered index on separate drive from original table location?
What is difference between unique and primary key?
What is the report model project?
What are dml (data manipulation language) statements in ms sql server?
What is t-sql script to take database offline – take database online.