Answer / guest

use the CONVERT Function.

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

Answer / rajeevrohilla

You Can USe Either Convert or Cast Function for this

What are the hotfixes and patches in sql server?

0 Answers  

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

How to insert stored procedure result into temporary table?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---