| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> pretty sure this summed up the other suggestion: <7> ghaharz
<1> ztod wasn't doing that. He used LIKE to see if the ID was in the list.
<2> Leep: That also won't use any indicies even if it manages to work.
<1> Drk`Angel: That's very true. I'm just not crazy about putting the whole SELECT in a varchar and EXEC'ing it. Something about that seems "kludgier
<1> ... "kludgier" that ztod's idea. :)
<0> anything else is even more bull****ty
<0> using charindex in a similar fashion to the LIKE suggestion
<3> if you fulltext indexed the id column you could the string as is with a containstext query..
<3> but, on that note im off today.. woohooo
<0> or if you just upgrade to an already out of date db platform like sql2k, your options open up considerably
<4> hi guys im looking for the best way to optimise an sql query
<4> on mssql 2000
<4> it's a rather long query with a lot of different joins and columns
<4> what would be my starting point
<5> install something else
<6> Qestion: can i use a stored procedure to return SCOPE_IDENTITY to itself and then use other variables form code to continue proccessing?
<6> or do i need to retrieve the SCOPE_IDENTITY into the code and use another procedure?
<7> thats something i ask myself every morning too
<7> and that since years!
<6> lol
<4> Gm0nEy, yes you can
<6> so i can send a bunch of parameters from code to one stored procedure and have it go through the process
<6> cool
<6> so i wouldnt need to use the RETURN key workd
<6> in that case
<6> also is that a smart way to do things?
<8> The Energy Department will begin laying off researchers at the National Renewable Energy Laboratory in the next week or two because of cuts to its budget.
<8> A veteran researcher said the staff had been told that the cuts would be concentrated among researchers in wind and biom***, which includes ethanol. Those are two of the technologies that Mr. Bush cited on Tuesday night as holding the promise to replace part of the nation's oil imports.
<4> Gm0nEy, yeah
<4> just reuse the thing inside the SP
<4> lol gr0undh0g :)
<9> i'm migrating some databases from sql 2k, to 2k5 is it enough to backup and restore or are there other steps?
<6> Thanks mkroon
<4> MuteThis, isn't there a simple migration guide ?
<4> that would be another way of saying I really don't know if that is the best way to go about it
<10> is it possible to install sql server 2000 on win xp pro?
<10> when i try to install it it says incompatible with this version of windows...
<10> ;
<11> so, that would be a no
<0> those errors are so cryptic
<2> heh.
<2> The only version of mssql you can install on non-server versions of windows is msde and the developer verson.
<10> okay thanks
<10> sql server 2000 installed on win2k3 server tho right?
<10> if i upgrade to that?
<10> *installs..
<12> zoul?
<2> Read when I said again. I already answered that.
<9> wtf, i can't believe they still thave the data type timestamp in sql 2k5
<2> I like the action of the type. They really need to rename it though.
<11> why?
<9> because it needs to be rowversion or something
<9> can't they admint the name ****s and fix it
<0> they aren't the same thing
<0> its a binary datatype used for things like replication and fulltext population
<9> what is the timestamp?
<9> yeah no kidding
<9> you know how many times i see people trying to cast it to a datetime
<9> dfworking: timestamp is an internal database counter
<0> fine, then those people are stupid ***es that don't read docs
<9> i won't disagree
<6> how do i combine @somevariables, @titleID AS INSERT INTO ... VALUES... SELECT SCOPE_IDENTITY AS titleID then continue to insert the just gotten SCOPE_IDENTITY into another table?
<9> but dude, a spades a spade
<6> do i need to use AND or something?
<2> Not everyone reads every page of the docs. You see a column of type "timestamp" and its a pretty obvious mistake to make.
<9> exactly
<9> "A new timestamp value is generated when a row with a timestamp column is inserted or updated."
<9> sounds like rowversion to me :)
<5> cept its the time, is it not?
<2> That's what I usually use it for.
<2> Nope
<2> Its just an int
<5> what SQL server?
<9> Gm0nEy: INSERT INTO tablename (Col1 [, Coln]) VALUES(@Val1 [, @Valn])
<2> Well. Not an int type. Its 8 bytes I think.
<9> Idle`: MS SQL *
<5> MySQL (I know), has it as the time
<5> ah, :)
<5> its not a unixtime then, stored in it. :)
<9> i don't know where i got the impression they were renaming it for 2k5, but damn
<9> unixtime as in epoch?
<2> Mute: They've been talking about doing it for a while, actually.
<5> yea
<2> Idle: Its table unique autoinc, basically. If there's only one column of the type, then every time a row gets updated or inserted, it gets a new value.
<5> Drk`Angel: I get what a rowversion is :)
<9> Idle`: that's what i'm saying
<2> unixtime wouldn't work the same way, no guarantee of uniqueness. :)
<13> hrm
<5> yea, exactly
<5> Timestamp is used to indicate the sequence of SQL Server activity on a row, represented as an increasing number in a binary format. As a row is modified in a table, the timestamp is updated with the current database timestamp value obtained from the @@DBTS function. timestamp data is not related to the date and time of an insert or change to data. To automatically record times that data modifications take place in a table, use either a datetim
<5> from the internet. :S
<14> hey what does & do in a query?
<6> is description a key work in SQL
<6> ?
<2> What?
<6> it comes up in blue in my Sp
<6> just wondering
<2> Oh. Keyword. :)
<2> No idea.
<6> this SP **** is great
<13> hrm
<13> aol just called ...
<13> and not to offer me service ... haha, they offered me a job ...
<13> php developer ... with sql experience ...
<13> damn ... time warner owns just about every crappy thing on the internet ... hahaha
<13> aim, aol, icq, mapquest, winamp ... and a few other 'odd' services ...
<13> compuserve, lol ...
<13> netscape, amazon ... geez ...
<13> I wanna be the guy who owns time warner, haha ... ****ers loaded ...
<15> AOL owns mapquest and amazon?
<13> no ... time warner owns mapquest and amazon ... as well as AOL
<15> ahh
<14> hello is there a problem with this statement?
<15> paste site
<6> whats with that paste site?
<6> looks neat
<6> does it paste stuff in here?
<14> http://sql-servers.com/nopaste/?show=183
<13> no
<14> does anyone know whats wrong with that?
<14> I keep getting "Syntax error"
<6> oh ic
<13> what dbms?
<15> rdbms?
<14> what does dbms mean?
<13> what sql server are you using?
<13> access? mssql? oracle? mysql?
<14> uhh
<14> I'm using an Access database
<14> but SQLServer on IIS
<6> are those the actuall values?
<13> either username or p***word are most likely reserved
<15> double-quotes for Access
<14> yes, p***ed from a form
<13> Halo_Four: it accepts single quotes ... I believe it's a reserved word issue
<6> so they are variables?
<13> P***word is a reserved word, iirc ...
<14> ok i'll try that
<14> brb
<15> Okay, yeah, that could be the case
<14> i want to try one thing at a time
<14> hehe
<13> [P***word] ... not P***word
<6> the quotes right Halo?
<13> zillabunn: try the [P***word] thing first, to keep your code portable to SQL Server
<15> I don't do much Access, despite the fact that I wrote a crapload of Access stuff yesterday
<13> Gm0nEy: stop asking questions about peoples responses to questions that don't relate to you ... either follow along properly, or keep quiet
<13> Halo_Four: neither do i ... but I did years ago ...
<13> and some funky stuff is reserved
<13> things like Username, P***word, Name, etc ... should always be short handed in my opinion ... uname, p***wd ... etc
Return to
#sql
or
Go to some related
logs:
+delphi +dirmon
#openbsd
gentoo libc.so GNU ld script
#politics
actionscript dynamic text rotation doesn't show
#windows
#windowsxp
mx500 anti-afk
#politics
#computers
|
|