locked
Problem with a column named "List" RRS feed

  • Question

  • This is very similar to the 2007 comment at http://social.msdn.microsoft.com/forums/en-us/sqltools/thread/7901E54A-24DD-4F08-9733-3260B6398F80

    I am experiencing a similar issue using "list" as a column name. I boiled the issue down to the folowing sample code:

    CREATE TABLE dbo.Table1
    (
    	Name varchar(10)
    	, [List] INT
    	, timestamp
    )
    INSERT INTO dbo.Table1
    Values( NULL, NULL, DEFAULT )
    CREATE TABLE dbo.Table2
    (
    	Name varchar(10)
    	, [Listt] INT
    	, timestamp
    )
    INSERT INTO dbo.Table2
    Values( NULL, NULL, DEFAULT )

    This creates two tables Table1 and Table2. They are identical in form and data except that the second column is "list" in one and "listt" in the other.

    Open each in SSMS using "Edit Top # Rows" option. Attempt to edit either column and you will discover that it works in Table2 but not in Table1.

    The error I am getting is an optomistic concurrency violation. Also, removing the timestamp column does not solve the problem.

    SSMS version 10.50.2500.0

    server version: 10.50.1600.1 (X64)

    Jacob

    Friday, November 9, 2012 6:38 PM

Answers

All replies