Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition

Answer Posted / amey

sql will throw error for not getting value to parameter.
reference object is null.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is server-level principal?

120


How to transfer a table from one schema to another?

938


What are the purposes and advantages stored procedure?

886


How to drop an existing user defined function in ms sql server?

979


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

987


what method you can use to reduce the overhead of Reporting Services data sources?

233


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

996


Explain concepts of analysis services?

890


What is the cartesian product of the table?

902


how many bits ip address consist of? : Sql server database administration

846


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1154


Do you know what is openxml in sql server?

1015


Can we use where and having clause together?

977


What is explicit mode in sql server?

1015


what is a check constraint?

1037