Answer / rajamani narni

unique,not null,primary key,foreign,check

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

Where is localdb stored?

0 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

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 create a scrollable cursor with the scroll option?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---