SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


3 6622

What are functions

3 5303

how to get the automatic backup of the database in the sql server

4 30892

What command do we use to rename a db?

5 7608

What are the four main query statements?


7 13322

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 11542

What is the STUFF function and how does it differ from the REPLACE function?

2 16036

What is SQL server agent?

HCL, SAP Labs,

2 5286

What is the purpose of UPDATE STATISTICS?

2 8983

What is de-normalization and when do you do it?

3 4874

Difference between Function and Stored Procedure?

C1 India,

9 13724

What is data integrity? Explain constraints?


1 20642

Explain some DBCC commands?

6 12902

What are tasks?


3 7360

What is the purpose of using COLLATE in a query?

1 15416

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is data modeling and Reterminal integrity?


This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?


optimization techinques


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?


what is the sql equivaent of the dataset relation object ?


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


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


What is the difference between NOROW and LOCKROW?


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


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


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


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


What is the query optimization statistics?


If a stored procedure is taking a table data type, how it looks?


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