Post reply

Servername in middle of unc path

  • November 5, 2019 at 7:03 am

    #3694575

    How can I generate sqlservername in the middle of an UNC path?

    select N'\\ABCD\EFGH\IJKL\MNSP\("select @@servername")\AL.txt'

    If servername is MYSERVER then UNC path should be..

    Result should be \\ABCD\EFGH\IJKL\MNSP\MYSERVER\AL.txt

    Thanks

  • November 5, 2019 at 9:11 am

    #3694625

    select N'\\ABCD\EFGH\IJKL\MNSP\'+ @@servername+'\AL.txt'

    MVDBA

  • November 6, 2019 at 1:37 am

    #3695339

    I tried that . it’s not working

  • November 6, 2019 at 8:16 am

    #3695361

    What didn't work?  How are we supposed to help you debug when you don't give us anything to work with?

    Perhaps you are looking for the machine name, and not the @@servername

    SELECT N'\\ABCD\EFGH\IJKL\MNSP\'
         + CONVERT( nvarchar(128), SERVERPROPERTY( 'MachineName' ))
         + N'\AL.txt';

    How to post data/code on a forum to get the best help.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply