| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> since it's DB2 on an AS/400 they also incorporate these damned EBCDIC files that I can't touch with SQL. I have to go around my *** to get to my elbow and copy the file out to another intermediate structure, query it, then destroy my copy before they find out and have a fit.
<0> it's all insane
<0> thanks for hte help MuteThis :)
<0> oh, and they use six different string formats for dates *hehe*
<0> mute, your version is faster than mine
<1> your welcome
<1> which version? exists or in?
<0> Exists
<1> in mssql how can i clear out cached execution plans?
<2> freeproccache?
<2> or something like that
<1> thanks
<0> thanks again guys :)
<0> (or gals)
<3> i am using sql server 2000.. and i setup a user
<3> and ***igned it all the privileges i could find..
<3> and it can't insert
<3> i can't seem to find where the problem is.. it can update, delete, and select but can't insert
<3> is there a simple way to add users?
<3> with all privileges?
<2> did you give it the permission db_denydatawriter?
<2> :P
<3> maybe... ;p
<3> i have to go back to the client's now and see..
<3> is there anything else it could be?
<3> i went under priuvileges and checked all those checkboxes..
<2> if its a global thing, probably not
<3> okay
<2> because im sure you didn't miss the "insert" column for permissions
<3> thanks a lot
<3> yeah i didn't
<3> ;)
<2> but, the easiest way to give all permissions in a db is to just ***ign a user to dbo role
<2> or like db_datareader db_datareader / db_datawriter roles
<3> ah i see
<3> great thanks
<3> heading there now ;)
<4> Hey guys...
<4> Question...
<4> If I have a list of data separated by commas... and I want to match something in another table based off something inside that comma delimited list...
<4> Whats the best way to do that in MSSQL/Oracle?
<4> Like if I have 1,10,2,20 and Wanna match the 2 in another table...
<5> look on google; there is lots of sample code to parse a comma separated string into a table
<4> well I am attempting to do a view... You would just have to drop the table at the end of the view, right?
<5> you'd create a function that takes a varchar() as a parameter, and returns a table
<4> hmm
<5> the table is treated then like a normal variable; it doesnt need to be dropped
<4> never done that
<4> Looking on google now... Not quite sure what to look for though
<5> http://informit.staging.informit.mttech.com/articles/article.asp?p=31673&seqNum=4&rl=1
<5> half way down - dbo.parse_comma_delimited_integer
<4> yeah I see it
<4> But how would you incorporate it into a view..?
<4> a cursor to put the right data in places?
<5> create view dbo.myview as select * from dbo.parse_comma_delimited_integer('1,2,3', ',')
<4> well
<4> yeah
<5> if you need it to take in a parameter, then you can't use a view
<4> But I need to get the data corresponding to those #'s
<5> and you'll have to make a function or proc
<6> If it's MSSQL2K5 you can use a tabular UDF and CROSS APPLY
<4> like 1, 2, 3 would be like Barnes and Noble, Google, CNN along with the other info
<6> I don't know if Oracle has a similar join predicate
<5> Kranfer then join
<6> Best thing would be to not store children in one record.
<4> well I have no choice
<6> It's an RDBMS, not an MVDBMS
<4> isn't there like an instr function for SQL?
<6> MSSQL has CHARINDEX
<4> Yeah I didn't think of that
<4> Thats works perfectly :)
<7> heh
<7> that took long enough to ge done
<7> kinda ****s trying to match up two datetime values when they may or may not even be entered
<2> moofluffy: vhat?
<4> with CharIndex is there a way to make 10 and 1 not match?
<5> Kranfer what are you trying to do?
<5> you still working with comma sep lists?
<4> match a code in another table to a items in a string
<4> yeah
<5> why didn't you listen to what i said
<5> use that function from that page
<4> Because I don't understand how to use another table
<4> to check it
<4> when its created on the fly...
<4> and theres numerous rows..
<4> And the function won't work in oracle
<5> select * from Companies a inner join dbo.parse('...') b on (a.ID = b.ID)
<5> oh
<4> it'll work fine for the MSSQL databases we have but not in oracle...
<4> is there a way for CHARINDEX to match exactly?
<4> so 1 does not match with 10
<8> Hey all, I'm trying to locate the syntax for MSSQL to set a field's identity to yes or no, but having trouble locating it. Can anyone tell me or point me to a reference for the syntax to set an identity for say field1 in table1?
<4> ?
<4> do you know tenfour?
<5> nope
<9> ken- : did you read the ALTER TABLE help?
<8> yes but I didn't see an example for setting identity
<9> ALTER TABLE table ALTER COLUMN column IDENTITY(1,1)
<9> I think that is the correct syntax
<8> ah ok, and I'm guessing IDENTITY(0,0) would turn it off?
<9> I'm not sure, never tried to do it via raw SQL - I use Enterprise Manager
<9> Its a good tool to use if your not already
<9> You can also trace and see what SQL statements are being executed by enterprise manager if your really curious
<8> I do use it, but I am writing a script to do some maintenance for a database
<8> and the only way I know to reset the identity values for a table key is to turn the identity off and back on
<9> I think TRUNCATE will reset the identity
<8> ah ok I'll look into that, thanks
<4> tenfour: I got it to work...
<4> If you concat a , on to the end of the field being looked for... it works fine :)
<8> Thanks btw twint70s truncate is exactly what I'm looking for :) I'm a programmer not a DBA lol I'm sure our IT admin would slap me for not knowing
<10> How can i search for matching fields with text undepented of UPPER/lower case ?
<10> h found it.. UPPER
<10> :p
<2> Ben--: no, it's lower
<2> :P
<11> heh
<2> twint70s: for the record.. identity can't be set with alter column, you need to drop and add a new column with identity
<12> i need a good web guestbnook that aint gonna get hacked
<12> any recommendations?
<13> z4m04 that has nothing to do with sql
<12> what if it uses mysql ?
<13> i recommend you find the correct location to ask that question
<13> if it uses mysql then i tell you to screw off
<12> i own this channel
<13> the only thing you are entitlted to in this channel is a free ban
<13> entitled
<12> um, what?
<13> you heard me
<13> go ask your question else where
<13> you're cute
<12> keep it up and get banned
<2> brilliant
<14> Oooo. Pissing contest. Anyone have popcorn?
<13> Drk`Angel do not instigate
<13> or you will be banned
<14> **** happens you know. I'm sure I'll survive. Somehow ... someway.
<15> mysql4, i am having trouble making a case in-sensative query.
<13> no mysql
<2> z4m04: use Advanced Guestbook 2.2
<13> read the rules
<15> lol
<15> i usually use postgres, i hate mysql too
<12> thanks phargle, i'll have a look
<12> cheers
<15> LOWER works. :)
<8> Hey all working with MSSQL7 trying to truncate a table but it won't allow it because of foreign key constraints. is there any way to force it? the table in question has a primary key linked to another tables foreign key but the second table is empty so I'm not sure why it has a problem
<5> in mssql how do i test existance of a temp table?
<2> argh, h8 stupid servers which disconnect you for not having identd
<2> h8h8h8
<16> ken- : no - drop the fk, or trunc the other table first
Return to
#sql
or
Go to some related
logs:
what to do with a vibratoe
#gentoo
#mirc
cutegrl
#narcotics
MDX weekday olap
what is a kanipshit
espn quotes Dirk Nowitzky
teenbopers
#politics
|
|