SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 8429

Can anybody explain me cold backup and hot backup?

TCS,

3 13108

whate is advantages of sql server 2000

1031




what is the purpose of creating view is sql server 2000

Wipro,

13 12943

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

1 3321

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 3997

how to connect sybase to sql server 2005?.

ABC,

1 3087

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

11 12036




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

4 10880

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

Semantic Space,

11 27168

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 4411

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 5402

what is difference between view and Dip.

L&T, IBM,

1273

what is curser.

9 6858

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

TCS,

5 10070


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1116


how many no of arguments can be passed in procedures and functions

3633


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1352


What is data modeling and Reterminal integrity?

739


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?)

781






hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

853


what is package and it uses and how can u call a package

961


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


Comment,Datatypes are unlimited

989


how to do partition in sqlserver

1372


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

1380


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

947


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1182


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

452


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1119