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.