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 to count duplicated values in a column in ms sql server?

0 Answers  

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

Explain about system stored procedure?

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

What are the different editions available in sql server 2000?

0 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

What are the main control-of-flow T-SQL constructs?

1 Answers  

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---