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 16193

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

2 7908

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 9140

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

1 6200

What is the disadvantages of index?

3 8791

how to do partition in sqlserver

2547

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 9318

What is Primary key and foreign key? Give an example

4 9935

what is the disadvantage of SQL Loder?

1 7020

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 12337

Diffrences between sql server 2000 vs 2008

2095

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

1 6783

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

1 9210

what is joins please explain breffly ??

1 5195

What is the difference between Procedure and Function

4 11676

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

How do I remove background in powerpoint 2013?

351

What is sub collaboration?

2922

How to check a trigger is fired or not, while doing database testing?

646

What are react component lifecycle methods?

504

types of piles detail,

2360

What is React State?

516

What is eval linux?

1024

PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..

2215

What is a type in swift?

889

It is the openspan rpa tool

How many plan versions can be integrated with other sap modules?

1035

What is a relative xpath?

1199

What is context param in spring?

507

Is there a windows 13 operating system?

926

What is php in full?

996