Viewing 5 posts - 16 through 20 (of 20 total)
create procedure spgetuserdetails
(
@userid nvarchar(255),
@Password nvarchar(255)
)
as
begin
declare @count int
select @count = count(*) from UsersTable where UserId = @userid and [Password] = @Password
...
December 5, 2016 at 12:16 pm
Even this works.
DECLARE @d SMALLDATETIME= '2016-10-04';
SELECT c.ISO,
e.rate
FROM exchangerates AS e
INNER JOIN currencies AS c ON e.currency = c.id
...
October 15, 2016 at 11:02 am
Yes I have seen the difference. The way I put the code have some spaces in between the FirstName and the LastName. The way you put doenot contain any extra...
October 14, 2016 at 2:19 pm
Thank you all.
I tried this It also works.
select Id, ltrim((isnull(Firstname,'') + ' ' + isnull(Middlename,'') + ' ' + isnull(Lastname,''))) as FullName from EmployeeName
October 14, 2016 at 1:55 pm
Thank You so much. It's working. Can you please explain the code how it works.
June 28, 2016 at 3:26 pm
Viewing 5 posts - 16 through 20 (of 20 total)