1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

Ness Technologies,

1 4993

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

3 3668

Comment,Datatypes are unlimited

IBM,

1620

what is mean by constraints in sql?

Granada, IBM,

5 6969

What is dataset and its uses

 2 3277

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 3991

How to change location of errorlog in SQL?

ABC, IBM,

2 4994

check, not null,unique

IBM,

2 4324

syntex of insert

 7 5601

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 2580

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 8313

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

 1 2574

How to truncate a table first before running a package?

 1 3120

what is joins please explain breffly ??

Adaequare, TCS,

1 4113

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 9998

Un-Answered Questions { SQL Server }

What is inline variable assignment?

583

What is multilevel indexing?

525

What are secondary xml indexes?

555

What is measure group, measure? : sql server analysis services, ssas

541

How do I view views in sql server?

507




Can a table have 2 primary keys?

502

Explain the working of sql privileges?

596

What extended events?

533

what are the new features in SSRS?

104

What is the difference between insensitive and scroll cursor?

570

Explain what are the events recorded in a transaction log?

544

What is difference between inner join and join?

532

What is table value parameters (tvp)?

527

What are the new scripting capabilities of ssms? : sql server management studio

537

How we can compare two database data?

511

For More Un-Answered { SQL Server } Questions Click Here