| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> getting .net 1.1 and 2.0 on the same machine is a bitch ...
<1> It is?
<0> keep getting a "before you can install Tools or Samples the .NET 1.1 framework must be installed."
<1> I've got 1.0, 1.1 and 2.0 on this machine
<0> FROM THE 1.1 INSTALLER!
<0> and I'm installing the SDK's ... not the run-times
<0> but I think I goofed ... I installed vs2k5 first ... on a freshly installed XP SP2 box
<0> thne tried to put 1.1 SDK on the machine too ... so I can work with the Mono/Tao/SdlDotNet libraries
<0> omfg ... that's ****ing retarded ...
<0> the 1.1 sdk doesn't come with the 1.1 redistributeable ...
<0> so the installer was bombing because I didn't have the 1.1 runtimes installed
<0> and since when does XP not come with 1.0 and 1.1 redist's?
<1> XP never shipped with them
<0> coulda sworn it did ... *shrug*
<2> is it safe to do a shrink on tempdb?
<0> only if no one is using the rest of the server, I would pressume ...
<0> tempdb is used for alot of things ...
<3> i keep things there temporarily, like when i go on vacation and stuff
<0> oddities aside, sql server uses it all the time ;)
<4> Is it me or they nuked the 'Open Table' option from the context menu in SQL Server 2005 diagrams?
<2> safest way to do it is to reboot the server.... nice.
<3> lol xp is so older than .net
<1> About six months or so.
<5> Halo_Four: so if xp is nt 5.1 what does that make vista?
<1> I think it's supposed to be 6.0
<1> or 5.3
<1> I'm not sure if Vista is getting a major version designation.
<1> Bill forgot to call me and ask :P
<4> SQL Management Studio is a huge pile of ****. heh
<5> Shakkan: nah
<5> Shakkan: it does the job
<1> open table still exists in management studio
<4> so did Enterprise Manager/Query Analyzer
<4> but with less bloat.
<4> Halo_Four: from the diagram?
<1> a relationship diagram?
<4> yes
<1> beats me, but I know if exists if you right click a table in the object browser
<4> you could right-click on a table and select 'Open Table' in Enterprise Manager.
<4> yes, that i know.
<3> they did change it so it just starts loading the table data right away, instead of sql2k em asking you for how many rows
<3> i never use it, but i can see how that would be an annoyance
<4> awful. and to think they had removed diagram support at one point.. :\
<1> Doesn't it have a second option to select top x
<3> and you can't go right to a query... but **** anyone who writes queries in sql-em
<4> yeah.. query analyzer for that all the way.
<1> Scriptability in MS is excellent, tho.
<1> Pretty much every single dialog to modify something has a button to script those changes.
<5> im pretty impressed with the sql interface in vs
<5> makes me beat my head against a wall everytime i think i used to use mysql
<6> hey
<6> anybody know howto convert hex codes for special characters into actual letters in mssql stored procedures?
<7> if I want to draw data from say 3 tables
<7> how can I do that ?
<7> SendSQL("SELECT po.id, po.name, po.description, count(test_runs.test_run_id) ".
<7> "FROM products po LEFT JOIN test_runs ".
<7> is what I have at the moment
<7> but say I want to draw also from a third table
<7> how can you join multiple tables?
<8> at another left join
<8> add another*
<7> ok
<8> but you might want to read up on joins doesn't seems like your using them correctly
<7> "FROM products po LEFT JOIN test_runs LEFT JOIN test_plans ".
<7> ?
<7> doesnt seem to work
<8> http://www.w3schools.com/sql/sql_join.asp
<7> kk, thanks
<9> I'm getting this error with MSSQL 2000
<9> UPDATE failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'.
<9> My query is UPDATE Table
<9> UPDATE Table SET Column=NULL WHERE CustomerID=2002
<9> I can change concat_null_yields_null, but i don't understand why that effects this query
<1> Sounds like the table has an indexed computed column or is referenced in an indexed/materialized view. You have to ensure that your session settings match those necessary for that indexing to calculate appropriately or the server will not permit DML statements.
<1> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_1ng3.asp
<9> Halo_Four: You there?
<9> I think my problem with the SET option error has to do with me creating indexes through query analyzer instead of enterprise manager when I had wierd set options set, does that sound right?
<10> good morning... does anyone know how to mask a stored procedure variable when running via ms access... using MSSQL 2000
<10> parameter rather
<11> is there a good way to trim out leading 0:s in a char field?
<11> mssql
<10> ltrim
<12> that won't remove "0"
<10> you could cast as numeric
<11> it contains letters too
<11> ltrim wont work if the amont of 0 differ
<10> well that ****s... is it a specifi number of zeros.
<10> ?
<11> no
<10> how many rows
<11> i can be 000XXX, 00XX for example
<11> many
<11> i guess ltrim works in oracle but not in mssql
<10> this is a dog**** method but might work... export the rows and key to cvs, open in excel, run a multiply special command of 1 on the entire column, update into the column via the key
<13> Cletus : is this a one-off requirement?
<11> nope.i will be a part of a daily dts
<10> eeessh
<13> then write a function in vba to do it
<11> best solution?..there isnt a t-sql cmd for it?
<13> no
<10> YuppieScm.. yer a smart guy... how do i run a stored procedure in access whereby instead of it aking for the literal parameter name, i could use a phrase or friendly question
<13> the idea with sql is that generally you put the right data into the database to begin with
<10> aking = asking
<13> `osi : ms-access doesn't do stred procedures
<13> s/stred/stored
<10> ADP files do
<10> its a front end access client to work direct within SQL.. its actully pretty cool
<2> adp, the payroll company?
<13> `osi : so, you're using ms-access to call a stored proc in..? ms-sql? sybase?
<10> nono.. inseat of .mdb extension, its called .asp
<10> MS-SQL
<10> its quite f-ing cool acutally
<10> .adp
<10> not asp
<13> `osi : so write some vba code to do it
<10> from within access, i can write a SQL compliant query or SP direct to MSSQL
<10> http://office.microsoft.com/en-us/***istance/HP052578461033.aspx
<10> uhoh...it looks like it is only suported in access 2003 versions
<13> what is?
<14> anyone familiar with pervasive sql?
<10> this access project thing
<15> in mssql, i want to delete a row which has n:n in another table
<16> why not p:z
<15> so i need to delete from the link table and the "other" table at the same time
<16> you can use cascading
<15> great thanks
<15> i forgot about that; i think i used a trigger in the past but that ****ed
<17> You could also use a transaction to package it all together too.
<17> Whatever floats your boat.
<16> Drk`Angel not having holes in my floating device floats my boat
<10> anyone know if you can brace parameters in MS SQL? ie create Proc Blah [@start date] datetime [@end date] datetime
<15> why?
<16> osi
<10> when i run the sp within access it does a msgbox return asking for the variable to run....for the sake of the end user, it would be nice to be able to add grammer
<10> grammar
<16> why don't you try it and find out
<16> there are only 2 possible outcomes
<10> i did
<10> it didn't.. but im wondering if someone has done it a different way
<17> Doesn't access have access basic or something? Write a little script that asks for the parameters then p***wed them to the proc.
<0> ok, sql2k5 ****s ...
<0> trying to create a stored procedure ... and it's error message is "error near ')'" ... with no line number or anything ...
<0> I have like 50 ')' in my proc ...
<0> using the vs2k5 database explorer, with sql express ..
<0> and is there any way to turn off the stupid query selection box? all my sql statements have a blue line surrounding them, very confusing to look at ...
<18> anyone has a clue why: rs.Open "SELECT JobsList.* FROM JobsList WHERE JobsList.Date_Order='3/1/2006';", conn
<18> returns: Data type mismatch in criteria expression. ?
<10> 'balkbjalkbj' equals text not date
<18> for some reason, when I remote the WHERE part it works fine, I don't see anything wrong with that part
<18> oh
Return to
#sql
or
Go to some related
logs:
#politics
school voucers
#flash
#beginner
mailthru mail forwarding
succer injuries
#ubuntu
how do you babysit a nigglet?
#solaris
#firebird
|
|