|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Computer Vitals Posted by my.chat.friends NO[at]SPAM gmail.com at 9/16/2006 8:42:51 PM http://computervitals.com
Hey guyz,
I welcome you yo Computer Vitals, Your Online Computer Helpline. A new
venture to help people with all sides of software and hardware. Pay a
visit and experience yourself. Lets get together and help eachother.
http://computervitals.com
Help sections in...more >>
add a new user to SQL Posted by Aussie Rules at 9/16/2006 8:04:07 PM Hi,
I want my client application to be able to create new SQL users, however
this seems to be a function only the SA can perform.
There there some sort of permission or role that I can have a user be apart
of that will have the perms to do this ?
...more >>
splitting up a string into seperate values Posted by Aussie Rules at 9/16/2006 8:02:19 PM Hi,
To save numerous round trips between the server and client, I want to pass
in a string that contains a number of values, that the store proc will split
up into the single values and insert into a table.
For example, the client will execute the following
exec sp_addfavstoCustomer
1...more >>
sqlexpress ques Posted by rodchar at 9/16/2006 6:16:01 PM hey all,
is there an administration tool for sqlexpress that i can do an
import/export, backup/restore against SQL Server 2000 databases?
thanks,
rodchar...more >>
SQL sumproduct Posted by Stopher at 9/16/2006 4:06:12 PM Hi All,
Posted a thread about this a while back, but the thread went pretty
dead.
Please find below a copy of my code so far:
create table #provtable1 (
Shipment varchar(50),
MLT varchar(50),
Arrival varchar(50),
Depart varchar(50),
ShipName varchar(50),
Port varchar(50),
WMT float...more >>
how do this Posted by Tarvirdi at 9/16/2006 3:25:34 PM how can I do this :
declare @i int
declare @s char(10)
set @s=3D'select @i =3Dmax('+@var+') from atable where '+ @Cond
exec (@s)
no connection between to pass @i.
How can I set out of string defined in string
Thanks...more >>
Total Multiple columns Posted by antgoodlife at 9/16/2006 10:02:48 AM I have a table like so
Inventory :
Name State Gender
Anthony NJ M
Joe NJ M
Frank GA M
Steve CA M
Jane CA F
Alice MA F
George TX F
I'd like the result table to look likethe following (Showing different
totals like so)
State Male Female
NJ 2 0
GA 1 0
CA 1 1
MA 0 1
TX 0 1
...more >>
Table with Foriegn and running total Posted by webmaster NO[at]SPAM 1stmiami.com at 9/16/2006 8:33:40 AM sql server noob here. class Relational DB question - I wanted to see
if my thinking is right and bounce this very simple design question off
you guys.. In particular using ASP.NET as the client and wanted to know
if I should address this on the db side or the client/business layer
side.
3 ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Separate data and log files for system DB's Posted by David at 9/16/2006 7:33:02 AM Hello again,
I have a production server where all the data and log files are residing on
a single drive. I would like to separate the data and transaction log files
to separate disk.
I tried to move master files using "RESTORE" command using MOVE statements
(changing server to single u...more >>
Error Msg 3628 : A floating point exception occurred in user process Posted by at_miaposta NO[at]SPAM yahoo.it at 9/16/2006 6:44:52 AM We have installed SQL SERVER 2000 on a new server DELL with 4 processor
and 8 GB RAM.
The OS is Windows Server x64 given the needs to use the multiprocessor.
We have updated SQL Server to the SP4 before to start the work.
The same program without any changement is working well under W.Server
...more >>
dataereader closed on return from executereader. Posted by Jes Samsøe at 9/16/2006 3:46:01 AM I have a situation where after excuting the following statement
'reader = cmd.ExecuteReader(CommandBehavior.SingleRow)'
the reader is closed - so when i try the following:
if reader.hasrows() then
..
..
etc
I get an exception telling me that the operation (.hasrows) is not allowed
...more >>
merge two select statement Posted by magix at 9/16/2006 12:00:00 AM Hi,
select myid, myname, count(*) as mytotal from tblA
group by myid, myname
myid myname mytotal
==== ====== =======
111 test1 10
222 test2 20
333 test3 30
select myid, myname, count(*) as mySubtotal from tblA
where Subid1...more >>
***how to find what has happened?* Posted by M at 9/16/2006 12:00:00 AM Hi
In SQL2000, how can I find what has happened in my DB in particular date?
for example I insert a ne row in table1 and I update 2 rows in table2. now
how can find what did I perfome?
I don't want to monitor the changes simentanously, I want to refer to them
afre some times.
should I re...more >>
merge two select statement Posted by magix at 9/16/2006 12:00:00 AM Hi,
select myid, myname, count(*) as mytotal from tblA
group by myid, myname
myid myname mytotal
==== ====== =======
111 test1 10
222 test2 20
333 test3 30
select myid, myname, count(*) as mySubtotal from tblA
where Subid1...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |