| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> why don't you look up the name of it :)
<1> i want the first column of t2, it is the identity column....but i dont know the name of it, as it is a temp table
<0> it's going to have the name of the column you inserted into it, won't it?
<0> or you can use a create statement and define your columns
<0> easier to read
<2> you can specify column names in your select statement and the resulting table will use them in a select into scenario
<2> select t2.1 theidcolumnidontknowthenameof, t2.userid ...
<3> good evening fellas
<3> I'm looking to buy an Online Web Based application that is run in a web browser that can do the following. 1. Sync between two websites (test&production) 2. Provide online website backup and restore via web browser. Should be able to restore from previous days backup. Any body got any ideas?
<4> yes
<3> Lyle what do you think?
<5> rsync ?
<5> and what does this have to do with sql?
<4> rsync with a custom web interface would do it
<4> we just use xcopy
<0> heh
<3> What about to back up and restore ?
<3> Via web browser? anything?
<5> backup and restore what?
<5> files? a database?
<3> everything
<3> the whole site
<3> We got some non-technical people that want to edit the site
<3> so lets sy they fu*k it up is there some sort of php app or some sort that is web based thatthey can click on an drestore to original code?
<6> Storing the entire site in a DB?
<5> depends on what you build it in and how its stored
<5> hahah, dear god I hope not Halo_Four
<7> why not? we do ;)
<6> Neither do I, but unless he is it's not within the scope of discussion for this channel.
<5> what are they allowed to edit? where is that stuff stored? do they change code? or just data?
<8> How about you just put the entire site in source control.
<8> Like, everybody else.
<3> they're changing data
<6> I prefer the "you break it you bought it" approach
<3> Editing articles pretty much
<3> The site is stored on a local server
<5> well then either write the site so it verson controls the data
<5> or make a backup of the db on a regular basis
<3> For example we got Absolute
<3> and some of our top employee's have access to that
<3> So i'm wondering if there is some sort of software as simple as Absolute to do this
<8> Buh. This SQL profiler thing ignores strings with the text 'P***word' in it.
<8> I need to turn that off.
<9> is there a way of sending a param value to a dts?
<9> sql server 2000
<2> rumor is, yes.
<10> is there an SP or similar that would return all tables within an MSSQL db along with their respective rowcounts?
<10> MSSQL 2000
<11> Hey, How can i Query so i get all the Max and Minimum point pints of a specific list of values ?
<11> Points^
<10> Select max(blah) as themax, min(blah) as the min
<11> but that will give me 1 Maximum ...
<11> i want the second high and 3ed high too
<11> 100,120,160,200,100,150,0 will return 200 and 150 as max points...
<11> got tangled up with that ..
<11> :(
<6> ORDER BY
<12> http://sql-servers.com/nopaste/?show=747
<12> I'd really really really like to be able to combine these queries into one.
<12> using Access
<12> Or maybe Jet 4.0 is more accurate?
<9> does sql server 2000 has this getdate format YYYYMMDD ?
<13> Disabuse:: 112
<12> anyways, I have one table with a table with a questions, and then a table with answers. For each question, if like to pair with the percentage of times the question was answered right. Currently, I'm taking the "question_id" and the "answer_id" from the Questions table, then doing a seperate query counting the amount of times this question has been answered, and another for how many times it has been answered correctly.
<12> then i'm turning that into a percentage, but all the latter part is done with a second function...
<9> thx d2d
<13> np now move along~
<1> hey guys, im trying to insert a record into a table and then insert the PrimaryKey of that record into another table
<1> i cant use a trigger, as this will be done in a sproc
<1> and the PK is of type uniqueidentifier
<1> basically i have:
<1> table1 with columns: col1[int] col2[int] col3[int]
<1> talbe2 with columns: col1[uniqueident] col2[int]
<1> table3 with columsn: col1[uniqueident] col2[int]
<1> i want to put table1.col2 into table2.col2
<1> and then put table1.col3 into table3.col2 AND table2.col1 into table3.col1
<14> I know this isnt SQL Related, but does anyone know of a channel on IRC that helps with Visual Basic 2005? I am trying to connect to a remote SQL Server 2005 database in my application.
<15> i want to limit the size of an SQL db
<15> and auto truncate old info
<5> aHighYn what kind of sql db?
<15> MSSQL
<5> I think you need to setup a backup plan
<15> k
<15> done
<5> ok, congrats
<10> heh
<10> CoJoNEsXx, any idea how to iterate through each table within an MSSQL 2000 db and display that table's dependancies? I know you can use SP_depend, im just wondering if you can think of a way to step through each one?
<5> if I knew the mssql tables I could probably answer that. ive done it in oracle before
<5> pretty much a loop in a loop in a loop..
<10> im thinking of manipulating this guys sample - http://www.databasejournal.com/scripts/article.php/3376261
<16> information_schema.tables
<10> is that an SP ?
<10> nope
<10> what do you mean Drk`Angel?
<16> Its a table, that has a list of all tables in it. Use it to feed the sp in a loop.
<5> I like tables.
<16> Or, if you want to do it all in one query, join tables, constraints, and constrain_columns
<16> And build the list yourself
<17> I like ponies.
<16> EyePulp: Yeah, it feels like I just answered this question yesterday.
<16> Must be homework somewhere. :p
<10> heh.. i wish i was in school right now... EAAAAAAsy street
<18> how do i prevent an INSERT in a trigger?
<5> uh
<19> How do I get the length of the LONGEST value of "Name" in table "nanos"? Some kind of character count to find out the length of the longest "Name" entry?
<16> throw an exception in the trigger? raise an error. What ever works for your db.
<16> conjure1: Looking up stirng functions in your documentation would be a great place to start.
<5> conjure1 select max(length(field)) from table
<19> Thanks to both of you! :)
<6> prevent an INSERT in a trigger? Rollback the transaction.
<10> can someone give me some advice to this? I think I'm pretty close. http://sql-servers.com/nopaste/?show=748
<10> guess thats a no
<5> cant you call a procedure from a procedure/
<9> Halo_Four or anyone who wants to answer this ;) , anyways i created a dts and i want the output of the file to have no deilimiter whatssoever but there is no option to do so, any ideas?
<10> i thought that sample was running a loop?
<9> output of the table to the file i mean
<2> there is a choice of delimeter there
<2> somewhere, i forget off the top of my head. but its there
Return to
#sql
or
Go to some related
logs:
#politics
#politics
#opengl
#computers
#debian
#politics
#stocks
#worldcup
#delphi
#unixhelp
|
|