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 is not null constraint?

1128

what is spatial nonclustered index

992

Does partitioning help performance?

937

Can binary strings be used in arithmetical operations?

937

Can you explain what is indexed view? How to create it?

908

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

Why should we go for stored procedures? Why not direct queries?

1101

What is model database? : SQL Server Architecture

1133

Explain the steps needed to create a scheduled job?

935

How do I create a stored procedure in dbml?

1009

What is the syntax to execute the sys.dm_db_missing_index_details?

1029

What is microsoft sql server?

979

What is a filestream?

991

What method is used by the Command classes to execute SQL statements that return single values?

1071

what are different types of raid configurations? : Sql server database administration

1060