when we use function instead of procedure? plz tell me the
situation with ex?

Answer Posted / priya

can we use default value in unique key?

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute stored procedure in select statement sql server?

527


What is a natural primary key?

518


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1483


What is the default value of an integer data type in sql server 2005?

580


Why do we use functions?

504






What are sql azure firewall rules?

85


What are the different types of locks in the database?

484


How many clustered indexes there can be on table ?

592


How can we get count of the number of records in a table?

535


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

538


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1624


How to make a remote connection in a database?

527


Explain syntax for viewing trigger?

532


What is the difference between dataadapter and datareader?

535


What is sql injection and why is it a problem? : sql server security

561