| |
| |
| |
|
Page: 1 2
Comments:
<0> yar
<1> rmah: yuck
<2> how can i get presistent objects in sql server 2005 express for free?
<3> why do you have that topic timer on? don't think anybody care about reading it 24 times a day..
<1> none of your bizz
<3> if I can pay you at the door, can I get fair? ;P
<4> Depends how much
<3> hehe..where can I find this door btw?
<4> I can only show you the door, you must walk through it
<5> evening
<6> hi guys, could someone take a look at this for me? - http://pastebin.com/716392
<6> its a sql script i have tried to run through the analyser...
<6> but it comes up with this error " Line 71: Incorrect syntax near '0'. "
<6> does anyone know what could be the problem? all the other storedprocedures got created fine except this one.
<5> daniels : did you read the rukes?
<5> or even the rules?
<6> oh, i am using SQL server 2000
<6> im sorry though.
<6> if you meant the paste of the error message, i sorta misunderstood the rules to mean you cant paste sql code. but you can state an error message.
<5> daniels : i actually meant the rule about the paste site to use - that's why it's also in the topic
<7> my apologies. i have now read the site. um, whats the difference between pastebin.com and sql-servers.com ? like, is there a reason why we must use the site referred in the topic?
<7> here you go though: http://sql-servers.com/nopaste/?show=660
<5> yes
<5> if it didn't matter, there wouldn't be a rule about it
<5> well, that's a nasty stored proc
<5> however, the error you pasted doesn't match the proc
<5> so how about you identify which line actually throws the error?
<5> oh, and top tip : wherever possible, avoid doing variable declarations inside transactions
<5> right - 5 minutes without a response is too slow. if you're not interested enough in an answer to watch the channel, i can't be bothered to help you
<7> yeah, understood. im just glad my *** didnt get booted. lol.
<6> line 71 throws the error
<8> daniels : line 71 of the nopaste doesn't have '0' in it
<8> therefore you need to identify to me which ACTUAL line of the stored proc throws the error
<6> oh right. let me paste the one i used in the analyser.
<8> 'line 71' is not sufficient
<6> http://sql-servers.com/nopaste/?show=661
<8> same issue, ****wad
<8> line 71 reads "and PageID = @PageID "
<6> hrm.
<8> quite
<8> cba now
<6> its telling me 71.
<8> no ****
<6> which is clearly wrong.
<8> no it's not - you're clearly wrong
<8> line 71 of the stored proc, not of the script to create the stored proc
<8> subtle difference
<6> good point.
<6> your so smart ;) hehe. or im just VERY stupid.
<9> you're
<6> okay, the stored procedure hasnt been created on the remote server yet. so it must be referring to the script.
<6> the script is from enterprise manager to input the stored procedure through sql code.
<6> i think its line 144 that its referrin to.
<10> Mysql, if i have in my select query COUNT(*) AS `Total`, i can't use `Total` In the WHERE part of the query, what can i do in order to use it ?
<11> what's wrong with: SELECT a.name FROM a INNER JOIN linkAandB l ON a.id = l.Aid WHERE l.Bid = (SELECT id FROM b WHERE name = 'foo');
<12> hello people
<12> i have a little problem with my database (mssql)
<12> i'm trieng to make a software for a bus station
<8> AlmtyBob : that depends
<8> dhalifax : use the paste site to tell a story - use the channel to ask a question
<12> ok, thanks
<11> actually it turns out it's because I have mysql 4.0 installed
<11> goddamned microsoft Jet has subqueries and mysql doesn't before 4.1, bastards
<11> I understand rule #5 now
<12> i posted the question, what now?
<11> heh
<11> oh, I dunno, paste the link it gave you in here?
<12> http://sql-servers.com/nopaste/?show=664
<11> what's destination_id?
<8> dhalifax : join the city table twice
<12> thats only an identity field (ID)
<11> ah
<5> dhalifax : join the city table twice
<12> hmm.. ok
<12> yuppie could you post an sql for that
<12> i really dont understand this
<12> how do you mean join the city table twice?
<12> i tried that i now i get in mssql
<12> Tables or functions 'destination' and 'destination' have the same exposed names. Use correlation names to distinguish them.
<5> dhalifax : use aliases
<12> now i get The correlation name 'destination' is specified multiple times in a FROM clause.
<12> ok, i've done it
<12> it works
<12> thanks
<13> hello i have a list of URLs, how can i import this in a table?
<13> MySQL)
<14> PLEASE IMPORT INTO TABLE tablename TO_LISTOFURLS(:listofurls***tring)
<14> COMMIT
<15> Hello, I was wondering if anyone had a clean db solution to store a datagrid, with variable x and y coords. Im using sqlite.
<16> create table grid ( int x, int y, whatever data ); ?
<17> is every database completely different in terms of SQL syntax?
<17> this one is driving me crazy, I can't seem to get the proper syntax for INSERT .... IF NOT EXISTS or whatever
<18> SQL Server is terminating due to 'stop' request from Service Control Manager.
<18> anyone know why i would see that?
<14> someone is trying to stop the service?:P
<4> someone stopped the service :P
<18> How do i fix it? The service is running
<14> start it back up. adminfight!!!!
<19> Can anyone help me, I need to update all fields in my column. Each column has a . prefixing the actual data
<19> so like .asdih32
<19> for example
<19> Is there an SQL query that I can use to remove it from every column?
<20> yep
<20> SUBSTRING and WHERE
<19> I tried this
<19> SELECT SUBSTRING(partcode,1,-1)
<19> FROM parts;
<19> I mean
<19> well using Update.. but I was just testing with Select to see what it finds
<20> SUBSTRING is 1 based in sql server
<19> I am using Access as the DBMS and it says Undefind function, I think I will just convert it to mySQL or something
<19> and then run it,
<20> you want SUBSTRING(foo, 2)
<20> also a WHERE foo LIKE '.%'
<19> Using it with Access is saying Undefined Function
<19> Im thinking maybe Access doesnt support SUBSTRING? Is that possible?
<20> sure anything is possible
<20> i haven't used access in a long time
<20> sorry
<20> i'd consult the help documents
<20> perhaps it has a right function or MID
<19> Yeah the help documents are awful, I would love to kick the Paperclips ***, hes so unhelpful
<13> how do i order by length of fields
<4> depends on the db
<13> .. i cant say , not allowed here ;>
<13> "no MySQL"
<4> then go away and read a book
<13> ****you.
<4> or goto #mysql
<20> geesh
<21> pikupossu is a spybot btw ops
<22> How do you show if a table is supposed to have 2 primary keys?
<22> I'm using mssql
<4> you mean 2 primary keys, or a primary key with multiple columns?
<22> I have 2 columns that reprsent together are a primary key
<17> [noob question alert] what are the point of indexes?
<22> to speed up your queries
<17> okay
<17> how would I use them?
<4> sontek, ok
<17> speed is a serious issue for what im doing
<4> because you cant have more than 1 primary key
<4> _null_, hire a dba
<17> hira, haha
<17> this is my own personal project =p
<22> _null_: CREATE INDEX MySuperDuperIndex ON tblMyTable (Column) I believe
<4> then read a book and personally learn
<17> ok
<17> ahh column
<17> that would help me a lot
<4> what database?
Return to
#sql
or
Go to some related
logs:
#beginner
#politics
#dsl
#politics
#politics
#firebird
python calling parent's function
BARETTA EXTREME2
pfn_list_corrupt dell
warbirds on linux
|
|