Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 9908

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

2 5339

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 6272

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

1 4781

What is the disadvantages of index?

3 6185





how to do partition in sqlserver

1661

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 5493

What is Primary key and foreign key? Give an example

4 7305

what is the disadvantage of SQL Loder?

1 5351

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 7738

Diffrences between sql server 2000 vs 2008

1260

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

1 4894

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

1 7640

what is joins please explain breffly ??

1 3441

What is the difference between Procedure and Function

4 8731

Post New TCS SQL Server Interview Questions




TCS SQL Server Interview Questions


Un-Answered Questions

Write the simplified mathematical Maclaurin's expansion for f(x,y).

237


what is message subfile?

455


How a new regional manager will manage and develop his new assigned territory?

947


What are the execution control statements?

255


Can you hide a primary page in a component? Reason?

223






how does an centrifugal and screw type chiller will work. which chiller efficiency is high and why.

1489


Explain superblock in unix.

213


Which uplink/downlink spectrum is allocated to DCS-1800?

1479


What is the disadvantage of context filters?

395


What is accounting transaction?

276


How to know the following data of synchronous generator 1. D-Axis Unsaturated Reactance 2. D-Axis Unsaturated Transient Reactance 3. D-Axis Unsaturated Sub - Transient Reactance

1087


Am pass the 10000 records to target in target I will take commit interval 15000 when I was stop the work flow what will happened

628


Explain what are the steps to be taken to schedule the report?

288


Define piezo-electric effect?

265


What is stable sort example?

210