SELECT * FROM TblAppUser WHERE UserId = @UserID
CREATE PROC uspGetUserProfile @UserID int,@UserName VARCHAR(20) OUT,@Email VARCHAR(50) OUT,@NIC bigint OUT,@CreatedDate datetime OUT, @FirstName Varchar(20) OUT,@LastName Varchar(20) OUT,@FatherName Varchar(30) OUT,@DateofBirth date OUT, @OfficeAddress Varchar(max) OUT,@City Varchar(15) OUT,@Proivnce Varchar(15) OUT,@WorkPhone Varchar(25) OUT, @Avatar image OUT AS BEGIN SELECT * FROM TblAppUser WHERE UserId = @UserID END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)