SQL Server Interview Questions
Questions Answers Views Company eMail

What is the default isolation level of the sql server database?

Ness Technologies,

1 3828

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

2 2194

Comment,Datatypes are unlimited

IBM,

936




what is mean by constraints in sql?

IBM, Granada,

5 4504

What is dataset and its uses

2 2035

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 2421

How to change location of errorlog in SQL?

ABC, IBM,

2 3340

check, not null,unique

IBM,

2 2902




syntex of insert

7 2835

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 1508

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

Cap Gemini, TCS,

1 6922

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 1453

How to truncate a table first before running a package?

1 1970

what is joins please explain breffly ??

TCS, Adaequare,

1 2848

What is the difference between Procedure and Function

TCS, Accenture, Nagarro,

4 7611


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How you trouble shoot when any job fails

700


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

832


System variable and temporary variables

993


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1364


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

1166






Scalability, Availability, Integration with internet, etc.)?

1660


application server is slow what may be the problem

1095


which backup strategy you are following at ur company

1008


What is data modeling and Reterminal integrity?

682


What is RMS migrations?

970


how can you attach more than 20 ldf files in sql server

846


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

1312


tell me the disaster recovery plan

1299


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

4710


You are doing log shipping due to some reasons it is failing. How you will proceed from there

833