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

what is Full Text Search ?

1 5170

New concepts of sql server 2005 use in your project.

2307

default databases available in sql server and there uses ?

4 6952

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2434

wat is tuff file in log shipping, wt is d use of tht file?

1 6341

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 4627

Delete duplicate records from the table?(Table must have unique id)

7 12130

In the primary key have a multiple field or not?

8 8960

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 9581

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 13993

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 8246

difference between function and procedure

3 5237

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 4833

How to read 2nd highest sal from EMP table?

5 5964

what is checksum in sql server.........???

1631

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

Is apache still used?

891

What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary

926

Write a function which accepts a sentence as input parameter.Each word in that sentence is to be reversed. Space should be there between each words.Return the sentence with reversed words to main function and produce the required output. for eg:- i/p: jack jill jung kill o/p: kcaj llij gnuj llik

2297

Hi any one can help in preparing for BHEL ET exam in mechanical stream? I like to know the the question paper pattern fro the same. regards, Jose 9841327666 josevinoth@yahoo.com

2328

How do I run exe files on windows 7?

859

If we are not returning any records from the database, which method is to be used?

1279

Can we execute a Talend Job remotely?

What is private class in c#?

877

What is the importance of table t000?

1063

In sap what is the use of fsv ( financial statement version) ?

1064

Can you use excel as a database?

597

How to execute a stored procedure with TIBSQL?

1820

Tell us about your usual day.

1150

Explain the different types of mysql joins.

858

How do I uninstall visual c++?

945