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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 
How do I compare two values when one value(data type) is 
char and the other is an integer?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do I compare two values when one value(data type) is char and the other is an integer?
Answer
# 1		 
use the CONVERT Function.
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: How do I compare two values when one value(data type) is char and the other is an integer?
Answer
# 2		 
You Can USe Either Convert or Cast Function for this
 
Is This Answer Correct ?    0 Yes 0 No
Rajeevrohilla
[Vibhava Technologies]
 
 
 
  Re: How do I compare two values when one value(data type) is char and the other is an integer?
Answer
# 3		 
I will convert column with integer datatype to char because 
i can not convert char to integer if column contains any 
alphabet and then i will compair two values
 
Is This Answer Correct ?    0 Yes 0 No
Sagun Sawant
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How reterive duplicate value in SQL?  5
What is the use of CASCADE CONSTRAINTS?  2
how many type of subquery?  2
what is web server? Satyam3
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?  3
what is IDE,DMV in sql server? Value-Labs1
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
explain different types of jions with examples briefly? Zensar1
how to generate XML out of QUERY? McAfee1
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1
What is the difference between having and where clause?  4
What is an Index? Yardi-Software3
what is the difference between group and having give an example with query and sample output  2
What is a Linked Server?  1
what is meant by deafult in sql server?  2
What is the difference between HAVING clause and the WHERE clause?  4
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
What is a table called, if it does not have neither Cluster nor Non-cluster Index?  1
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me. 247Customer1
What is the default value of CHAR type? Bosch8
 
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