Can binary strings be converted into numeric or float data types?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

What is a transaction and why is it important?

0 Answers  

---

What is the difference between migration and upgradation in sql server?

0 Answers  

---

---

Define inner join in sql server joins?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

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

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

---