SQL Server Interview Questions
Questions Answers Views Company eMail

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

369

what is checksum in sql server.........???

TCS,

411

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

327




how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

383

What is Lock table in SQL?

Wipro,

283

Can we call a function that has out parameter in select statement

Nagarro,

101

Call by value and call by reference in procedure and function, with NOCOPY.

Nagarro,

164

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

190




Delete duplicate rows without using rowid.

Nagarro,

208

how to find 6th highest salary

Chetak Logistics,

169


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

956


If the job running very slow what is the action you do

729


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

890


System variable and temporary variables

994


How you trouble shoot when any job fails

701






can any body tell me how to know the password of current user in sql server

932


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5084


on line cluster can we make if yes tell me the procedure

854


If we delete pack Spec what will be the status of pack Body ?

190


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

832


what is the sql equivaent of the dataset relation object ?

855


New concepts of sql server 2005 use in your project.

1246


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2720


how to take backup bcp out for a column in table in sql server?

865


SQL Server Architecture ?

1149