| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> will take a while and another few million
<1> so once they finish it
<1> what's going to happend
<2> ltrim(rtrim()) did not work :(
<1> will they start throwing bums on the other side?
<0> no, then they'll really have something to bitch and moan about
<1> who
<0> the palestinians
<1> how are they gonna get rid of insurgents from within jerusalem
<0> body bags?
<1> hold on, if they build the wall.....what's gonna happend with jerusalem
<1> can't build a wall there can you?
<0> i think it runs through part
<1> isn't their mosque right next to the wailing wall?
<0> western wall and yes, its 'on top'
<2> http://sql-servers.com/nopaste/?show=170
<2> http://sql-servers.com/nopaste/?show=171 <- with ltrim and rtrim
<1> it shouldn't pad
<2> isql.exe -h-1 -n
<2> yeah, i'm not sure why it is. :/
<1> df: so when will i be able to visit safely?
<0> now, you can always visit safely
<1> and get blown the **** up?
<0> you're more likely to get mugged in new york than here
<0> bah
<1> so when the wall thingie is complete no more bombings?
<1> how high is the wall and does electricty run through it?
<0> i don't think its electrical, but i'm not the resident wall expert
<0> google is more of an expert
<0> i've never even seen the damn thing in real life
<1> why? go see it, kinda interesting
<1> what is the wall called?
<0> 'hey, look, a wall'
<0> i think its called 'Wall'
<1> nah it has to be called somtehing
<1> like
<1> strategic anti-**** wall
<0> dunno
<0> back in a few
<2> i added "-s" to the isql command line and that got rid of the leading blank character, but there are still like 200 trailing spaces
<2> must be the datatype :>
<2> the datatype is nchar(260).
<2> i tried to CONVERT(nvarchar, LEFT....) FROM ... but that didn't work
<2> so any ideas on how to convert a nchar(260) to a nvarchar datatype?
<3> iconocop, convert to nvarchar and ltrim/rtrim it
<0> ltrim(rtrim(cast(blah AS nvarchar)))
<2> ok, i will try. thank you dfworking! :)
<2> i tried a CAST(... AS nvarchar) but it seems to truncate valid characters.
<2> "C:\Program Files\Microsoft SQL
<2> as opposed to "C:\Program Files\Microsoft SQL Server\MSSQL$MSSQL\Data"
<0> then use convert, but i see no reason why it would truncate
<0> with cast
<2> i also tried CONVERT and i get the same thing :/
<0> no idea
<2> ok. i'll keep trying. thank you.
<2> "An nchar can be either explicitly or implicitly converted to nvarchar."
<4> hey, i installed XAMPP on my linux, how do i enable CLI mode? ...
<2> i fixed my problem by declaring a nvarchar(260) datatype and then doing a SELECT @filepath=LEFT(....)
<2> and the new var did not contain trailing chars
<5> hello
<6> hi all.
<6> got a weird problem with a database field.... it says its T_MEMO (text) 16
<6> but when i try and output from this field to web site the char is limited to 101 characters
<2> what type of db?
<6> MDB, so its MS-SQL
<2> isn't a mdb an access file?
<7> Mark_H : MDB is not ms-sql, MDB is the file extension used by MS-Access
<6> it makes an MDB
<6> MDF
<2> yes, mdf is mssql ;)
<6> sorry long day :S
<6> :)
<7> Mark_H : how are you attempting to output the value?
<6> and ldf
<6> ok well,
<6> its a recordset, but i cant view into that recordset.
<6> lame system work use you see
<7> Mark_H : 'recordset' is nothing to do with ms-sql
<6> its iCODE Everest
<6> yea I know
<6> but i am think its a field limitation
<0> mssql: say i have a server that has a ****load of data in a table, and from another server i execute a query which references the first server and aggregates and sorts and whatnot. where is the actual hashing/sorting performance burden taking place, on the source server or the one doing the querying?
<7> how is the field defined in the recordset
<2> the actual data in the database is > 101 characters?
<7> ?
<6> no
<7> dfworking : on the source server
<6> I've put into the field approx 140 char
<0> any way to change that short of moving the data?
<6> but it doesnt show anything past 101 char
<7> dfworking : no
<0> blah
<6> YuppieScm I dont know :(
<7> dfworking : actually, that's not completely true
<6> I cant obtain information from the RS
<7> Mark_H : why?
<6> its really crap
<6> its a dll
<6> and a component object.
<6> all calls go through it
<6> then to the DB.
<7> Mark_H : then how do you know it's a recordset?
<6> http://pastebin.com/525438
<0> YuppieScm, interested if you were planning on elaborating
<6> thats the ASP which calls in the field
<0> i can explain the scenario more if thats helpful
<7> dfworking : if you're doing trusted connection between the servers
<0> yes
<6> YuppieScm I didnt mean help with the ASP
<6> I am simply stating that it is from an RS
<0> its a linked server, or can be
<6> my question still relates to SQL
<6> should T_MEMO (text) 16 allow for approx 140 chars?
<0> it allows 2gb man
<7> dfworking : then, for example, if you do a join, the work 'should' be carried out by the server executing the sql
<2> from SQL Books Online (BOL) "Usually, text, ntext, or image strings are large (a maximum of 2GB) character or binary strings stored outside a data row. The data row contains only a 16-byte text pointer that points to the root node of a tree built of internal pointers that map the pages in which the string fragments are stored."
<2> Mark_H, from SQL Books Online (BOL) "Usually, text, ntext, or image strings are large (a maximum of 2GB) character or binary strings stored outside a data row. The data row contains only a 16-byte text pointer that points to the root node of a tree built of internal pointers that map the pages in which the string fragments are stored."
<0> so, if the server is linked, then it 'should' carry the burden itself and the source is only involved insofar as its delivering raw data for the other's usage
<6> YuppieScm why kick me for my choice of pastebin,
<2> Mark, maybe there is a "bug" in the dll that actually makes the query?
<6> correct because?
<6> icnocop possible.
<6> it wasnt SQL Code... and my choice of pastebin for the ASP
<7> dfworking : indeed - although there may be some cleverness in the query optimiser that will hand off some of the processing to the far server
<6> it doesnt state pasting ASP code to your !TOPICS! url
<7> to prevent the entire traversal of a table over the network connection
<6> therefore the reason for doing so to pastebin.com
<6> anyway
<0> Mark_H, the pastebin in the topic has been reviewed by the priesthood and local authorities and deemed to be the politically correct one to use. jesus would use it, if thats any help.
<2> Mark, you do not have the code? documentation/sdk? maybe there is an updated version?
<6> icnocop unfortunately no
<0> YuppieScm, ok, thanks
<7> i hate people who whine
<6> i hate ops who kick for no real reason.
<0> whining is good when there's *** involved
<2> lol dfworking
<0> nothing like a good whimper to let you know whose boss
<6> other than to extend their over bloated ego's
<7> dfworking : whining usually happens before ***
<0> who's
<0> i don't think YuppieScm's ego is over bloated, i suspect that its always been that size naturally
<7> actually, it's shrunk since it's heyday
<0> can't imagine how painful giving birth to someone with so many skillz must have been
<7> oh, that was easy, i did the delivery myself, as i'm also a trained midwife
<0> if you want something done right...
<2> Mark, i ***ume the dll is not a generic database helper and depends on specific data fields and types. you may be sol with that limitation
<6> yea
<6> or i may well need to write my own RS to pull into the page.
<0> sol goldstein?
<2> **** out of luck
Return to
#sql
or
Go to some related
logs:
danno413
#computers
#gentoo
women msn adress
#flash
#photoshop
VIADSE
Sewell Bellhaven
microsoft file transfer manager 99%
#computers
|
|