MSSQL Query in VB.Net Fails

• • Reply

  11 years ago

  by 7upsk

  P Sujithkumar

  HYD, India

  Joined 11 years ago

  I have these queries in my program getservertime function which gets the server time by executing SELECT getdate() as ServerTime. This Query is followed by update myusers set LastVisiteddate = '" & getservertime() & "' where StrUsername = '" Uname & "'"

  Few of the times I find that the value of LastVisiteddate is updated as "1900-01-01 00:00:00.000" which is the 0 value for date. What could be wrong 1) Is this happenning because of the SQL server Load at that particular point of time. 2) Is server not responding the query in time, if so should i introduce a delay between these two queries. Please assist me

  Report abuse
• • Reply

  11 years ago

  by 7upsk

  P Sujithkumar

  HYD, India

  Joined 11 years ago

  I have these queries in my program getservertime function which gets the server time by executing SELECT getdate() as ServerTime. This Query is followed by update myusers set LastVisiteddate = '" & getservertime() & "' where StrUsername = '" Uname & "'"

  Few of the times I find that the value of LastVisiteddate is updated as "1900-01-01 00:00:00.000" which is the 0 value for date. What could be wrong 1) Is this happenning because of the SQL server Load at that particular point of time. 2) Is server not responding the query in time, if so should i introduce a delay between these two queries. Please assist me

  Report abuse