InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:39:45 GMT20http://www.sqlservercentral.com/Forums/Topic1412116-392-1.aspxwell i have Installed Case Insensitive Instance on my machineThe paramter declareatiom is infulanced by the server collationCase Insensitive Server Collation :Declare @Col1 intSet @col1 =16 workson Case sensitive Server Collation (DataBase Case Insensitive)Declare @Col1 intSet @col1 =16 Does not work Conclusion Paramters are sensitive only to the server collationSun, 27 Jan 2013 08:04:10 GMTGil_Adihttp://www.sqlservercentral.com/Forums/Topic1412116-392-1.aspxMy server is case sensitive (CS)My DataBase is no (CI)The smss query editor works fine for this kind of query CREATE TABLE [dbo].[Table_Test]( [col1] [int] NULL, [Col2] [int] NULL) ON [PRIMARY]--- pay attention to columns names (col1,Col2)Declare @col1value int set @col1value = 15insert table_test (Col1,col2) values (@col1value ,10)-- This works although the table name and the columns name are in different case :-)-- But when I am changing the Declare to Declare @Col1value int it reports an error Does the collation for the t-sql parameters defined by the server collation ? or it is defined in the T-SQL lanquege core Sun, 27 Jan 2013 05:09:53 GMTGil_Adi