Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
AnswerRe: sql Pin
J4amieC3-Nov-10 2:40
J4amieC3-Nov-10 2:40 
AnswerRe: sql Pin
RaviRanjanKr3-Nov-10 17:22
professionalRaviRanjanKr3-Nov-10 17:22 
GeneralRe: sql Pin
Gerben Jongerius3-Nov-10 21:39
Gerben Jongerius3-Nov-10 21:39 
GeneralRe: sql Pin
RaviRanjanKr4-Nov-10 8:19
professionalRaviRanjanKr4-Nov-10 8:19 
AnswerRe: sql Pin
RaviRanjanKr16-Dec-10 3:46
professionalRaviRanjanKr16-Dec-10 3:46 
QuestionMigrating from Oracle to SQL Pin
Arudya2-Nov-10 19:57
Arudya2-Nov-10 19:57 
AnswerRe: Migrating from Oracle to SQL Pin
jschell4-Nov-10 8:57
jschell4-Nov-10 8:57 
QuestionDatetime format checking in SQL server stored procedure Pin
Danpeking2-Nov-10 4:54
Danpeking2-Nov-10 4:54 
Hi, I am wondering if there is a way of proofing a stored procedure in terms of the datetime localisation. For example, in the C# we may use the web.config or machine.config to set the application's localised date settings:

globalization uiCulture="en" culture="en-GB">


This helps when we do a date comparison in a static class of ours to return a certain rating factor.

Is there an equivalent way of us checking whether or not the date we pass into the stored procedure is in e.g. UK format and will be compared against our dates in the UK format too? We have 2 datetime columns, DateEffectiveFrom and DateEffectiveTo in our table and we use those dates to compare with the date passed in to return the relevant data.

Thanks
AnswerRe: Datetime format checking in SQL server stored procedure Pin
David Skelly2-Nov-10 7:18
David Skelly2-Nov-10 7:18 
GeneralRe: Datetime format checking in SQL server stored procedure Pin
Danpeking3-Nov-10 5:52
Danpeking3-Nov-10 5:52 
AnswerRe: Datetime format checking in SQL server stored procedure Pin
Luc Pattyn2-Nov-10 7:46
sitebuilderLuc Pattyn2-Nov-10 7:46 
AnswerRe: Datetime format checking in SQL server stored procedure Pin
Jörgen Andersson2-Nov-10 22:45
professionalJörgen Andersson2-Nov-10 22:45 
QuestionHow to compare same field in two tables in sql server 2005 using C# Pin
cancerion2-Nov-10 4:02
cancerion2-Nov-10 4:02 
AnswerRe: How to compare same field in two tables in sql server 2005 using C# Pin
RaviRanjanKr2-Nov-10 4:36
professionalRaviRanjanKr2-Nov-10 4:36 
AnswerRe: How to compare same field in two tables in sql server 2005 using C# Pin
thatraja2-Nov-10 4:55
professionalthatraja2-Nov-10 4:55 
QuestionHow to add image to sql server database ? Pin
Yanshof1-Nov-10 23:37
Yanshof1-Nov-10 23:37 
AnswerRe: How to add image to sql server database ? Pin
Tony Pottier1-Nov-10 23:57
Tony Pottier1-Nov-10 23:57 
GeneralRe: How to add image to sql server database ? Pin
RaviRanjanKr2-Nov-10 4:48
professionalRaviRanjanKr2-Nov-10 4:48 
GeneralRe: How to add image to sql server database ? Pin
Jörgen Andersson2-Nov-10 22:09
professionalJörgen Andersson2-Nov-10 22:09 
AnswerRe: How to add image to sql server database ? Pin
RaviRanjanKr16-Dec-10 3:53
professionalRaviRanjanKr16-Dec-10 3:53 
Questioncan't restore differential backup and tracsaction log. Pin
tan8731-Nov-10 21:31
tan8731-Nov-10 21:31 
AnswerRe: can't restore differential backup and tracsaction log. Pin
Corporal Agarn2-Nov-10 4:47
professionalCorporal Agarn2-Nov-10 4:47 
QuestionEMS SQL for PostgreSQL Pin
Jassim Rahma1-Nov-10 21:10
Jassim Rahma1-Nov-10 21:10 
AnswerRe: EMS SQL for PostgreSQL Pin
TweakBird8-Nov-10 1:07
TweakBird8-Nov-10 1:07 
QuestionPostgreSQL code problem Pin
Jassim Rahma1-Nov-10 3:56
Jassim Rahma1-Nov-10 3:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.