| |
| |
| |
|
Comments:
<0> can anyone tell me how can I concatenate variables or calculated values in MSSQL?
<1> you can concatenate varchars with +
<2> how can I copy the data from a column to another column (plus replace the last 3 characters by other 3 characters) in sql server ??
<3> insert into table set col1 = replace(col2, "123", "321")
<3> Something like that?
<3> I believe there is a Replace() in SQL. And it might support going backwards, to a maximum of 1 replace.
<3> Hmm, that would be in UPDATE, but same thing
<3> in=an
<3> bah, my typo ****s
<2> I changed it by update table like :
<2> UPDATE Maintable
<2> SET docFilename = replace(pdfFilename, [.pdf], [.doc])
<2> but he keeps giving error
<2> invalid column name
<2> .doc
<3> Does it give that error on '.doc' ?
<3> You dont need to use " " ?
<3> Or ' '
<3> Around .pdf
<3> and doc for sure.. And why use [] round those two?
<2> it was the ' '
<3> docFilename = replace(pdfFilename, ".pdf", ".doc") or perhaps ' ' instead of " "
<2> now it wotrks
<3> Ah, k
<2> the [] he did it himself
<3> Perhaps thought it to be fields.
<3> [] are used when fields have weird characters in their name, such as space, and dot, in this case.
<2> ah
<3> You cant say; insert into my table 1... but [my table 1] would work
<0> I have a result from a query appearing in 7 rows.. from a function is there a way to put each line/row as a column? in MSSQL
<4> hi, hrm
<4> i need some help
<4> if i want to look up a item on a table WHERE name = something and value = somethingelse, how do i write that in sql?
<4> so it looks for two values that aare the same
<0> u do exactly that..
<0> Select Item from Table where name='something' and value='something else'
<4> so you type WHERE name = 'name' and value = 29
<4> you can't use ,
<0> value='29'
<4> ok
<4> if someone types in '29 for example, how does that effect sql?
<4> does the ' confuse it?
<4> value=''29'
<0> each starting ' needs a closing '.. i think it would consider that one is unclosed
<0> or something like that
<4> and just fail
<0> yes.. but that depends..
<0> if you're getting values from a website it can have unpredictable behaviour..
<0> google for sql injection
<5> need help with a queryof a query
<6> [22:36] * LanShark (~lanshark@dialup-4.248.253.135.Dial1.Washington2.Level3.net) has joined #nasa
<6> [22:36] <LanShark> hello douche
<6> [22:37] <LanShark> you must be busy playing d&d with the camels
<6> [22:38] <LanShark> dont let the ghosts get to you
<6> [22:38] * LanShark (~lanshark@dialup-4.248.253.135.Dial1.Washington2.Level3.net) has left #nasa
<6> lovely guy
<3> ;)
<3> D&D owns. =)
<3> Well, the magic system is kinda flawed, but still
<0> can anyone help me with this code http://sql-servers.com/nopaste/?show=1008
<0> it is supposed to itterate through a table and get the rows which match a certain value (and the next row)
<3> Does it loop anything ?
<0> it does.. but it seems like the where clause is not functioning..
<0> im getting rows which dont match the where ns like 'name%'
<3> Hmm
Return to
#sql
or
Go to some related
logs:
#india
#kl
#chat-world
#worldchat
chatful.com
#india
#kl
#india
readfile.php
Jayde allnitecafe
|
|