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?


3 13108

whate is advantages of sql server 2000


what is the purpose of creating view is sql server 2000


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


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.



what is curser.

9 6858

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


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?


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


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


What is data modeling and Reterminal integrity?


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


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.


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


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


Comment,Datatypes are unlimited


how to do partition in sqlserver


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


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


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


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


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