Loading

write a stored procedure for following eg::

ramesh

i have the backend table like

countryid countryname state

11india ap

12aus sydny

13pak

so when i give the countrynam 'pak' state column display null value but i want display some text msg instead of null pls write the program for that in stored procedure in plsql only

countryname: pak statename:

i want result like that countryname: pak statename:there is not states

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Srivastava14y ago
CREATE PROCEDURE [dbo].[usp_GetComplteteRecord]
@countryid varchar(50) -- CountryId as an input
AS
BEGIN
SELECT [countryid], [countryname] , ISNULL([state],'NOT AVAILABLE')
FROM [CountryRecordTable]
WHERE [countryid] = @countryid
END
Sukesh Marla14y ago
CREATE PROCEDURE SprGetCountriesWithStates

AS
BEGIN
Select countryid,countryname ,ISNULL(state,'there is not states') from TblCountry
END

Hope It Helped. Please Check This is Currect Answer.