TCS SQL Server Interview Questions Answers, TCS Placement Papers, TCS Technical, HR Interview Questions, TCS Aptitude Test Questions, TCS Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

TCS SQL Server Interview Questions

Questions Answers Views Company eMail

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 15756

How will u test the stroded procedures and functions? difference between SP and Triggers

2 7758

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 8955

how to improve the speed of SQL database server and how to avoid dead lock?

1 6125

What is the disadvantages of index?

3 8668

how to do partition in sqlserver

2474

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 9064

What is Primary key and foreign key? Give an example

4 9755

what is the disadvantage of SQL Loder?

1 6937

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 12120

Diffrences between sql server 2000 vs 2008

2038

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 6700

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

1 9141

what is joins please explain breffly ??

1 5077

What is the difference between Procedure and Function

4 11527

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

What is the meaning of abap/4 editor integrated with abap/4 data dictionary?

1099

Does ctr help in improving quality score?

226

What is a ejb container?

969

Name the distributed systems available apart from .net remoting?

953

What are the Achievements in previous company...as a software Test engnineer...Anybody can give me answer..Thanks in advance..

2219

what is the scenario of multi-org setup?

2374

How can you use “$rootscope” in angularjs?

857

When configuring sqlnet on the client what files need to be set up?

645

What are the features of UML?

910

Explain the index of refraction of air?

984

If a method is declared as protected, where may the method be accessed?

1016

What is internet of everything?

Can my application have multiple models?

816

what is the present model of group1 and group 2 syllabus plz send the link ?

1749

What do the f8 and shift f8 key commands do in excel?

670