How to provide default values to stored procedure parameters?


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

Post New Answer

More SQL Server Interview Questions

explain query execution plan

1 Answers  


Does a full backup include transaction log?

0 Answers  


What is change data capture (cdc) feature?

0 Answers  


How does a profiler work?

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,






Can we use where and having clause together?

0 Answers  


What is auditing in sql server?

0 Answers  


What is the default schema of your login session in ms sql server?

0 Answers  


what are the problems in logshipping?

3 Answers  


What command must you use to include the not null constraint after a table has already been created?

0 Answers  


how can you attach more than 20 ldf files in sql server

0 Answers   IBM,


What is normalization of database? What are its benefits?

0 Answers  


Categories