USE [Dynamic_Glossary]
GO

/****** Object:  StoredProcedure [dbo].[Output_Data]    Script Date: 05/22/2012 09:47:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

alter procedure [dbo].[Output_Data]
(
	@ColumnNumber  sysname,
	@language varchar (30)
	
	
)
AS
SET NOCOUNT ON;



BEGIN
TRY

EXEC ('SELECT English_Words,  Word_Def as Definition, '+@language+' as "Translation To" FROM [Languages] WHERE [' + @ColumnNumber + '] = 1')




END TRY

BEGIN CATCH
PRINT 'Your Language is not supoorted'
end catch

	
SELECT
      ERROR_NUMBER() AS ErrorNumber
      ,ERROR_SEVERITY() AS ErrorSeverity
      ,ERROR_STATE() AS ErrorState
      ,ERROR_PROCEDURE() AS ErrorProcedure
      ,ERROR_LINE() AS ErrorLine
      ,ERROR_MESSAGE() AS ErrorMessage;

ErrorMessage
Invalid column name 'sdf'.

select 'The current language is not supported'

quote:

---

Originally posted by burzum

I might explaining this wrong. Let me try this once more.

So when I execute the above procedure it runs perfectly. And I do get the message saying "Your Language is not supported". But that's in the Message tab. In the result tab, I get Return Value 0. What I want is so somehow that message showed in the result tab, because later I'm using this procedure in C#. And when I run my C# code and if the columnName doesn't match it shows a blank page. And instead of that I want to print "Language is not supported".

---