| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hahahaha, Fedora?!?!
<0> rmah, welcome to the 21st century :)
<1> thank you... I think
<0> lol
<0> just seeing if you were awake
<0> damnit
<2> who?
<3> is that an owl i hear?
<0> what?
<4> who are you or what are you guys talking about?
<0> yo momma
<4> ah.. no wonder, drhyde^, you were mad excited..
<5> Hello. I've been on the MS site for half an hour now. Can anyone here tell me the difference between the developer and enterprise versions of sql server 2000? Thanks.
<6> ssshhhhh
<6> hello?
<6> anyone awake??
<7> hi guys. i have some queries regarding redundancy. can anyone pls help?
<7> at the moment, i have a microsoft sql server and a iis server running on one system. i want to setup redundancy so that even if any one goes down i can still access the database. can anyone suggest how?
<6> how well do you know mssql and iis?
<8> phoman- : clustering
<6> hey
<6> howzit yuppie
<6> how do I check which sp is on an mssql server?
<6> service pack
<6> SELECT @@VERSION
<9> Anyone know of a good utility for getting statistics on what queries take up the most time (i.e. count * duration)?
<9> I suspect the way to get this is by doing a little string-manip on the results of a profiler and then aggregate it up manually..
<10> Is it ok to ask a generic SQL question - even if it targets MySQL (It shouldn't be MySQL-spesific, afaik)?
<9> the smart ones will just ask the sql question and hope noone asks for the db :)
<10> http://pastebin.com/514348 <-- this query, will return the input "parameter" 'programming' (used as an example) in the output, is it possible to exclude it?
<10> bygons; http://pastebin.com/514349
<11> in mssql triggers, can i get the name of the table the trigger is run for?
<11> i.e., the name of Inserted ?
<9> Macca, you want to have a trigger service multiple tables?
<11> yse
<11> possible>
<9> hmm
<12> yes
<9> but he also needs to know which table :)
<9> inside the trigger, for some reason
<12> eh? missed it i guess
<9> ah
<9> <11> in mssql triggers, can i get the name of the table the trigger is run
<9> for?
<9> <11> i.e., the name of Inserted ?
<12> i don't know, but i already smell bad news by even needing to know that
<13> Inge-: im sure you can by playing with the system tables.. but you define triggers on the table... so why would you need to get the name? you should know the name
<13> sorry i meant macca
<14> Macca: I know of no way to do that.
<15> helo
<15> if i shall make a database
<15> in sql
<15> where did i go
<16> um yeah
<12> pickle flavored hats are good.
<14> Did that make no sense at all?
<14> Or am I just out of it?
<12> blue fruit gone shopping a day.
<17> ...
<18> sql server 2005, CLR, http://sql-servers.com/nopaste/?show=161 . Any help on this recent howtos on this would be great, thanks.
<19> brnchrome: what's the problem... the "SELECT * FROM ml_Lots", which is the only sql-related can't be it?
<18> it doesn't compile, seeing if anyone in here has used Business Intellgince for VS 2005 and SQL Server CLR
<17> brnchrome: is this .net code being run in SQL 2005 as a stored procedure written in .NET?
<17> or is it code calling SQL 2005 ?
<18> its inline sql at the moment, its just a test holder. Once it can run that filthy sql I can move on ;)
<17> brnchrome: how do you figure any of that is "inline sql" ?
<17> "SELECT * FROM ml_Lots" is the only SQL you have ...
<17> the rest is C#
<18> the declaration of "SELECT * FROM ml_Lots" would be inline
<17> brnchrome: your issue is related to .NET, not SQL ...
<17> not finding SqlDataReader is a .NET issue ..
<17> try #c#
<18> the issue is related to business intelligence experience, a .net and sql server issue.
<16> its related to you not understanding how to code
<18> bah
<17> you said your error is "Can not find SqlDataReader" ... that's a compilation error on your side ... related to your C# (.NET) code ...
<17> having absolutely NOTHING to do with SQL Server --at all--
<17> if your code compiled, and the SqlDataReader object returned an error reported by sql server ... THEN ... it would have something to do with SQL or SQL Server ...
<17> it doesn't ...
<17> so goto #C#
<20> hola.. trying to configure a table in a dataset vs2k5 for a sql db.. is it possible to do a select * from table where (@colhead contains @searchterm) type query ?
<20> whoops
<20> should have used like instead of contains
<20> nm
<21> SELECT * FROM table WHERE Colhead LIKE '%searchterm%'
<22> you can't reference columns using variables ...
<16> unless its dynamic sql
<22> CoJoNEsX, yeah
<16> in which case everything is different and everything ****s
<21> i've never looked into dynamic sql.. is dynamic sql a buzzword like ajax or is it some sort of standard from our friends and microsoft?
<16> neither
<21> do you have any references to some literature or websites with a pretty complete overview of dynamic sql?
<16> google?
<16> !google "dynamic sql" example
<23> http://www.google.com/search?q="dynamic+sql"+example
<23> !google: ("dynamic+sql"+example) hyrrrghhhh
<22> omfg, VS2k5 C# Express ... ****S
<24> dynamic sql in 21 days
<22> I have a variable 'p' ...
<16> yay! hyrrrghhhh
<22> and whenever I try to ****ing use it, the editor's crappy *** intellisense puts 'prop' in it's place
<16> one day I need to edit that evil tcl
<21> lol
<20> hmmm... i wonder how i would make the colname dynamic in the vs2k5 dataset query
<20> bah, guess i'll just select case and create multiple queries
<20> thanks
<25> in SQL2000 you can use case/when in an order by clause
<25> I never even thought about it till I needed to one day to sort soemthing by ascii date strings and actually needed to...tried it and it worked
<22> select * from tbl where case @colname when 'c' then c when 'd' then d when 'e' then e else a end = @colvalue;
<22> works for simple small tables, with few columns to match against, otherwise, it gets fairly cumbersome fairly quickly ...
<20> is there a method to get the id of the last inserted record?
<16> what rdbms?
<20> sorry sql
<14> ...
<16> *sigh*
<16> @rdbms
<16> @ rdbms
<23> rdbms = name your rdbms, you know oracle, sql server, postgres.. some sql code is specific to a particular database and we cant help you if you dont tell us
<20> sql server 2005
<16> have you even attempted to google this?
<16> http://www.google.com/search?complete=1&hl=en&q=last+inserted+record+sql+server
<20> CoJoNEsX: thank you.
<20> christ im tired today.. no excuse for being a sped, I know better
<23>
<23> Warning: fopen(http://tinyurl.com/create.php?url=http://www.google.com/search?complete=1&hl=en&q=last+inserted+record+sql+server): failed to open stream: HTTP request failed! in /home/himmler/egg/myscripts/tinyurl.php on line 21
<23> http://www.google.com/search?complete=1&hl=en&q=last+inserted+record+sql+server is invalid or something is broken
<16> yay! timeouts
<26> samlander, if you haven't found it, iirc it's @@identity or something similar.
<3> have any of you seen a udf for sql that converts numbers to text? i really don't feel like writing one :P
<3> and, by numbers to text i mean 1 = 'One' 32767 = "thirty two thousand seven hundred sixty seven" etc
<3> ah, found one
<3> this stupid old app actually had a table w/ 200k records in it
<3> with a column for the numeric and a column for the textual
<3> and i so didn't want to have to keep using this stupid table
<27> which function did u find?
<3> this; http://www.1phpstreet.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!712/lngWid!5/anyname.htm
<3> this site has a few, different spoken langauges and such
<3> udf / sp versions.. for whatever reason
<27> that would of been a bitch to code
<3> easy but tedious
<27> i hate coding like that
<3> not sure if I would have coded up to "quattuordecillion" :P
<27> it's like walking to get across the country
<27> he was just being fancy there :)
<3> hehe
<28> If i create a stored procedure from sql script (CREATE PROCEDURE SP_NAME ( @USE ) ETC..) And i want to create a few 1 after the other and execute on the db, do i need to put GO between each "CREATE" stored procedure to make it work?
<3> yea
<3> the error message you'd get is more specific
<3> in that it will say that create procedure needds to be first
<28> but if i write create procedure sp_firstProcedure1
Return to
#sql
or
Go to some related
logs:
#computers
#beginner
#linux-noob
#slackware
#winxp
how can i make material in 3ds max like in cars from pixar
#windows
www.meineex.dl.am.de
fidele kato pink panther
russian mob in florida
|
|