Re: Inserting regional settings specific data into sql server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Nikita,


We dont use stored procedures unfortunately (:()

Parameters have nothing to do with stored procedures in Net.

so you can use the advantage

of a parameter array ..ours is a windows based application which some
miserable idiot designed (before i joined siemens) and everywhere inline
queries are directly fired from the C# code using ExecuteNonQuery etc
which
is why this problem has come up becuase we are in the 4th pahase of the
product which is used by european control authorities and those dates are
particularly vital to the systems integrity checks but i am gonna try out
your parse exact suggestion using a number of different regional
combinations
and then testing the app on some of the regional XPs specialy italian,
lithuanian and czech god those buggers are barking up our tree , please
though can you still give me some insite on cultureInfo.InvariantCulture

I have sent a link about that, which clears it in my idea very much

sorry to keep harping on that some how my dotnet gut says i would be safer
using that that relying on fframework 1.1's tardy handling of datetime
through both teh parse and convert fucntions.Incidently dont u ever
sleep...u
always manage to reply so promptly.



.

Relevant Pages

  • Joins and Scability
    ... We have a client server application where a lot of business logic is ... executed in stored procedures in SQL Server. ... complex joins between 3-4 tables or more. ... While I dont have specific ...
    (microsoft.public.sqlserver.programming)
  • Re: Joins and Scability
    ... > We have a client server application where a lot of business logic is ... > executed in stored procedures in SQL Server. ... > complex joins between 3-4 tables or more. ... While I dont have specific ...
    (microsoft.public.sqlserver.programming)
  • T-Sql debugging directly from vs2005
    ... Is it possible debugging Stored Procedures in SQL2005 directly from Vs.Net ... I know that with SQLCLR procedures its works but I dont know how to work ...
    (microsoft.public.vsnet.debugging)