Hello 1 and all
I have created a stored procedure for table X. X contains the fields B,C,D,E,F,G. B is a primary key with data type int. I am giving the stored procedure as follows:
Create Proc [dbo].[spXSelect]
@B int=null
as
Begin
If @B is Null
Begin
Select Ident_Current('X') as 'Identity'
Select *From X
End
If @B is Not Null
Begin
Select *From X where B=@B
End
End
In want to retrieve only the columns D and E in .net programming. Is it possible. Please help me thanx in advance.