| |
| |
| |
|
Comments:
<0> I really need a way of changing the seed via a SQL statement..
<1> hello
<1> I'm wondering if anyone has run into a situation where sql server 2000 (SP4) would not recognize LongVarWChar as a datatype?
<1> I've looked on google and have found nothing on this so far.
<1> has anyone run into this here before?
<2> h
<1> h?
<2> hello
<2> anybody using sql server?
<3> - I want to believe.
<4> hey
<4> WHERE (CANAddress2 = 'Garforth ')
<5> ?
<4> when i populate my table from asp.net
<4> it is adding loads of spaces to the end of everything
<4> whats that all about :/
<4> i used a stored proc to the update
<5> formatted as char not varchar?
<4> 1 sec i'll check
<4> yep
<4> ****
<4> im gonna ****ing kill this guy
<5> hehe
<4> thanks mate
<4> he thought he was so clever writing a function to create sql paramaters given a string and a paramater name
<4> cunt
<4> parLocal.SqlDbType = SqlDbType.Char;
<4> ARRRGHHH!!
<4> ****
<4> is there any easy way to fix this?
<4> auto truncate or something?
<5> thats a valid value for a char field
<4> the fields are varchar tho
<5> trim it?
<5> rtrim it?
<4> like
<4> update bla set foo = trim(foo) ?
<4> rtrim(foo)?
<5> if you wanna strip them from existing varchars yea
<4> Al, why would he have chosen char over varchar
<4> some fields like Address1 are char
<4> others, like Email are varchar
<4> :/
<5> dunno.. a) he is a cocktard b) the 1st line must always be x characters long for some reason
<4> thought so
<4> changing them all to varchar wont cause any problems will it?
<5> not unless other bits of code need it to always be x chars long
<4> nah
<4> cant see why
<4> its only an address
<4> what a ****wit
<4> im glad they are getting rid of him!
<6> mm cocktards..
<4> they were outsourcing stuff to him and paying him a fortune
<4> he is making my life hell though with his dodgy code
<4> al...
<4> can you give me your take on this
<5> ive got old legacy **** from sql 6.5 that is all char, it didnt have varchar
<4> He has a stored procedure for retrieve, update and delete
<4> brb
<4> back
<4> so the update stored proc requires ALL the fields be p***ed into it
<4> but what if i only want to update some fields
<4> you dont ALWAYS want to UPDATE ALL the fields ALL OF THE TIME
<5> heh indeed
<4> so should i then write a stored procedure for every different permeation of update possible>?
<4> coz at the moment what im having to do ****s
<4> im having to open the record first
<4> then write back the original fields just to meet the requirements of the stored proc
<4> thats so gay its unbelievable
<5> you usually know which specific combo of fields you are going to update, so i use sps for those, usp_updateDateAndUser or whatever
<5> if this is some kind of "do anything wrapper" it sould issued UPDATEs directly imo
<4> agreed
<4> the page is so flexible that sometimes i want to update some fields/and sometimes others
<4> however, there is always a "Core" set of fields that i update everytim
<4> e
<4> so maybe i should write a proc for them
<4> call spCandidateUpdateCore
<4> or something of that ilk
<4> and then have bolt ons
<4> like you were saying up there
<4> spCandidateUpdateHWR
<4> spCandidateUpdateCompanyHouse
<4> spCandidateUpdateIndustryInfo
<4> etc
<4> it will take a while
<4> but i reckon it would be worth it in the end
<5> if there are lots id prolly just execute updates directly via a function that took field & value
<4> an sql server function?
<5> client side
<4> or a c# function?
<4> gotcha
<4> he has developed this .NET project as though he was writing vb/asp code
<5> also dont give em names starting 'sp' its slower ;)
<4> really?
<5> sql expects spXXX to me in the master db, so it looks there for them first, then in the current db
<5> me=be
<4> ah
<4> brb
<7> hi
<8> please, i have on DB thes entrys on this order: id5, id4, id3, id2, id1
<8> i need whith "SelectCommand" display only the id3, id2, id1... jumping the last entrys (id5 and id4)...
<8> how i can make that with this -> SelectCommand="SELECT TOP 12 [id], [title] FROM [news] ORDER BY [id] DESC"
<9> nice topic dude
Return to
#sql
or
Go to some related
logs:
#india
#php
his world champion pinball player became a programmer for Data East
Howard Fraust
vikram smooch
copper chimney india
#kl
Kooodhi
PALA VARAN INDIA
#allnitecafe
|
|