Answer Posted / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

What are the underflow and overflow behaviors on float literals?

1059

---

What happens to a trigger with multiple affected rows?

865

---

Why do we need different type of parameter?

997

---

What is a select query statement in ms sql server?

1007

---

How to enable tcp/ip protocol on a sql server?

1091

---

What is factless fact table? : sql server analysis services, ssas

962

---

What purpose does the model database server?

1053

---

how can u get last observation in an unknown dataset ?

2387

---

What area unit the various kinds of info compression introduced in sql server 2008?

1034

---

What is reference section?

941

---

What are differences in between sql server 2012 and sql server 2016?

978

---

Explain index in sql server?

964

---

Where sql server usernames and passwords are stored in a sql server?

933

---

What does it mean to be in union?

870

---

Explain powershell included in sql server 2008?

998

---