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

What are the different normalization forms?

1157

What are the purposes and advantages stored procedure?

1009

What is an index in sql?

1063

How to get a list all databases on the sql server?

1152

What is sql profiler. What are the default templates with it? : sql server database administration

1100

What is the current limitation of the size of SQL Azure DB?

129

How do you know if sql server is running on your local system?

1090

What is a raid and what are different types of raid configurations?

1318

What is the difference between ddl and dml?

1094

What do you mean by subquery?

1140

Explain few examples of stored procedure over triggers?

1109

What is encryption key?

137

What is difference between global temporary tables and local temporary tables?

1274

How do you set a trace flag in sql server?

1084

Is the order of columns in the set clause important in ms sql server?

1011