| |
| |
| |
|
Page: 1 2 3
Comments:
<0> cool
<1> i need to store a boolean value in a column of my table. should i just use a NUMBER, or does oracle have some other datatype i should rather use?
<2> mssql has a bit type. dunno about oracle
<3> Oracle doesn't have a boolean type, unless they've added it in the last few version.
<3> I know 9 didn't.
<3> Use a number(1), or a char, or whatever.
<1> alright:) it just amazes me there isn't a boolean type
<3> It amazes lots of people.
<1> hm.. oracle doesnt have auto_increment either?
<4> built in column level enumeration datatypes (auto increment) are stupid
<4> always lead to poor design
<5> That's one way to rationalize the lack of something that every other DBMS has ;)
<2> "always lead to poor design" heh
<4> why doesnt sqlserver have sequences?
<2> sequences?
<0> What's wrong with auto increment?
<5> I don't know, I would like sequences in SQL Server.
<5> MS hasn't implemented a number of things that would be useful.
<4> flag char(1) check (flag in ( 'T', 'f' )) wow thats hard =)
<4> or 0,1 which is better since you can do bitwise operations
<5> I don't think many DBs implement boolean types to the ANSI spec.
<5> I know SQL Server doesn't.
<4> plus it isnt requireed for any level certification of ansi sql i dont think
<5> Probably not.
<5> The ANSI specs are kind of useless.
<3> tm_: Oracle uses generators instead of auto_inc.
<3> Personally, I like them better.
<5> But I guess that's what happens when the standard changes very slowely, lacks a great deal of what is considered necessary functionality and all of the vendors want to differentiate themselves.
<3> Halo: I blame vendor differentiation the most. Have to compete somehow, and pretty much all of the major players are "fast" now ... so you have to do something else to stand out.
<6> auto-increment crap makes set-based ops very hard in many cases
<6> inserts, most notably
<1> Drk`Angel: yeah i just found out :) do i have to make one separate for each table (i'm using it to generate pirmary keys), and what happens if it ever reaches its maximum value? will it check for free "slots"?
<3> I don't think I've ever had a generator reach the maximum value, even in a transaction table that had inserts happening a couple of hundred times a second for years.
<3> So, I wouldn't worry about it.
<4> "generators" like 35 kva?
<6> diesel, preferably
<3> No, as in Oracle number generators. :)
<4> which reminds me i need to schedule another generator checkup and refueling
<3> Sequences, generators. Whatever. I've always called them generators, but I haven't used oracle a LOT since 7 ... did they change the name on me? :)
<3> tm_: Default maxvalue is 999999999999999999999999999 if you don't specify. I don't think there's a lot to worry about, really.
<5> That's a big number.
<7> im trying to use DTS to transfer a database to another SQL location and i get this error "Specified onername 'username' either does not exist or you do not have permissions to use it."
<6> self-explanatory, that one
<7> DBO - sa is the only owner of the database though
<7> there is n user ***oicated with it
<1> Drk`Angel: alright, i think i will wait with worrying about running out of numbers then :)
<7> any help would be aprechated...
<4> did you specify sa?
<7> yes
<8> SQLServer2k, is it possible to configure an execution priority for a connection to SQL Server
<6> CaspanMCP, it means it's trying to create an object, and the login of the owner does not exist as a user in the database, i.e. CREATE TABLE joe.customer (LastName varchar(10) NOT NULL), and 'joe' is not a valid database user on the target system
<7> yeh im just finding out now that the user name is an owner of the table not the database
<1> hm.. the java application my university supplied me for interacting with oracle is full of bugs. could anyone recommend some (free) program that allows to work with an oracle db and give it sql commands?
<7> im changinging them to dbo as the owner of the table
<7> i hate idiots that cant design databases properly
<4> tm_ sqlplus, tora
<4> tm_ or its user errpr
<7> shouldent say idiots but people that dont do planning properly
<6> why? you suggesting that everything should be owned by dbo?
<7> well all our development database have to be moved constantly from dev to staging to live
<7> so if im moving databases all the time i cant have independent users to that system as owners of tables. I need a universal user that exists on all SQL instances
<7> its our procedure here to do that so to see this error threw me for a loop
<5> Fairly sure DTS can move users.
<7> yes but as a standard we dont move the users and permissions with teh databases
<7> we can move it with teh database yes if we wanted to though
<9> changing it to being owned by dbo is a good idea CaspanMCP.
<7> i dont know if it was a good idea or not but thats the way our development modle is said to use
<7> if its not that way then i waste 20 minutes trying to fix it
<7> there are 100 tables with ownership applied to a user
<7> time to start clicking :)
<9> you could get stuck thugh if you end up having two tables with the same name :P
<7> yeh true
<10> http://tinyurl.com/zqewe
<6> when you perform the "copy objects and data between sql servers" procedure via DTS, there is an option to copy logins and/or database users and roles. Use it.
<7> for a security reason we dont like to do that
<7> then you have rogue users on your live server that you neer knew about
<7> i like to copy fresh DB's up and create the needed users my self
<6> then use sp_help_revlogin or some similar script to move only permissible users, and don't copy logins via DTS
<7> that way i know that user is what it should be
<6> point is, joe.tablename is not 'always' an id10t thing.
<5> SQL2K5 implements that in a completely different way, which I think is (closer to) ANSI
<6> right
<7> yes i corrected my self to calling the person an idiot restating that he did not follow procedure when designing the table
<6> in 2000, the only way to have 'schema' was to use the owner name, but then you had ownership transfer problems
<5> nod
<5> In 2005 the schema is a grouping mechanism for database objects that is independant of users/roles.
<11> We are looking for Java developers (of any experience level) to work in the Detroit area. /msg me if you are interested, or know someone who might be.
<12> did you consider asking in #java you frigging genius?
<13> A question guys ... why would this: http://sql-servers.com/nopaste/?show=399 give me a completely different result set to this: http://sql-servers.com/nopaste/?show=400
<13> (sql server 2000)
<14> ugh those column names are fugly
<14> I'm guessing it's a vendor solution?
<13> yes it's a vendor solution but an in-house report
<13> any idea re the query
<15> well, without looking at the data, I like the first one better. Never use outer joins unless you have to, they are inherently inefficient
<15> ..but I guess that doesn't matter too much on a report
<13> well regardless of that ... the query would more suit me without a nested select ... so I'm very confused as to why there is a different result set when as far as I can see the query should looks the same
<15> well, which query yield the correct (or expected) result?
<13> Thanks guys :)
<15> heh, apparently he doesn't know which is correct
<11> dfworking: FYI: Java developers use SQL sometimes.
<12> i stand corrected. carry on.
<1> do i need one sequence object for every table?
<16> what is a sequence object?
<17> an oracle sequence i guess ;P
<1> uh, yes, thats what i meant :P
<17> if you want to generate PKs from it then yeah
<1> thanks:)
<1> i thought using oracle would be just like using SQL like i was used to -- but no :P
<18> meh
<19> hello
<15> howdy
<19> is there an SQL statment where the results would be the combination of table1 then table2?
<20> boi: UNION
<20> SELECT f1,f2 FROM t1 UNION SELECT f1,f2 FROM t2
<21> Is this room just SQL or can I ask an ADO question too?
<20> mark: sql only, but I might be able to help with ADO - or you can try #asp.net or #asp
<20> or #mscorlib
<21> EyePulp, may I PM?
<20> nope/
<20> try here, if someone hates it, you'll hear soon enough.
<21> Do I have to make sure other settings are set properly in order for AbsolutePage to work correctly? It keeps returning a -1 when there are records present.
<20> what sort of cursortype are you setting?
<21> 3 static
<21> static and keyset are the only ones that allow the page to even load
<21> web page, sorry
<20> are you setting your pagesize?
<21> yes. It's set to 10
<20> cachesize, cursortype, cursorlocation
<21> I just set cachesize to 10. What should cursorlocation be set to?
<20> try 3
<21> Yes!
<21> Thank you
<20> np
<14> or 42
<20> google is your friend.
<20> rhelik: the answer to everything?
<14> yes
<22> hi
<22> in mssql how do you escape '
<23> run real fast
<14> mnk0: well it should be just ''
<22> Men's Coffee
<22> is what i want to insert, .. do i need to replace ' with ''
<22> ?
<14> stfu
<14> Women's underpants
<14> is what you wear
<22> yeah, but only at night
<6> Nice topic :)
<9> or you can use the escape keyword and use whatever you want
Return to
#sql
or
Go to some related
logs:
#beginner
Nero ShellManager Corruption
ziebart criminals
#politics
#stocks
quakenet xmlsockets
americanbulls anyone?
#windows
#windowsxp
#nhl
|
|