| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> http://sql-servers.com/nopaste/?show=513, uisng msde. I should get Itemsold=0 ItemsAmount=0.
<0> but instead i get Itemsold=8 ItemsAmount=5.60
<1> heya.
<1> In ms sql server, is there a query to get all tables from the current db?
<0> As no products were ordered by @product_category_id int = 75
<2> hi im using ms sql 2005 what is the best way to export from one database to another database on another server?
<2> SSIS?
<3> dannet have a look at select * from sysobjects
<1> thanks
<1> is it also possible to combine to different queries seperated by ; ?
<3> what environment?
<3> I mean query analyser certainly doesn't care how many statements you try to run at once
<1> They give 2 results
<1> i would like them in 1 resultset
<3> oh BOL union
<1> ah
<3> Union your two queries
<1> i'll check that
<1> guest2
<1> other question
<1> can i determine the table the last query was run on?
<1> like
<1> select * from <table>; select * from <previous>
<4> evening
<2> anyone use SSIS?
<2> or business integration services in mssql2005
<4> wtf is ssis?
<2> http://msdn.microsoft.com/sql/bi/integration/
<2> that
<3> select * into #thistemp from table; select * from #thistemp
<3> danett^^^^^
<1> i see your point
<3> or you construct a query that selects stuff from a unioned subquery
<4> CoJoNEsX : here's a link that should be in the on-join -> http://go.microsoft.com/fwlink/?linkid=44375
<1> ok
<1> i understand
<1> thank you
<3> no sweat
<2> anyone?
<4> catzai : looks like a 'no' right now - why not ask your question?
<5> Hello, can someboy here please help me with how I can convert from XML chemes to MySQL.
<4> SeeD-Squa : no mysql in this channel - go bother #mysql
<3> so you guys saw http://sqlonrails.org right?
<3> greatest april fools joke in awhile
<2> so no one uses SSIS?
<3> look at the webcast and downlaod the files, it's hilarious
<3> catsai, if thats SQL2005 then it might be too new... I haven't even looked at 2005 yet, and I'm in no hurry too
<2> like my question is im trying to figure out ways to add relationships using code
<3> where's darken, he's mr. latest-and-gratest-and-I-Know-my-product
<2> im trying to figure out if i should use SSIS or TSQL?
<2> or scripts or c# something
<3> BOL alter table
<3> add constraints
<2> so i should use hand code?
<3> no idea, is it a one off...you doing it all the time...is it part of an app...whats the traffic like on that table
<3> come on, what do you expect here?
<2> like
<2> im tryin to make a management app for my database
<3> you know SQL works just fine...EM does most of its work in SQL
<2> ok
<3> ...and you know, you'll probably be able to change version easier
<3> I've kept my SQL in my apps as simple as possible and found I could change dbms on huge apps in less than a day
<2> or so u dont use alot of the built in tools and features ?
<2> that might be replaced with each version?
<3> exactly
<2> dang so dtl people are in troule?
<3> dtl?
<2> data transformation language
<3> oh no, some people just like to go to the hardware store and buy tools wether they need them or not
<3> you know
<2> ok
<3> some people ahng out in thier garage and talk about all the tools they have on the wall and they so rarely use them...but they LOVE to talk about them
<3> heh
<4> catzai : why do you need a tool of any sort to add relationships to a database? what's wrong with the tools that already exist?
<4> catzai : are you trying to suggest that you're creating new tables during runtime?
<6> is there an insert-update statement in t-sql
<6> so if the record exists it updates with the values give in the insert
<2> naw
<4> Quant : no
<2> like im trying to figure out what kind of design i should use for this database management app
<2> and microsoft just released ssis with sql2005
<4> catzai : why are you writing a database management app?
<2> because we have parrallel databases and i need a way to keep them parallel
<6> replication fool
<4> catzai : that's called replication
<2> replication
<2> ok i need to do replication
<4> ok
<4> so go do replication then
<2> yah but should i just use tsql or ssis?
<4> no
<4> you should use replication
<2> replication is a mssql language?
<2> or wizards?
<6> it's not a language
<4> catzai : no - replication is a concept and a process
<4> catzai : one that you need to read about
<2> yah thats what i thought but how do i implement the concept
<4> see above
<4> catzai : one that you need to read about
<2> tsql, c#, or ssis?
<4> nah - use toffe
<4> oops
<4> toffee
<7> i use watermelon
<2> toffee?
<4> yah - toffee
<4> maybe you need to read about that too
<4> phargle : we're talking about ms-sql2k5, not postgres
<7> oh
<4> for sybase, i'd recommend badger
<2> i dont see anything for toffee
<4> catzai : what about replication?
<2> so there are 3 types of replications?
<2> what type of replication should i use to make sure that one of my databases has the same schema as another?
<2> not the data
<4> you need to replicate *schema*?
<2> yes
<2> sometimes i add columns
<2> that need to be replicated
<4> to do that, you should have a controlled change management process in place
<2> add tables
<4> this is not something you do with replication
<2> oh
<2> thats what i need
<4> this is something you have a dba do in a controlled fashion, once the changes have been tested and signed off
<2> i mean a way to do it automatically
<4> no
<2> i need to make tools for the dba to use
<4> not only is it stupid, it's also wrong
<4> no you don't
<4> the dba's have all the tools they'll ever need already
<2> like the dba hit a button to add columns to all databases
<4> nope
<2> yah well the dba has to log into each database and update each one
<2> without this app i am suppose to make
<4> yes, after the application that uses the databases has been shut down
<2> they want a tool to help them do it
<4> then they're not dba's
<2> they have thousands of databases to maintain
<2> its takin too long
<4> a real dba can write a script to do such a task in 10 minutes
<4> sounds like you don't have real dbas
<4> sounds like you have second-line support muppets trying to manage databases
<2> yah they can
<2> but they dont want to write the script anymore
<2> they want a button to automate the script writing
<4> also sounds like you have a yee-hah approach to development
<2> we do
<2> its extreme agile
<4> there are already tools to do that
Return to
#sql
or
Go to some related
logs:
_currentFrame+ Flash
#beginner
sendmail reject forged
linksys befsr41v4 port configuration
#linux-noob
#red
#c
compaq r3000 will only load window in safe mode
#gamedev
members.mikeinbrazil.com
|
|