Professional Web Applications Themes

Reading From File - Microsoft SQL / MS SQL Server

Hello All, Can we read the contents of a text file and store it in a variable? Something like this. DECLARE contents VARCHAR(4000) SET contents = <<contents of a file>> Thanks in advance Anand...

  1. #1

    Default Reading From File

    Hello All,
    Can we read the contents of a text file and store it
    in a variable?

    Something like this.

    DECLARE contents VARCHAR(4000)
    SET contents = <<contents of a file>>


    Thanks in advance

    Anand

    Anand Guest

  2. #2

    Default Re: Reading From File

    I don't know about directly into a variable but you might be able to use
    Bulk Insert (depending on the file) into a table then select from the table
    to a variable.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Anand" <org> wrote in message
    news:01d901c35600$26fd7780$gbl... 


    Andrew Guest

  3. #3

    Default Re: Reading From File

    you could create a linked server to the filesystem and the text file like a
    table. see steve's article for more info on how to setup one.

    http://www.users.drew.edu/skass/sql/TextDriver.htm

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Anand" <org> wrote in message
    news:01d901c35600$26fd7780$gbl... 


    oj Guest

Similar Threads

  1. Replies: 2
    Last Post: May 15th, 09:36 AM
  2. Reading CSv File
    By Tom CF in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 9th, 09:58 AM
  3. Replies: 0
    Last Post: July 25th, 01:55 AM
  4. Reading a .dbm file
    By Mame in forum PERL Beginners
    Replies: 2
    Last Post: May 11th, 12:18 PM
  5. Not reading the php.ini file
    By Ian Pawson in forum PHP Development
    Replies: 2
    Last Post: September 20th, 08:46 AM

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