| |
| |
| |
|
Page: 1 2
Comments:
Naresh: how to convert nvarchar to smalldatatime
in sql server 2000
<0> In SQL 2000, how can I define that the primary key should auto increment by 2? (So the first customer gets ID "1" and the second gets "3" etc.)
<0> Can this be done easily using Enterprise Manager?
<1> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp
<2> JMO: Seed of 1, Increment of 2
<0> Thanks both of you!
<3> Can i somehow SUM everything that is in an amount of colums?
<3> CustomersToday contains 10 and CustomersYesterday contains 20, i want to sum the two of them so the result is 30 :)
<4> hey
<4> QuoteRS.Open "SELECT * FROM quotes WHERE quote LIKE '%" & Replace(Request.Form("keywords"), " ", "%") & "%' ", oConn, 3
<4> whats wrong with this line?
<4> Im getting the error Expected end of statement
<4> but its all seemed to be closed
<5> that its totally insecure
<4> ?
<1> upd: Its not even worth trying. Trust me.
<5> hehe
<4> anyone?
<6> roomba ftw
<7> hi, whats the use of backing up log_file using msde. thanks.
<8> heyaz
<9> hey Quanty
<10> k.. i have a question: it may be a bit difficult to explain but here goes..
<10> im using access. i have a table where each record has a value and a date. i need to select the average of all values greater than a certain number grouped by date, or zero if there are no such values on that date
<10> any ideas?
<10> nobody?
<11> hi guys: mssql. Is it possible to get a history of the latest sql statements that where executed by sql server ?
<12> no
<8> ****az
<8> unless you had a profiler running
<11> Quant, how do i start a profiler ?
<11> and will this cover triggers which start stored procedures ?
<8> i think so
<8> it's an app that comes with sql server
<8> look in your start->programz
<11> cool :)
<11> I'm gonna debug a pretty complicated 8 page stored procedure which is fired eventually 3 steps down in trigger calls trigger calls trigger setup :)
<11> lets see if that thing can help me out a bit
<8> wow sounds like anal beeds
<11> err
<11> dunnow
<11> do you like anal beeds ?
<11> I think it sounds like a though job :P
<8> lol gluck
<8> ....with the beeds
<11> hehe thx :)
<13> hello
<13> i have 2 entities (one is customer information and the other is customer modem). I am thinking of having one table instead of 2 tables and then create a view for customer information and the other for customer modem)
<14> hey all! Anyone know if its possible to have two control sources in an access report (that is to say two fields in one label)?
<15> It is possible
<14> FF4F: was that directed to me?
<14> should I re-word the question?
<15> No need to re word it i am a german ***hole my english ****s
<15> but its possible and i cant tell you how
<15> :D
<14> heh!ahhhhh
<11> MattyT, if I'm not mistaking you can probably do that using VBA.
<15> VBA is one way right that
<16> anyone know if postgres runs on *nix only or is there a port for windows?
<11> there is a windows version
<11> v8 only though
<17> postgres is an oo db ?
<14> mkroon: yeah - probably. but I cant be arsed at this stage to be doing it in vba. Also I hate doing vba in reports :(
<14> although I need something else - so now I'm guessing that I will have to use vba :'(
<11> mod_tom, no
<17> k.
<13> hello
<11> oi :)
<13> NyQuil :wazzup
<11> yeay fixed the bugger :)
<18> hi
<18> I'm in mssql, and learning stored procedures... I know a stored procedure can use parameters, and default values, can I use an if inside a stored procedure to check if a parameter was p***ed?
<18> uhm, soryr
<18> sorry
<18> found it in msdn
<18> disregard
<19> Hm in access is there a way to specify query parameters in when refering to a query from SQL?
<18> yes
<18> I think so... I'm not sure if you are asking what I think you are asking
<18> do you want the syntax for parameters in sql view?
<20> IS anyone familiar with crystal reports?
<20> I have an SQL Server DB, and I am looking at a purchase order and a purchase order item table. It's a one to many relationship. I want to select all purchase orders that have at least one item that is raw material (ie: itemkey like 'RM%') so I perform that subquery and do a query on the purchase order table where the PONo is in that subquery.
<20> However, I cannot find how to do this in Crystal Reports.
<20> There is no "in" clause. Nor can I even seem to add a subquery.
<21> need some sql-help,i got this: select * from poi where zipcode in (select zipcode from city),the problem is, in city.zipcode there are sometimes more than one zipcode in the zipcode field, like this: '12345,12346,12347'
<21> using mssql
<21> dont know how or if i can use the like statement here
<11> I think that might work :)
<11> or do you only want to retrieve one record ?
<11> in that case you will probably have to do some string manipulation in sql server
<22> people in my office are so talkative ...
<23> by "office" you mean "head" ?
<22> "head" ... as in ...
<22> it's too early for stupid jokes
<24> off topic but wondering if anyone in here ever telnets or logs into remote servers///im specifically trying to figoure out how to zip/package a bunch of files before downloading them
<23> w***a - there are scriptable zip programs as well as scriptable FTP programs - heck you could write the whole thing in python.
<25> http://pastebin.com/519152
<22> bleh
<26> hey
<26> diont supose if anyone can tell me if server management studio is actually officially release yet?
<22> Babbage: I think microsoft.com can answer that question for you
<26> M$ doesnt tend to give differences between shop/developer/academia/etc. release times
<26> ahh well cheers anyway
<22> can .NET DLL's be used by VB6?
<27> yep, com interop
<27> gotta set them up for it
<22> k
<27> moz: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondeployingapplicationforcomaccess.asp
<27> lots of links and info
<28> "DECLARE @PTAAI nvarchar(128); EXEC dbo.sp_get_ptaai @PTAAI OUTPUT; SELECT @PTAAI;");
<28> whats "@PTAAI " refer to? this is mssql.
<27> that's not a built in sp
<27> if that's what you are asking
<28> just wondering what that is
<29> you would probably have to read the stored procedure
<22> chamois: it's custom to your db ... so we wouldn't know what it means
<22> all we can tell you is what you can figure out on your own
<22> it's a variable, it's of type nvarchar(128) and it's p***ed to a stored procedure as an output parameter ... then 'selected' or 'printed' to the screen/output stream
<29> if you need help understanding the proc paste it into the pastebin
<13> hello
<22> goodbye
<13> I would like to know if it is wise and efficient to have an application that swant to store data temporarily create a table in a database then after that copies the contents of the created table in an existing table and the deletes the created table
<27> why would you do that?
<18> ? paste
<13> i want the user to review their data before saving it to the database
<27> so have them review it...that's up to your application, not a temp table
<18> what's wrong with this?
<18> http://sql-servers.com/nopaste/?show=165
<18> sql server says I have to declare the table variable
<18> @nombre
<22> Purple-: there are numerous valid raesons to import into a temp table ...
<27> moz: sure...but what he/she described is not one
<22> Purple-: thats the basic concept of any valid reason
<22> you import to a temp table, m***age the data, then move it into the physical table
<22> he just didn't mention the m***aging process ...
<22> which may or may not be there ... hehe, we've both been in here long enough to know everyone omits the 'important' stuff when asking questions ;)
<27> well...if the user is reviewing it in an application, no reason to ever push to the db until the data has been m***aged/finalized
<22> correct
<22> if the app is written in .net ... which I'm ***uming it is ...
<27> then it'll all just sit in the dataset until final
<22> you just use a Table object, which is the same as a temp table in SQL Server ... do your review/m***age ... then stream the data to sql server
<18> anyone can help me with the creation of that stored procedure in microsoft sql server the syntax is: http://sql-servers.com/nopaste/?show=165
<18> the syntax is the problem
<1> Milkk: You probably mean "is not null"
<30> on MS sqlserver 2003: as part of a where clause I have a datetime field containing dates with no times (e.g. 1/23/2006) that I compare to GETDATE(). I want those rows where the date in my datetime field is today or later, but it is giving me tomorrow or later. I'm guessing that GETDATE() returns the date + time of the moment it is called, which would test greater than 1/23/2006 (I ***ume the full date time value of this is 1/23/2006 12:00 AM). Now finally
<31> I think you need to floor getdate
<30> clever! let me try.
<30> CoJoNEs: It worked beautifully! GETDATE() became -> CONVERT(DateTime, FLOOR(CONVERT(float, GETDATE()))) and it now works perfectly.
<30> thanks!
<30> CoJoNEsX: ^^
<32> any ideas how i could make a query that if a join is made to update the data and if not insert the record.. and to do this on not just one record but an entire table
Return to
#sql
or
Go to some related
logs:
psucalc
lightspeed teennetwork
#windows
#computers
#politics
#stocks
#ubuntu
#delphi
Mp3Q8.Org
#solaris
|
|