Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

IN Vs OR operator which is best to use sql server.

4 9660

Can anybody explain me cold backup and hot backup?

TCS,

3 14343

whate is advantages of sql server 2000

1502

what is the purpose of creating view is sql server 2000

Wipro,

13 17030

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 3954

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 4945

how to connect sybase to sql server 2005?.

ABC,

1 3969

how to select a field with firstletter as capital and remaining are small letters

11 14883

How to write stored procedure to update the data in 10 tables

4 12152

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 30311

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 5498

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 6765

what is difference between view and Dip.

IBM, L&T,

1771

what is curser.

9 9492

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 11995


Un-Answered Questions { SQL Server }

What is dynamic cursor in SQL SERVER?

410


You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

434


How to drop an existing table with "drop table" statements in ms sql server?

403


Explain error and transaction handling in sql server?

352


Data table as parameter in sql server?

420






What are the different authentication modes in sql server?

410


Does index speed up select statements?

412


What is the usage of the sign function?

381


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

392


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

447


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

395


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

486


How to use subqueries with the in operators in ms sql server?

408


Which command is used for user defined error messages?

417


Can you please explain the difference between function and stored procedure?

385