Answer Posted / madhu prakash p

sp and trigger are both predefined set of sql statements

we can pass the arguments for sp but we cant pass the
arguments for triggers.

trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.

But in the stored procedures u must call explicitly.

What are ddl (data definition language) statements for tables in ms sql server?

1148

---

Explain a checkpoint?

1083

---

Explain indexing and what are the advantages of it?

1069

---

Explain some stored procedure creating best practices or guidelines?

1000

---

How to use column default values in insert statements in ms sql server?

1089

---

What are indexers?

1131

---

What is the report model project?

151

---

What are different types of collation sensitivity?

1023

---

Explain datetimeoffset data type in sal server 2008?

970

---

What is difference between line feed ( ) and carriage return ( )?

947

---

What is key attribute?

979

---

What is transact-sql language?

1133

---

When is the use of update_statistics command?

1055

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1011

---

Write an sql query to find first weekday of the month?

975

---