Answer / swapna

A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them

Answer / ram

We can set Getdate() function by default to time stamp columns

How many types of local tables are there in sql server?

0 Answers  

---

What is repeatable read?

0 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---