| |
| |
| |
|
Page: 1 2
Comments:
<0> hope i cleared that up for you
<1> but isnt there any way to do that?
<0> yes
<0> [10:25] <0> insert... inserts, update... updates
<1> what do you mean by that?
<0> uhm
<2> There is no one statement to do that, no.
<0> insert will INSERT new rows
<0> update will UPDATE existing rows
<0> how about you apply conditional statements to both commands
<0> and run them both
<0> update rows that already exist, insert rows that don't exist
<0> see the logic fizz?
<1> Darken|, that will kill my servers
<1> im talking about LOADS of data
<1> but i guess ill have to do that, im now working on making it in the best way.
<2> You don't really have a choice.
<3> Hello. I'm installing SQL Server 2005 Developer. In the past, I had problems with ntbackup with SQL Server running, so I'd prefer to only start SQL when I need it. I see in the install that I don't need to make server start on bootup. If I opt to not have it start at bootup, how do I start SQL server manually?
<4> uncaged : "net start <blah>"
<3> joking, right?
<2> Like how you start any service in Windows.
<3> So in Services?
<3> Aren't there several services involved?
<4> uncaged : why not go and find out?
<2> The database requires only one service. There are several optional support services.
<3> thanks, Halo
<4> you're welcome, you miserable ****er...
<4> damn
<5> yeah, and dont come back :P
<6> hi... I know this is kind of out of line with the purpose of the channel... but, anyone knows if I can export an existing ms access's table structure to ddl statements?
<7> is it possible to have java / javascript code executed from a pl/sql function/procedure ?
<8> d3r3k: http://thedailywtf.com/forums/63510/ShowPost.aspx
<9> d3r3k you can run java with pl/sql yes
<9> oracle has a built in java engine
<7> thanx :)
<10> that's sweet :)
<11> is anyone willing to help me on private chat
<11> it increase your karma
<10> :)
<9> just ask your question
<10> fire away in the channel; we don't bite
<9> karma my ***
<11> u dont beleiev in karma your loss
<9> you dont belive in asking a question, your loss
<11> u need to chill and take life bit more easily
<9> why cant you ask here?
<10> I can see where this is going
<9> am I always so obvious ? :)
<12> is there a way to perform a select query in oracle and just have distinct on one column... i.e select (id), name, age from Person ?
<11> Because i dont want to paste like lines of code and i dont want to ****ing use pastebin eiother
<10> CoJoNEs, hehe
<9> |meller| whatever you dont put in your distinct you need to group by
<10> JSql, sounds like you want help on *your* terms; it doesn't work that way here
<10> heh
<9> yeah
<9> I like your point though
<10> thanks; he PM'ed me before he asked the karma thing
<9> yeah he PMed me too
<9> and probably anyone else that said anything on the channel
<10> indeed
<12> CoJoNEs: yes, thats my problem.. how can i use distinct on i.e ID.. and i want all the ID to be grouped by the name its belonging too?
<9> use group by name
<12> but if i use group by name, then i have to use name in the select statement
<12> and if i do so, it will select distinct names
<12> cause distinct cant be used on only one column
<9> hmm.. im trying to think of how you can do it.. not sure it even makes sense
<12> too bad distinct applies on all the selected columns :/
<13> i am useing mssql to execute
<13> http://sql-servers.com/nopaste/?show=402
<13> Server: Msg 245, Level 16, State 1, Line 1
<13> Syntax error converting the varchar value 'unknown' to a column of data type int.
<13> and geting that error msg
<13> how could i fix that ?
<14> When using the CREATE SCHEMA command what does the GRANT actually apply to? The SCHEMA or the TABLE? Im using MSSQL2005.
<14> because when using ssms the role given SELECT, INSERT, ... permissions is not set, even though GRANT statements are there for the schema/table
<12> CoJoNEs: got any suggestions yet? :p
<14> basically, doing the example does not yield the result stated
<15> What query can we run to select last n rows from the table ?
<14> @@ROWCOUNT?
<16> hi
<14> oh.. nm
<16> can anyone help me with a little question?
<16> $sql = "SELECT topic_id , topic_title FROM `phpbb_topics` WHERE forum_id =1 ORDER BY `topic_id` DESC LIMIT 0 , 5";
<16> i want to use the select not only with where forum_id=1, also forum_id=2
<17> jhjkkhj did you read the rules in the topic?
<16> how would the query?
<16> how would be the query?
<16> I don't see any rules in the topic
<16> arrakis, are you spanish? arrakis is the name of an ISP here in Spain
<17> no i am not spanish
<14> http://rafb.net/paste/results/MaNHjs90.html
<9> jhjkkhj where forum_id in (1,2)
<14> why am I not seeing grant on SELECT, DELETE on the created objects when using ssms?
<14> all the permissions are blank, on schema, table, you name it
<9> StvJhn what rdbms?
<16> CoJoNEs thanks
<14> GRANT works, its only when I use it inside the SCHEMA definition that permissions are not set
Return to
#sql
or
Go to some related
logs:
#beginner
#politics
#sql
#stocks
Weelwood
#computers
open source mp3 recorder
#beginner
#politics
#beginner
|
|