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

Answer Posted / surya

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is foreign key a primary key?

684


What extended events?

766


What are different types of join?

955


What do you mean by an execution plan? How would you view it?

693


What are the restrictions while creating batches in sql server?

761






How many instances per computer are there in sql server 2000?

766


Write down the syntax and an example for create, rename and delete index?

724


What are views used for?

780


How do I shrink an ldf file?

731


What's the information that can be stored inside a bit column?

709


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

739


What is the difference between ‘having’ clause and a ‘where’ clause?

769


Define inner join? Explain with an example?

702


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

801


What is a trace frag?

824