InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 09:45:10 GMT20http://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxThe xml is fixed definition.I think that is a solution but is dirty code.The only way then is to obtain a column with other name like "A0" instead "a", ugly but is the only way i thinkMon, 07 Jan 2013 07:33:59 GMTmatiaskenighttp://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxThat makes sense, and I can see why you're having problems. Is it possible to get the Columns renamed in the XML source or is this a fixed definition?One thing you could do is create a staging database with Case sensitivity enabled, preload the XML there then sit a view over the top with Proper column names.Mon, 07 Jan 2013 07:30:16 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxIs a lot to explan but i have build a funcion to convert XML to TABLE, and represent by column names the alias names of the XML format, and in xml have columns with same name (but case sensitive), then i need to represent exactly in the columnexample<cols> <i name="A"/> <i name="a"/></cols><rows> <i a="John" A="Male" /></rows>Mon, 07 Jan 2013 07:14:14 GMTmatiaskenighttp://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxWhy cant you just name the columns differently? Especially if its a temporary thing like a table variable.Mon, 07 Jan 2013 07:08:02 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxI have entire database in other collation mode,only need to use this TABLE VARIABLE with column names case sensitive, only for this table, is a way to do this? ThanksMon, 07 Jan 2013 07:02:30 GMTmatiaskenighttp://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxThe object gets its collation from the database, so the database where you are declaring the table variable must be in a case sensitive collation.Mon, 07 Jan 2013 01:23:21 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxOh, entire database :(i only need this for a single table variable, is there a way to do?Sun, 06 Jan 2013 16:23:21 GMTmatiaskenighttp://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxYes, but database must have Case Sensitive collation.Sun, 06 Jan 2013 14:36:27 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1403350-391-1.aspxHi, im Matias from Argentina,i need to know if exist a way to change the collation of the TABLE column nameEXAMPLE: Table "table1" contains two columns: "column1" and "COLUMN1" and both need to be different.Please help.Sun, 06 Jan 2013 13:49:19 GMTmatiaskenig