Viewing 15 posts - 61 through 75 (of 287 total)
I'm not 100% sure of the requirement. If the goal is just to remove the string in the column Point from the Link column or if there is more too...
April 18, 2011 at 2:47 pm
I assume you have a reason to format the date as a string in that format, but if not then you should really look into formatting in an ISO format.
April 13, 2011 at 12:14 pm
kick_12309 (4/13/2011)
Is there Any limit on rowversion...i mean is thee any possibility that Database reached its maximum rowversion?
Sure it's possible.
But, just using BIGINT starting at 1 and doing 5000 changes...
April 13, 2011 at 11:54 am
Like everything SQL, It kind of depends on what you are doing and how you are set up from a hardware perspective.
If you have a "script" you can either put...
April 13, 2011 at 9:14 am
It's an 8-byte number. From BOL:
A nonnullable rowversion column is semantically equivalent to a binary(8) column. A nullable rowversion column is semantically equivalent to a varbinary(8) column.
April 12, 2011 at 2:03 pm
ichiyo85 (4/12/2011)
April 12, 2011 at 1:53 pm
There are a couple of things happening here that might not be too obvious.
1. implicit converstions - even though you have a value defined as NUMERIC(18,2) (or whatever) when you...
April 12, 2011 at 1:46 pm
pdonley (4/8/2011)
I know that cursors are evil, so I try not to use them. I've read that they are evil because they lock the table that you are iterating...
April 8, 2011 at 4:21 pm
IsNumeric is something I suggest people do NOT use. I'm not sure if this helps, but I was having a discussion with a co-worker the other day and put this...
April 8, 2011 at 1:35 pm
Probably not important, but you can also make sure of the DATENAME function, that way sql will handle localizing the name of the month is that should ever be needed.
April 8, 2011 at 10:48 am
Here is a link that talks about amny different ways of dealing with arrays is SQL:
http://www.sommarskog.se/arrays-in-sql-2008.html
My (and I think others) preferred method is to use table-valued parameters.
March 31, 2011 at 1:39 pm
Any chance you'd like to share more details about what you are trying to accomplish?
There are, of course, many ways to do many different things. But, are you doing some...
March 29, 2011 at 5:32 pm
Depending on what tools you have available you could do some sorta of Schema Comparison. Visual Studio 2010/08 work well for that sort of thing.
March 18, 2011 at 4:56 pm
If you use RAISERROR and add the WITH NOWAIT directive it'll return results at run time. For example:DECLARE @I INT
SET @i = 0
WHILE @i < 10
BEGIN
RAISERROR(N'Message...
February 3, 2011 at 12:34 pm
January 12, 2011 at 11:28 am
Viewing 15 posts - 61 through 75 (of 287 total)