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 15403

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

2 7627

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 8771

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

1 6027

What is the disadvantages of index?

3 8524

how to do partition in sqlserver

2418

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 8822

What is Primary key and foreign key? Give an example

4 9579

what is the disadvantage of SQL Loder?

1 6846

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 11862

Diffrences between sql server 2000 vs 2008

1989

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

1 6617

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

1 9053

what is joins please explain breffly ??

1 4969

What is the difference between Procedure and Function

4 11321

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

What are the fields in a bdc_tab table? : abap bdc

1067

Differentiate pl/sql and sql?

1016

List all the dependency scope in maven.

215

Our company refundable ST amount but we dont want to refund amt but i want to adjust that refund amount anywhere

2191

Explain the difference between jakarta struts and apache struts?

904

What is the value of uninitialized variable in c?

982

How can you introduce new software qa processes to an existing organization?

940

how to determine Sq.mm size of finolex power cables.

1952

How can metals be removed from aqueous waste streams?

956

what is instanceof operator used in java?

978

how copper and aluminium wires or cables are choose for current rating? please provide copper and aluminium wire selection chart for different current rating ?

1974

Sir, I have applied for the of Jr.engineer(Electrical & Electronics) & ASST. LOCO PILOT at ALL RRB BOARDS. please send me all RRB Boards solved papers in the year of 2001 tO till date. i requested send me the papers to my id as soon as possible (jet_0991@yahoo.com). (This is very urgent) Thank You,

1790

How can I get around the synchronization issue such that deletes and renames from VS.NET do not get synchronize with VSS as described in Q305516?

1157

What is the default scope of bean in spring framework?

464

How can I create a report based on a query? : sql server management studio

978