My 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 = 15
insert 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