Viewing 15 posts - 1,336 through 1,350 (of 2,894 total)
AndrewSQLDBA (8/21/2012)
August 21, 2012 at 7:55 am
And let me suggest you one tip:
Store duplicate of your data without any formatting... You should get unformatted text when you save the data from UI, as it's easy in...
August 21, 2012 at 5:49 am
Sergiy (8/20/2012)
CELKO (8/19/2012)
2. CONVERT() is an expensive string formatting function, with all those old Sybase options; substring and concatenation are cheap, simple and fast.
....
Turns out, SUBSTRING with concatenations is...
August 21, 2012 at 5:38 am
I hardly can see how self-learning something else (eg. SQL) will help you much in your case right now. No, I am not saying you shouldn't learn something else, people...
August 21, 2012 at 5:23 am
1. CONVERT() is proprietary and will not port; substring and concatenation are Standard.
Port to where? SYBASE? DBASE? MongoDB? Mars? Alpha Centauri?
Do you seriously think that it would help much...
August 20, 2012 at 5:04 am
...
If we are talking about timming spaces or doing smth else with the elements, it would be better to split string, do manipulations and concat it back.
or use well known...
August 17, 2012 at 6:04 am
Have I lost something? Do you need to change datatype of the table column or you need to change the datatype and values as well?
If only column change, than the...
August 17, 2012 at 5:29 am
SomewhereSomehow (8/17/2012)
Try using replace function like this:
declare @a varchar(100) = 'akraft,crunckel';set @a = ''''+replace(@a,',',''',''')+''''
select @a
The above will not produce exact expected results for some of the cases:
Alexandria, VA,Arlington, TX
will be...
August 17, 2012 at 4:56 am
raghuldrag (8/17/2012)
select top 2*
from empy order by cast(sal as int)desc
in these query has given first two max values, now i need the ouput while i am giving the...
August 17, 2012 at 4:48 am
raghuldrag (8/17/2012)
ya its workin..... suppose i need the particular top 3rd postion of max salary means how to modify
I'm not 100% sure what exactly working...
And what do you mean by...
August 17, 2012 at 3:59 am
...
That will teach me to not try and answer questions before drinking coffee, thanks Chris.
Seeing your avatar, I wouldn't think that you are great coffee-lover. Are you sure that you...
August 17, 2012 at 3:56 am
ChrisM@Work (8/17/2012)
HowardW (8/17/2012)
update xys set submitdate=NULL where id in ('1','2'.........'100')
I feel I must be missing...
August 17, 2012 at 3:51 am
There is a dedicated forum here for SQL 2000:
http://www.sqlservercentral.com/Forums/Forum8-1.aspx
Ok for this time.
Lets have a look your sample from beginning.
1. First of all why are you using varchar for sal column?...
August 17, 2012 at 3:46 am
Dave Ballantyne (8/17/2012)
Hi, this is a bug
Actually, the BoL states, that you shouldn't include identity columns in the column list of output_table, so reported behaviour is the bug (or...
August 17, 2012 at 3:27 am
Lavanyasri (8/17/2012)
I have a column with date datatype. i updated the column with some date like 02-02-2012 00.00.000 ,for 100 orders Now i want to change the...
August 17, 2012 at 3:23 am
Viewing 15 posts - 1,336 through 1,350 (of 2,894 total)