Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #2162

Re: Creating a table in spite of browse mode

Show all headers | View raw

Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> The application I am working with quietly imposes some
> limitation on its connection to MSSQL that will not let me
> create a temporary table. Below are some of my attempts with
> the corresponding results:
> 
>   SQL: CREATE TABLE #TEST(a INT)
>   ERR: CREATE TABLE is unsupported

Is that the exact error message?
 
>   SQL: BEGIN CREATE TABLE #TEST(a INT) END
>   RES: No error, but no table is created.
> 
>   SQL: SELECT 1 a INTO #TEST
>   ERR: Browse mode cannot be used with INSERT,
>        SELECT INTO, or UPDATE statements.
> 

So what old and ugly client API is this?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Creating a table in spite of browse mode Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-10-18 15:09 +0300
  Re: Creating a table in spite of browse mode Erland Sommarskog <esquel@sommarskog.se> - 2022-10-18 20:59 +0200
    Re: Creating a table in spite of browse mode Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-10-19 17:52 +0300
      Re: Creating a table in spite of browse mode Erland Sommarskog <esquel@sommarskog.se> - 2022-10-19 22:43 +0200
        Re: Creating a table in spite of browse mode Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-10-20 12:05 +0300

csiph-web