Professional Web Applications Themes

N macro - Microsoft SQL / MS SQL Server

What does the N macro do?: SELECT device_directory = SUBSTRING(phyname, 1, CHARINDEX (N'master.mdf', LOWER(phyname)) - 1) FROM master.dbo.sysdevices WHERE (name = N'master')...

  1. #1

    Default N macro

    What does the N macro do?:

    SELECT device_directory = SUBSTRING(phyname, 1, CHARINDEX
    (N'master.mdf', LOWER(phyname)) - 1)
    FROM master.dbo.sysdevices
    WHERE (name = N'master')
    Arne Guest

  2. #2

    Default Re: N macro

    a normal string 'abc' takes 1 byte per characater and this string is 3
    bytes long..

    THis string N'abc' is unicode and uses 2 bytes per character and is stored
    in ntext, nchar, and nvarchar data types.
    "Arne" <com> wrote in message
    news:0dd901c35ce8$b94af010$gbl... 


    Wayne Guest

  3. #3

    Default Re: N macro

    Arne,

    Its not a macro.The prefix indicates a unicode string.More details here:

    INF: Unicode String Constants in SQL Server Require N Prefix
    http://www.support.microsoft.com/?id=239530


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Arne" <com> wrote in message
    news:0dd901c35ce8$b94af010$gbl... 


    Dinesh.T.K Guest

Similar Threads

  1. Macro compromise for D70
    By paul in forum Photography
    Replies: 31
    Last Post: January 5th, 04:41 AM
  2. Macro close ups
    By Tony in forum Photography
    Replies: 3
    Last Post: July 18th, 10:27 PM
  3. WAY OT: Excel and Using a Macro
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 15th, 03:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139