Professional Web Applications Themes

verifing whether a table with same name exist or not before creating new table - Microsoft SQL / MS SQL Server

hi verifing whether a table with same name exist or not before creating new table using asp i hope to get asw soon akash...

  1. #1

    Default verifing whether a table with same name exist or not before creating new table

    hi

    verifing whether a table with same name exist or not
    before creating new table using asp

    i hope to get asw soon

    akash
    akash Guest

  2. #2

    Default Re: verifing whether a table with same name exist or not before creating new table

    if (select count(*) from sysobjects where name = tablename ) <= 0
    BEGIN
    CREATE TABLE .......
    END

    "akash sinha" <com> wrote in message
    news:03ce01c34bce$a0664930$gbl... 


    Ashish Guest

  3. #3

    Default Re: verifing whether a table with same name exist or not before creating new table


    hi

    i wonder whether it will work in asp pages. it may work in sql. please
    let me know how it work in asp pages

    thanks

    akash

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    akash Guest

  4. #4

    Default Re: verifing whether a table with same name exist or not before creating new table

    hi

    i wonder whether it will work in asp pages. it may work in sql. please
    let me know how it work in asp pages

    thanks

    akash

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    akash Guest

  5. #5

    Default Re: verifing whether a table with same name exist or not before creating new table

    It will work as an ADO command from ASP in exactly the same way as TSQL.

    But - it is a VERY strange thing to be creating tables from within ASP, normally the app would be working with a pre-defined set of tables. I accept there are cases when the app allows user-defined structtures but the tends to be the exception.

    Mike John

    "akash sinha" <com> wrote in message news:#phx.gbl... 

    Mike Guest

  6. #6

    Default Re: verifing whether a table with same name exist or not before creating new table


    hi

    thanks all for valuable reply.

    regards

    akash


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    akash Guest

Similar Threads

  1. [mysql] Table Doesn't Exist
    By khamstra in forum Coldfusion Database Access
    Replies: 7
    Last Post: July 21st, 08:10 PM
  2. insert values only if they do not already exist in table
    By kabbi~thkek in forum Coldfusion Database Access
    Replies: 6
    Last Post: February 8th, 07:14 AM
  3. Replies: 2
    Last Post: August 12th, 07:55 AM
  4. table does not exist error in AD query?
    By Aaron_TekRecycle.com in forum ASP
    Replies: 0
    Last Post: July 25th, 08:07 AM
  5. TEMP table comes into exist very slow
    By Thomas in forum Informix
    Replies: 2
    Last Post: July 16th, 02:47 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