Topics
Started by
Posts
Last post
I have a field which contains dates in CHAR(8) format e.g. 11/08/08 = 11th August 2008. However, if…
4 replies
If I want to convert a string to a datetime, if the conversion fails, can I set it to a default val…
3 replies
I want to return multiple rows if there are multiple TODO entries in the SP text. I have tried a f…
3 replies
Hi, I have three columns a, b ,c (all strings) i want to set default value of c as a + '-' + b is…
3 replies
I have the following code that is part of a larger script that runs against several tables cleaning…
2 replies
I need to write a function...which has two parameters one is the unique id upon which we will get t…
1 replies
DISTINCT in a SQL statements with a TEXT field bombs. Is there any work arounds out there?
6 replies
Hey all, I know how to get the last day of the month, but how do I find each month end date for spe…
12 replies
Hi all, Is it possible to remove all punction from a given string? I.E. I'm looking for something l…
5 replies
Hi, I am a beginner in sql server database. I inserted valus into calendar table for some time per…
4 replies
Hello Am using the following query: And i get the following error message: Msg 174, Level 15, State…
7 replies
Hi All, Iam using sql server 2005,can i create a view with parameters? i want to pass the paramet…
2 replies
I have a xml bind with the defined xsd... sample xml : " " I wan to retrive the values from "Sub…
2 replies
Hi! We are implementing a new system, but we have to backup and restore a databases that have infor…
8 replies
I am using , seperated file to load the data. Data contain comma inside "". while inserting comma i…
6 replies
Viewing 15 topics - 9,166 through 9,180 (of 12,234 total)
You must be logged in to create new topics.