Post reply

hi...this is chandra

  • November 10, 2014 at 2:02 pm

    #291800

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "coustmer" either does not exist or you do not have permission to use it.

    i got this error ..any one could explain..?

    create table coustmer.reviews(

    reviewid int not null identity,

    reviewname NVARCHAR (15) not null,

    description nvarchar(200) not null ,

    constraint pk_reviews primary key(reviewid));

    some one said that to create schema coustmer;

    but i didn't get the answer.

  • November 10, 2014 at 2:10 pm

    #1757555

    chandrachamarthi8 (11/10/2014)

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "coustmer" either does not exist or you do not have permission to use it.

    i got this error ..any one could explain..?

    create table coustmer.reviews(

    reviewid int not null identity,

    reviewname NVARCHAR (15) not null,

    description nvarchar(200) not null ,

    constraint pk_reviews primary key(reviewid));

    some one said that to create schema coustmer;

    but i didn't get the answer.

    Quick question, what does this query return?

    😎

    SELECT * FROM sys.schemas

  • November 10, 2014 at 2:13 pm

    #1757556

    oh.. thanq.. i ill try this

  • November 10, 2014 at 2:16 pm

    #1757557

    it display the schema on the result

  • November 10, 2014 at 2:59 pm

    #1757567

    chandrachamarthi8 (11/10/2014)

    it display the schema on the result

    Look carefully. Are you sure that it shouldn't be spelled "customer" instead of "coustmer"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 11, 2014 at 2:40 am

    This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

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