SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 4832

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 7337

Which system tables contain information on privileges granted and privileges obtained

1 5199




Which system table contains information on constraints on all the tables created?

2 4949

what command is used to create a table by copying the structure of another table?

7 9388

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 7219

What is the use of CASCADE CONSTRAINTS?

3 7813

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 ...

Crown Solutions,

936




What are the type of Indexes? which one is best, why?

6 5428

How to work on DTS?what is the main requirement?

ivan, Getit,

1 3288

I have student marks in a student table. I need second highest mark .Then what will the query for this?

Temenos, Patni, Wipro, SAP Labs, NetCore,

34 36940

how to find nth highest salary

IBM, Oracle, Cognizant, NexGen,

103 124208

About types of indexes in SQL server ?

Cognizant,

2 5025

Difference between writing SQL query and stored procedure ?

TCS, Infosys, Cognizant, Veritas,

15 62264

About DTS usage ?

Wipro, Cognizant,

2 5158


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Working with TLogs

683


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

939


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1300


Which is the best place or learning center for MS SQL?????In Bangladesh?????

879


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1510






Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1263


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

611


New concepts of sql server 2005 use in your project.

1235


your distribution database is full what will u do

956


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

816


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

361


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1151


What is best institute to Learn DotNET And SQL in chennai?

969


You are doing log shipping due to some reasons it is failing. How you will proceed from there

818


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

676