|
|
|
January 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 |
win 2003 server Posted by jansi at 3/3/2008 12:12:17 AM how many user create in win 2003 server?
From http://www.developmentnow.com/g/95_2004_7_1_0_0/comp-databases-ms-sqlserver.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com...more >>
Re: How do I link a database in SQL Posted by Erland Sommarskog at 10/14/2007 12:00:00 AM (rzito@si.rr.com) writes:
> I am working on a databse on my local box, my source data is on
> another. How can I link the database and table from one server to
> another? Currently I am using DTS to just transfer the records!
You can set up a linked server. If the stars align, it's as simple...more >>
Re: Query Variables Posted by Erland Sommarskog at 10/13/2007 10:16:45 PM Yota (yotaxp@gmail.com) writes:
> I'm new to SQL Server, but an experienced .Net developer. I'm trying
> to accomplish a query the most efficient way possible. My question is
> if you can define a temporary variable within a query to store tables
> or fields. (Like the LET clause of LINQ) My ...more >>
Query Variables Posted by Yota at 10/13/2007 10:01:23 PM Hi,
I'm new to SQL Server, but an experienced .Net developer. I'm trying
to accomplish a query the most efficient way possible. My question is
if you can define a temporary variable within a query to store tables
or fields. (Like the LET clause of LINQ) My query makes use of
subqueries whi...more >>
Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai Posted by dbaguru at 10/13/2007 9:19:45 PM Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai
1. Citrix Admins - Noida - Chennai [L2/L3 Support]
2. Sun Solaris Admins - Noida - Chennai - Mumbai [L2/L3 Support]
3. HP Unix Admins [Chennai] / IBM AIX Admins [Chennai & Mumbai]
4. Linux Admin [L2/L3 Support] - NCR & Chennai
5. Oracle DBA...more >>
How do I link a database in SQL Posted by rzito NO[at]SPAM si.rr.com at 10/13/2007 9:12:45 PM I am working on a databse on my local box, my source data is on
another. How can I link the database and table from one server to
another? Currently I am using DTS to just transfer the records!
...more >>
Re: Speed Issues After SQL Upgrade Posted by Ed Murphy at 10/13/2007 8:30:35 PM Side note: When posting the same thing to multiple newsgroups,
please crosspost (to all of them in a single step) rather than
multi-posting (to each of them individually). I responded to
this in another group before reading in this one that you'd
already resolved the issue....more >>
Re: Would special character cause insertion problem? Posted by Erland Sommarskog at 10/13/2007 4:56:53 PM (tatata9999@gmail.com) writes:
> I'm not sure I follow you this time.
And I am not sure that I am following you. You post some loose bits of
code that I don't really know what language it is. In the middle of at
you get an SQL error:
Violation of PRIMARY KEY constraint 'PK__myTBL__772...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Re: Indexed View Crashes ASP.NET App Posted by Erland Sommarskog at 10/13/2007 3:18:13 PM Jason Wilson (wilsonj@ausrad.com) writes:
> I was looking to improve the performance of an ASP.NET application by
> creating the an indexed view that could be used instead of some of the
> root tables.
>
> What I didn't realize is that it would affect any future conenctions
> to the root tabl...more >>
Re: Speed Issues After SQL Upgrade Posted by Erland Sommarskog at 10/13/2007 3:11:07 PM Ben (pillars4@sbcglobal.net) writes:
> We recently upgraded our MS SQL Server 2000 to 2005.
>
> Here is what we did:
>
> 1. Perform backup of the database from the old server.
> 2. Created a blank database in the new server.
> 3. Restored the database into the blank database located in the ...more >>
Re: Speed Issues After SQL Upgrade Posted by Ben at 10/13/2007 1:07:46 PM The sp_updatestats did the trick. Now the speed as it should be.
Thanks.
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99C8AFB6246FYazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> We recently upgraded our MS SQL Server 2000 to 2005.
>>
>> Here is w...more >>
Re: Would special character cause insertion problem? Posted by tatata9999 NO[at]SPAM gmail.com at 10/13/2007 11:05:53 AM On Oct 13, 11:56 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (tatata9...@gmail.com) writes:
> > I'm not sure I follow you this time.
>
> And I am not sure that I am following you. You post some loose bits of
> code that I don't really know what language it is. In the middle of at
...more >>
Re: Speed Issues After SQL Upgrade Posted by Greg D. Moore (Strider) at 10/13/2007 9:39:39 AM
"Ben" <pillars4@sbcglobal.net> wrote in message
news:T%RPi.1672$LD2.1355@newssvr17.news.prodigy.net...
> The hardware configuration below:
>
> - Has two Intel Quad-Core Xeon processors
> - 10GB of RAM
> - 15,000RPM SATA hard drives
>
> The old server was just a regular P4, 4G RAM.
>
...more >>
Re: get value of a single record instead of aggregated value with GROUP BY Posted by Erland Sommarskog at 10/12/2007 9:21:12 PM blackpuppy (mingzhu.z@gmail.com) writes:
> I would like to use the following SQL statement to get the latest
> comment for all products.
>
> SELECT PRODUCT_ID, COMMENT, UPDATED_ON
> FROM PRODUCT_COMMENT
> GROUP BY PRODUCT_ID
> HAVING UPDATED_ON = MAX(UPDATED_ON)
>
> But this leads to...more >>
Re: Would special character cause insertion problem? Posted by Erland Sommarskog at 10/12/2007 9:16:19 PM (tatata9999@gmail.com) writes:
> Very simple sql dml code (all the columns are of varchar of various
> length):
> insert into myTBL (col1,col2,col3)
> values ('#ranVar#','#FORM.element1#','#FORM.element2#')
>
> The err msg is:
> Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3...more >>
Re: how to query for a column value that contains dashes Posted by MC at 10/12/2007 7:56:29 PM Something like this (untested, but you see the point):
select <col list>
from profile
where msgdate >= @date and msgdate < dateadd(dd,1,@date)
date would be a parameter...
MC
<jdrake@living-dead.net> wrote in message
news:1192208492.248548.49030@e34g2000pro.googlegroups.com...
> H...more >>
Re: how to query for a column value that contains dashes Posted by Roy Harvey (SQL Server MVP) at 10/12/2007 5:56:08 PM What exactly is the data type of the column msgdate? You mention it
is a 'datetime' column. If it is the datatype of datetime then forget
about strings, it is stored internally as a couple of numbers. With a
non-zero time the standard way to test for a specific date is:
WHERE msgdate >= '2...more >>
Re: Would special character cause insertion problem? Posted by Jack Vamvas at 10/12/2007 5:01:20 PM Could you post your stored procedure or code?
Are you able to get an output of the sql string that will be used, the one
that throws the error.
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
<tatata999...more >>
Re: Would special character cause insertion problem? Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 4:34:59 PM Sorry for security reason, I have to remove the previous post and
repost it with revision.
The err msg is:
Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3EFCA'. Cannot
insert duplicate key in object 'myTBL'.<P><P>
SQL = "insert into myTBL (col1,col2,col3) values
('342*783'...more >>
Re: Would special character cause insertion problem? Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 4:32:00 PM On Oct 12, 4:16 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (tatata9...@gmail.com) writes:
> > Very simple sql dml code (all the columns are of varchar of various
> > length):
> > insert into myTBL (col1,col2,col3)
> > values ('#ranVar#','#FORM.element1#','#FORM.element2#')
>
...more >>
Re: Speed Issues After SQL Upgrade Posted by Ben at 10/12/2007 2:54:16 PM The hardware configuration below:
- Has two Intel Quad-Core Xeon processors
- 10GB of RAM
- 15,000RPM SATA hard drives
The old server was just a regular P4, 4G RAM.
"Ben" <pillars4@sbcglobal.net> wrote in message
news:FURPi.1671$LD2.266@newssvr17.news.prodigy.net...
> We recently upg...more >>
Speed Issues After SQL Upgrade Posted by Ben at 10/12/2007 2:46:33 PM We recently upgraded our MS SQL Server 2000 to 2005.
Here is what we did:
1. Perform backup of the database from the old server.
2. Created a blank database in the new server.
3. Restored the database into the blank database located in the new server.
After this process, there was an obvi...more >>
Indexed View Crashes ASP.NET App Posted by Jason Wilson at 10/12/2007 2:40:57 PM I was looking to improve the performance of an ASP.NET application by
creating the an indexed view that could be used instead of some of the
root tables.
What I didn't realize is that it would affect any future conenctions
to the root tables.
This of course crashed the application on any ty...more >>
Re: how to query for a column value that contains dashes Posted by aj at 10/12/2007 2:09:27 PM The fact that the datetime column values contain dashes is incidental.
You need to query just the date part of the datetime.
Try something like this:
select * from profile
where dateadd(dd,datediff(dd,0,msgdate),0) = '10/2/2007'
---
This should work also:
select * from profile
where msgdat...more >>
Re: Would special character cause insertion problem? Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 1:57:43 PM Hi Jack,
Very simple sql dml code (all the columns are of varchar of various
length):
insert into myTBL (col1,col2,col3)
values ('#ranVar#','#FORM.element1#','#FORM.element2#')
The err msg is:
Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3EFCA'. Cannot
insert duplicate key in ...more >>
Re: How to Execute SQL Scripts using Batch file? Posted by Dan Guzman at 10/12/2007 11:31:26 AM > How can i give UserName,Password,Database and all those things?
>
> Plz send me details how to do that...if possible with example...
To expand on Erland's response, you can pass parameters on the command line
and reference using %1 through %9. The examples below execute all the
".sql" sc...more >>
Re: get value of a single record instead of aggregated value with GROUP BY Posted by Roy Harvey (SQL Server MVP) at 10/12/2007 11:11:26 AM On Thu, 11 Oct 2007 23:47:18 -0700, blackpuppy <mingzhu.z@gmail.com>
wrote:
>I would like to use the following SQL statement to get the latest
>comment for all products.
>
>SELECT PRODUCT_ID, COMMENT, UPDATED_ON
>FROM PRODUCT_COMMENT
>GROUP BY PRODUCT_ID
>HAVING UPDATED_ON = MAX(UPDAT...more >>
how to query for a column value that contains dashes Posted by jdrake NO[at]SPAM living-dead.net at 10/12/2007 10:01:32 AM Hi,
I have a large table with a 'datetime' column that has date and time
values in it. The data is in this format:
2007-10-02 09:54:00.000
The table is called 'profile' and the column 'msgdate'
I want to return only rows that match a specific date. So far I have
the following query wor...more >>
Would special character cause insertion problem? Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 7:21:33 AM Hi,
SQL env: sql server 2000
Target column of insertion: varchar(15)
Case, a var is made up of a character of the following characters
(random selection):
A,B,C,D,E,$,!,%,^,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,&,*,(,)
and a few numbers (random selection), and then
var = ran1&ran2
...more >>
get value of a single record instead of aggregated value with GROUP BY Posted by blackpuppy at 10/11/2007 11:47:18 PM How to get a record value instead of aggregated value with GROUP BY?
Assume that I have a PRODUCT_COMMENT table defined as below. It logs
the multiple comments for products. A product may have multiple
comments logged at different time.
CREATE TABLE [dbo].[PRODUCT_COMMENT](
[COMMENT_ID] ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |