When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

Can function return multiple values in sql?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

What port does sql server use?

0 Answers  

---

Is left join and outer join same?

0 Answers  

---

What are the types of index in sql?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

What is difference between nchar and nvarchar?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

What is the maximum database size for sql express?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---