Viewing 15 posts - 10,531 through 10,545 (of 13,874 total)
sradez_DBA (8/13/2012)
Thanks for the reply.
Our project involves storing the every detail of a product(example).When the users search for the product from the UI, they get this file which has...
August 13, 2012 at 9:03 am
This is quite an unusual requirement - do you mind expanding a little on the reasons behind it?
August 13, 2012 at 8:48 am
chris 76827 (8/13/2012)
Yeah sorry I appreciate its all done in memory but I was referring to the write back stage.That's pretty much answered my question, cheers.
That does not mean...
August 13, 2012 at 4:38 am
Shadab Shah (8/12/2012)
Jeff Moden (8/10/2012)
Shadab Shah (8/9/2012)
I have come across various section on this website where it is mention that SQL Server is a set based programming language.
My...
August 13, 2012 at 4:34 am
You have outlined your scenario, but have not asked any questions. What, specifically, are you having problems with?
August 13, 2012 at 2:46 am
priest Ivan Delic (8/10/2012)
Thanks for the quick answer.I simply want to copy my data from table2, table3 to table1.
I have about 25,000 records.
Fr. Ivan Delic
Please follow the link in my...
August 10, 2012 at 8:29 am
Abu Dina (8/10/2012)
This isn't my function but I've been playing around with it so it does what the title above says!
Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin
...
August 10, 2012 at 8:27 am
halifaxdal (8/10/2012)
Thanks for this enlightening discussion. To get the right result for sure for every time, I think I better put an order by clause for every query I write?
If...
August 10, 2012 at 8:26 am
Eugene Elutin (8/10/2012)
5 - 2 + 3 = 5 + (-2) + 3
Now you can see that it's absolutely doesn't...
August 10, 2012 at 3:18 am
dwain.c (8/10/2012)
There's always been a controversy over that acronym: http://www.allvoices.com/contributed-news/6036567-bodmas-is-used-my-millions-at-school-is-it-correct
Quoting that article:
Now if one uses BODMAS on...
August 10, 2012 at 2:56 am
dwain.c (8/10/2012)
Are you trying to say that Division has precedence over Multiplication and Addition over Subtraction?
These are at the same level - and so are evaluated in the order in...
August 10, 2012 at 2:42 am
dwain.c (8/10/2012)
derek.colley (8/10/2012)
Should follow BODMAS, i.e. Boolean, Division, Multiplication, Addition, Subtraction.BOL has division/multiplication at level 2 while addition/subtraction are at level 3.
So the BOL article shows that SQL Server confirms...
August 10, 2012 at 2:26 am
Maybe I am missing something, as this seems too obvious, but ... right-click the 'Constraints' node and select 'New Constraint'.
August 9, 2012 at 10:59 am
sql server developer (8/8/2012)
August 8, 2012 at 11:20 am
Viewing 15 posts - 10,531 through 10,545 (of 13,874 total)