Answer / Vijay Verma

"No, binary strings cannot be directly converted into numeric or float data types in MS SQL Server. However, you can convert a hexadecimal representation of a number to a binary string and then convert it back to a number."

What is a data collection table?

1 Answers  

---

In what sequence sql statement is processed?

1 Answers  

---

What are different types of data sources?

1 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

What is the dbcc command and why is it used?

1 Answers  

---

What is the downside of using udf?

1 Answers  

---

What is a constant or literal in ms sql server?

1 Answers  

---

What are the different types of queries?

1 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

what is index seek and index scan?

2 Answers  

---

How to find which stored procedure is currently running in sql server?

1 Answers  

---

What is the difference between row_number and dense_rank?

1 Answers  

---