Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Grouping

    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...

  • RE: TDE and Filestream

    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...

  • RE: Using INSERTED and DELETED Tables in a Trigger

    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...

  • RE: comparing the varchar data type value

    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...

  • RE: multi-table query: returning data when one table has nothing?

    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...

Viewing 5 posts - 1 through 5 (of 5 total)