|
|
|
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 August 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 31 Regional Settings Posted by Nic at 5/9/2004 11:41:02 PM Hi
My default decimal separator is comma (european). It is also in my regional settings
But in sql server when I do a data import via a DTS. He gives me alway error on decimal fields. So I think he uses a point as decimal separator
How I say to SQL serve to use always my regional settings
Also...more >>
Clarification on NULL Records Posted by Ana at 5/9/2004 10:57:19 PM Hi All
Please write me the reason for
SQL:
-----
select * from table1
where Required <> 'Y'
the result set is empty.
Table Schema is:
---------------
CREATE TABLE [dbo].[Table1] (
[Names] [nvarchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Required] [nvarchar] (10) ...more >>
SQL Server memory hole. Posted by Anubis at 5/9/2004 5:13:18 PM Hello,
I have been working for some time now with SQL server. Just recently I have
been working on a new site development, and I have ensured that all my SQL
and ASP coding is "clean" meaning that if I opened something I closed it...
etc.
However, I seem to still encounter a "huge" memory ...more >>
Transacion log Posted by boby at 5/9/2004 1:55:07 PM Production server installed with - default configuration.
Problem: transaction not truncating after log backup. If i
stopped the application, its truncating next backup this
happening randomley....more >>
Re: SQL Join clause to emulate an SQL (where not in) clause Posted by linuxman at 5/9/2004 1:38:42 PM
David Portas wrote:
> *If SomeLookupTable.ID is Nullable then you may want to add th
> extra
> predicate:
>
> ......
> AND lutbl.ID IS NOT NULL
>
> to come closer to the behaviour of NOT IN.
>
> --
> David Portas
> ------------
> Please reply only to the newsgroup
> -- *
Is it ...more >>
text 900 chars? Posted by Ryan at 5/9/2004 12:26:08 PM I have a SQL table of type TEXT, and when placing values into this through a
C# program, the column in the table has nothing if I try to insert over 900
characters. This column is not a key or index.... what's my problem?
thnx
...more >>
convert unicode to ansi Posted by Kyriacos Michael at 5/9/2004 11:53:49 AM I am having problems using ANSI encoding to query a unicode database that is
storing greek.
from Query Analyzer:
create table table1 (field1 nvarchar(10))
insert into table1 select N'psi' --where psi is some greek characters
select * from table1 where field1='psi' -- no results which is ...more >>
Need to return the record that contains the minimum value of one particular field Posted by Larry Woods at 5/9/2004 11:22:02 AM Yes, I looked in BOL, but really didn't know WHERE to look for this...
I want to return the record that contains the minimum field value of a
field (price, in my example). I don't see how to use a minimum function in
the WHERE clause.
TIA,
Larry Woods
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
GUID for MDF? Posted by Neil W at 5/9/2004 9:46:53 AM Is there a way of unique identifying a database with a GUID? E.g., any
place to store it in the MDF header? Thanks for any tips.
...more >>
SQL Server does not exist or access denied! Posted by Gtarawneh at 5/9/2004 8:16:03 AM Hello All
I am facing a strange problem with my network application and hope somebody can help me
I've developped a network application where client applications using Windows 98 connect to a centralised SQL Server 2000 running on Windows XP Professional. The application works well for days, but ...more >>
Intersection Capabilities? Posted by paul reed at 5/9/2004 7:51:09 AM I was surprised to see SQL Server doesn't have an INTERSECT keyword...they
do have one...but not usable in a query. Here is a Union query...but I
really need the intersection...how would one do this in SQL Server?
Thx...Paul
select address1, address2, city, state, address_id
from address a
...more >>
Is there such a thing as a User-defined Global variable? Posted by Larry Woods at 5/9/2004 6:14:19 AM I have various SP's that have SELECT's that are are based upon a particular
field having a unique value. I am passing this value into each of the SP's.
This value will be the same for some time (months). Then it might have to
be changed. Is there a way that I can set a variable that can be acc...more >>
Openquery Problem with Access DB as linked server Posted by Gan at 5/9/2004 6:08:46 AM Hi,
I have created a linked server access to a remote Microsoft Access
2000 database in SQL Server 2000. In my sp, I was trying to run the
following query:
EXEC('SET ANSI_NULLS, ANSI_WARNINGS ON EXEC(''SELECT orderid,orderdate
FROM linkedsrv...tblsales'')')
The query works fine but run...more >>
Computer Posted by delance13 NO[at]SPAM yahoo.com at 5/9/2004 6:04:06 AM What is meant by an upgrade version...more >>
input command interface Posted by Tonya at 5/9/2004 3:16:02 AM Hi. Please tell me that, wherer is the sql server input command interface. I have installed it and I can see it's icon of Sql Server Service Manager, but I can't find a way to input, for example Create Table command...is there any 'Getting Started' article for using Sql Servier installed on Win XP p...more >>
tuning the sort step of execution plan Posted by o_nazmy NO[at]SPAM yahoo.com at 5/9/2004 3:06:50 AM hi
i got a query that takes about 14 mins
here it is
select BDProduct.ProductCode,BDProduct.ProductName,SALTerritory.TerritoryID
,SALTerritory.TerritoryName,SALAccount.AccountID,SALAccount.AccountName
,sum(SalesNetFact.Qty2) as Quantity
,sum(SalesNetFact.bonus) as Bonus
from SalesN...more >>
How to find the column datatype Posted by Anil at 5/9/2004 1:48:47 AM Hi All,
I know the column name and table name. Is it possible to find the datatype
and how many characters is the datatype.
Please send me the query if u have.
Thanks,
Anil
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |