How do I compare two values when one value(data type) is
char and the other is an integer?
- 3 Answers
- 7572 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sagun sawant
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 ? | 4 Yes | 1 No |
Answer / rajeevrohilla
You Can USe Either Convert or Cast Function for this
| Is This Answer Correct ? | 2 Yes | 0 No |
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Do you know what is similarity and difference between truncate and delete in sql?
What is the difference between a local and a global variable?
How many cores do I need for sql server 2016?
What is for xml in sql server?
What are the different types of stored procedures?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is user defined stored procedures?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain about SQLOS?
Can we update data in a view?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
