| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| What are functions | | 3 |
| How can u convert the Date to String? | TCS | 4 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| what is curser. | | 8 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
