Call by value and call by reference in procedure and function, with NOCOPY.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Do you know what is fill factor and pad index?

0 Answers  


what is a live lock? : Sql server database administration

0 Answers  


What is importing utility?

0 Answers  


What is difference between oltp and olap?

0 Answers  


How do clustered indexes store data?

0 Answers  






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

0 Answers  


Do you know what is a trace frag? Where do we use it?

0 Answers  


How many types of system privileges are there, Can we add or delete privileges?

2 Answers  


What is a ddl statement?

0 Answers  


I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,


Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  


Categories