ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
i want table name basis on column name.
 Question Submitted By :: Ravindra Nhavi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: i want table name basis on column name.
Answer
# 1
no,columnname and tablename not same to assign
 
Is This Answer Correct ?    0 Yes 3 No
Guruswamy
 
  Re: i want table name basis on column name.
Answer
# 2
yes . it's possible
create table emp10(emp10 varchar(20))
 
Is This Answer Correct ?    3 Yes 1 No
Debasis
 
 
 
  Re: i want table name basis on column name.
Answer
# 3
yes.we can have a column name in the table name.
create table order
(
order varchar(10),
number int
)
 
Is This Answer Correct ?    2 Yes 1 No
Gowthami Radhakrishnan
 
  Re: i want table name basis on column name.
Answer
# 4
select * from information_schema.columns where 
column_name='orderid' 

The above query is used to find all the tables and views in 
the Database  which contain ‘orderId’ as column name.

But to find only the tables in the Database which 
contain ‘orderId’ as column name, use the below query. 


select col.table_name from information_schema.columns Col 
join information_schema.tables Tab
on col.table_name=tab.table_name and
col.column_name='orderId'and tab.table_type='Base Table'
 
Is This Answer Correct ?    2 Yes 0 No
Bobby
 
  Re: i want table name basis on column name.
Answer
# 5
Please find the below query in which, the tables are 
selected depends the column name empNo. 

select table_name from information_schema.columns where 
column_name='empNo'
 
Is This Answer Correct ?    2 Yes 1 No
Saravanan P
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
when inserting to a table how many rows will be effected using triggers  1
What are mdf,ndf,ldf files and how to see the data in those files? Accenture5
When do you create cluster and noncluster index? Satyam4
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS5
What is BCP? When do we use it?  1
i need some interview questions on sql server developer plz any onee send some links.  1
Is it possible to delete duplicate rows in a table without using a temporary table ?  6
Difference between Triggers and Stored Procedure Protech9
Questions regarding Raiseerror?  1
What are the two virtual tables SQL Server maintains for triggers?  2
how to get the rowid/rownumbes of a table in sqlserver IBM5
Write a query to delete duplicate records in SQL SERVER Infosys19
WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT CTS10
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.  2
What is a Lock and let me know Different types of locks?  1
Which system tables contain information on privileges granted and privileges obtained  1
how to get the automatic backup of the database in the sql server  3
what is mean by crystal repoart? ahere we will mainly use that?  1
When you first load SQL SERVER you will startup with what all databases? CompuSol3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com