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 12534

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

 2 6254

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 7422

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

 1 5361

What is the disadvantages of index?

 3 7319

how to do partition in sqlserver

 1957

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 6858

What is Primary key and foreign key? Give an example

 4 8336

what is the disadvantage of SQL Loder?

 1 6064

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 9849

Diffrences between sql server 2000 vs 2008

 1641

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

 1 5812

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

 1 8310

what is joins please explain breffly ??

 1 4109

What is the difference between Procedure and Function

 4 9998

Post New TCS SQL Server Interview Questions


TCS SQL Server Interview Questions


Un-Answered Questions

Where servomechanism is used?

625

Why do we use swift? Mention some advantages of swift?

485

What are the basic documents a person requires to open an account

621

Can xcopy move files?

480

Explain how to use sql queries in qtp ?

278




List out all the tables that are a part of cics ?

568

List out common artisan commands used in laravel.

370

What do mean by network ?

645

Why do we need hibernate in java?

140

Could you pls give me sites where i can test card? mail me to

2283

what are benefits of Quality Inspection?

3

What is the best data structure and algorithm to implement cache?

508

Your project depends on a key deliverable from a vendor you've used several times before with great success. You're counting on the delivery to arrive on June 1. This is an example of : A. Constraint B. Objective C. Assumption D. Goal

888

Explain the main features of couchdb?

1

What are integer variable, floating-point variable and character variable?

592