Viewing 5 posts - 1 through 5 (of 5 total)
I think paul last Query and my Query both are same.
Select U.* from dbo.Users U with (Nolock)
Join (Select username, MAX(GWP) MGWP from dbo.Users with (Nolock)
Group by username) as A
on...
January 12, 2012 at 5:38 am
what is this? they are askiing Q like Is Filestream Encrypted?
I said No.
They are saying Correct answer is Yes.
and explaination is saying that Filestream Data are not enctrypted.
That is...
June 29, 2011 at 2:42 am
you can create trigger like this for your purpose
create trigger TR_MyTable_I_U
on dbo.MyTable
for INSERT, UPDATE
as
begin
set nocount on;
update dbo.MyTable
set Col3 = M.Col4
FROM dbo.MyTable M
join inserted I on I.col1= M.Col1 and I.Col2= M.Col2...
June 14, 2011 at 3:56 am
I am not sure but it is comparing single character's ascii value from each variable one by one from lefttoright and when ever it will get greater result it will...
June 14, 2011 at 3:39 am
from your Table Name I think that your Name table is master table and rest of the others are depandant on them. is it the case than
you can write like...
June 14, 2011 at 1:48 am
Viewing 5 posts - 1 through 5 (of 5 total)