we can write store procedure without table also..but not triggres..

How will u test the stroded procedures and functions?
difference between SP and Triggers

Question Posted / surya

Answer Posted / surya

we can write store procedure without table also..but not
triggres..

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between cross join and full outer join?

924

How to end a stored procedure properly in ms sql server?

1017

Where is trigger in sql server?

990

What happens on checkpoint?

967

Which sql server table is used to hold the stored procedure script?

882

Explain in details security in SQL azure?

121

What is difference between join and natural join?

895

What is the difference between ddl,dml and dcl commands?

1057

What is a scheduled job or what is a scheduled task?

912

What is global temp table?

949

Can we use where and having clause together?

978

What is a trigger what are the advantages of trigger?

915

What is the current pricing model of SQL Azure?

104

What is partitioned view?

853

What are acid properties of transaction?

894