SQL Server Interview Questions
Questions Answers Views Company eMail

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


6 11486

explain different types of jions with examples briefly?


1 4295

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5506

explain different types of jions with examples briefly?


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


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


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.


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


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?


SQL Server Architecture ?


query processing


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


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


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


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


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?


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


How you trouble shoot when any job fails


How to trouble shoot if unable to connect SQL Server


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


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