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 are the three command line utilities and what are their primary functions?

144


How to update multiple rows with one update statement in ms sql server?

1204


Differentiate between delete and truncate.

1062


How do you trace the traffic hitting a sql server?

1141


What are the different types of sub-queries?

1043


What is index fragmentation in ms sql server?

1083


Is it possible for a stored procedure to call itself or recursive stored procedure?

952


What is single-user mode?

940


What is amo? : sql server analysis services, ssas

1089


Can sql servers linked to other servers like oracle?

953


How sql server executes a statement with nested subqueries?

1028


How can I check that whether automatic statistic update is enabled or not?

1042


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

1076


What are the new features are introduced in sql server 2012 reporting services?

149


How to turn on the mssql api module in php?

1078