Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....

Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....

Hi Leszek Gniadkowski , Thank you very much for your valuable information....

thanks both of you.. for ur present......

Hi Leszek Gniadkowski , I didnt get your answer, Let me explain my question clearly. When i use data type NVARCHAR and select max(id) , am getting output as '-1' and when i use VARCHAR datatype and select max(id) am getting output as '1'. Why...

Hi Madhivanan, We are using below version. Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)...

How the max value differ based on Datatype. in the below example if the data type is NVARCHAR , max(id) = -1 if the data type is VARCHAR then max(id) = 1 Can any one tell me how we are getting different results? CREATE TABLE #TBL(ID NVARCHAR(10)) GO...

Generally we write "insert into" to insert the data into a table. When we use "Insert" also the statement will execute perfectly. create table #tbl(id int) go insert into #tbl select 1 go insert #tbl select 2 go ...

Generally we write "insert into" to insert the data into a table. When we use "Insert" also the statement will execute perfectly. create table #tbl(id int) go insert into #tbl select 1 go insert #tbl select 2 go ...

Generally we write "insert into" to insert the data into a table. When we use "Insert" also the statement will execute perfectly. create table #tbl(id int) go insert into #tbl select 1 go insert #tbl select 2 go s...