SQL Server Interview Questions
Questions Answers Views Company eMail

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 11486

explain different types of jions with examples briefly?

Zensar,

1 4295

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5506




explain different types of jions with examples briefly?

Zensar,

3 7275

can we call functions from stored procedure in SQL Server 2005 ? How?

3 9188

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 32135

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 3019

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 3745




Difference between Triggers and Stored Procedure

Protech, HCL, Claimat, Silgate,

23 56330

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 3178

How to list all tables having unique constraints in any of the columns in a database.

1 2878

Advantages and Disadvantages of Cursor?

TCS, Zenith, Polytechnic,

15 80707

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 54902

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 5656

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 3822


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1543


If we delete pack Spec what will be the status of pack Body ?

147


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?

1018


SQL Server Architecture ?

1101


query processing

975






In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

782


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

1226


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

4587


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

1123


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?

1213


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

854


How you trouble shoot when any job fails

650


How to trouble shoot if unable to connect SQL Server

743


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

4627


can any body tell me how to know the password of current user in sql server

894