Code Snippet posted by:
Self-Innovator | Posted on: 10/31/2012 | Category:
SQL Server Codes | Views: 380 | Status:
[Member] |
Points: 40
|
Alert Moderator
CREATE proc [C244570_marriage].[sp_getpersonaldetails]
@custid nvarchar(max)=NULL,
@Gender nvarchar(max)=NULL
as
begin
if (@custid is not null)
begin
select * from personalinfo where CustomerId=@custid
end
else
if (@Gender is not null)
begin
select * from personalinfo where Gender=@Gender
end
end
Join Hands Change lives
Thanks & Regards
Straight Edge Society