|
|
|
March 2003 April 2003 May 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 |
formatting date field Posted by Jarod_24 at 4/30/2004 4:22:01 PM How do i format a DateTime file in a sql-query?
I got a sql sentence like this:
"SELECT Name, DateRegistered
FROM Customer;"
The "DateRegistered" field comes out as "2004-05-10T00:00:00.0000000+02:00"
I need it as "DD.MM.YYYY".
Is there any function that i can use, like "DateFormat" i...more >>
Reporting Services Posted by Bryan Bullard at 4/29/2004 5:45:04 PM Can anyone share there experience with using MS Reporting Services.
Thanks in advance.
...more >>
DB fixup after migration Posted by d_lwl NO[at]SPAM hotmail.com at 4/27/2004 10:05:56 PM We have a recurring problem due to the use of a naming convention
where database names are suffixed by the environment (e.g. SD for
development).
The result is that after a database copy from production to
development, all references to objects in a different database would
have the wrong qua...more >>
Extented Procedure / COM issue Posted by carlbjames NO[at]SPAM yahoo.co.uk at 4/27/2004 8:49:58 AM Aplogies if I've published this in the wrong group; not sure where it
should go!!
I have an extended stored procedure written in Delphi. Basically it
makes a number of COM calls and returns a psuedo result set as if it
were a normal query.
Now, the COM objects are solid, and the dll that i...more >>
Easy way to replicate an entire server? Posted by mike NO[at]SPAM ovidinc.com at 4/23/2004 7:56:36 AM I have two SQL servers on the same network which need to be
replicated. One is just an online backup for the main one. It has a
ton of databases on it. Is there an easy way to replicate the entire
server, without having to publish each database? Am I going about
this the wrong way?
Thanks ...more >>
Problem Running sproc using linked server Posted by Kayda at 4/21/2004 5:19:13 PM Hi:
I have setup a Sybase Linked Server and am trying to run a stored procedure
against it. When I execute the sproc, it tells me that there are too many
prefixes, the maximum is 3. But I thought it was necessary to use 4 for the
sproc. Here is the sproc, which otherwise works fine if I import...more >>
MSDE 2000 SP3 Connection Problem Posted by Mark Miles at 4/20/2004 11:41:00 PM I am have a problem which has only just started happening while trying to
connect (locally) to MSDE 2000 (SP3a) which also prevents me from using
VS.NET Server Explorer.
When I try OSQL -E -S mimpc\NetSDK (this use to work) I get the following
error
[Named Pipes]SQL Server does not exist...more >>
Error writing to SQL database from Access Posted by daryljharrison NO[at]SPAM netscape.net at 4/20/2004 1:43:46 PM Greetings,
I am developing an application that writes values from an Access 2000
database to an SQL 7.0 server using DAO and linked tables. It seems to
work fine for the first 26 of 108 tables, but part way through the
population of the 27th table it stops and displays a 'Runtime Error
3001 I...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Cannot See a Newly Installed SQL Server 2000 (No Active Directory) Posted by jaykchan NO[at]SPAM hotmail.com at 4/20/2004 5:45:37 AM We have just installed a SQL Server 2000 (SP 3A) onto a computer that
has Windows-2003 Server on it. Now, we cannot get access to that
database server from other computers. Seem like this may be an issue
with Active Directory.
Our network consists of Windows-2000 Servers (SP 4) and Windows-200...more >>
Nested Full Text Queries Posted by John Doe at 4/20/2004 1:19:16 AM Can someone help me or provide a workaround? The object is to select all
articles which are not references to other articles. The problem I am
having is when I try to get the ReferenceCount (which is the count of
articles which reference this article) it is throwing a 42000 (Error 170:
Line 6:...more >>
How to set default value of a column to current year Posted by Dino Buljubasic at 4/19/2004 7:54:41 PM Hi,
I have a colum "AYear" in my table and would like to set its default
value to current year (i.e. 2004)
How can I do that?
Thank you,
Dino...more >>
SQLServer 2000 Installation Posted by Christopher J. Stephens at 4/19/2004 3:16:50 PM Hi,
I am just installing SQL Server 2000 on my desktop running Windows XP Pro
and intend to install the Client tools onto my laptop and do my access from
the laptop.
When I install the latest service patch, will I also need to install it on
the laptop as well for the Client tools?
I am ...more >>
Where can i get this SQL 2000 PRESP4 Fix ? Posted by W e Z at 4/16/2004 2:09:15 PM Hi All,
I Believe i have the error listed in this MS KBA:
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&FR=1&PA=1&SD=HSCH
But i have searched MS High & Low but connot find the "supported fix".
Please can somebody help me!!
Regards,
W e Z
...more >>
Backup Job Fails, but Command Works in Query Analyzer Posted by michael [multnomah] at 4/16/2004 1:17:18 PM Hello. I am completely stuck as to why my backup job is failing. I
have a job which backs up all user databases. All of the user databases
get backed up no problem, except for one. That one fails with:
BackupDiskFile::OpenMedia: Backup device
'D:\BACKUP\EMPMART_PRD\EMPMART_PRD_db_200404...more >>
inserts inside a transaction get committed even though stored procedure fails ? Posted by maellic2002 NO[at]SPAM yahoo.fr at 4/15/2004 6:41:04 PM Hi
I have a stored procedure full of insert statements inside a
transaction. One of my insert statement has an error in it so I would
expect that none of the insert statements get executed. However I have
noticed that at least the first insert of the stored procedure gets
executed even if one...more >>
How do I speed up this query ? (1.7M table entries) Posted by Alan Silver at 4/14/2004 6:32:17 PM Hello,
I have a table containing position data for all of the postcodes in the
UK. There are around 1.7 million of these. I would like to be able to
query the table and pull out all postcodes within a specified distance
of a given one. The code I have at the moment takes about 20 seconds to...more >>
Suspicious Write Lock Posted by sgowell NO[at]SPAM mphi.org at 4/13/2004 10:08:37 AM A co-worker has developed a web application that reads from a sql
database named "mlci". Roughly every 12 hours, whether the application
has been particularly active or not, we get a write lock that prevents
the application from writing to our table for managing users (changing
a bit field from ...more >>
SQL Server/ADO/XP problem "query cannot be executed" Posted by George Copeland at 4/12/2004 10:42:31 PM This is a request for help fixing a SQL Server 2000/ADO problem on Windows
XP. I would appreciate any useful assistance.
PROBLEM: SQL Server access on my machine fails as follows:
1. All of my VB6 apps reference the following ADO typelib:
Microsoft ActiveX Data Objects 2.7 Library
Locate...more >>
Matching Strings In Different Tables Of Same Database Posted by Smith at 4/11/2004 12:13:56 AM I have a situation where I want to pull strings from one table of a SQL 2000
database and find matches for it in other tables of the same database and
have those values returned. i.e. In one table I have prospects and I want
to match their names to a table that stores the names of prospects tur...more >>
Dynamically building a Tablename in a stored procedure Posted by Kayda at 4/7/2004 4:57:39 PM Hi:
I am building a stored procedure off of a particular application's data.
This application has event data stored in tables with table names that are
dependent on the day. For example:
EventData04072004-this table contains data from April 7th, 2004
EventData04062004-this table contains da...more >>
Simple query on huge table uses Index Scan instead of Seek Posted by John Hendrikx at 4/7/2004 2:46:00 PM We're experiencing a problem on SQL Server 2000.
We're doing a very simple query on an unique index field results which
performs bad because the Optimizer decides to use an Index Scan instead
of an Index Seek. The query we're testing is below:
SELECT * FROM hugetable WHERE unid='abcd...more >>
SQL Server slower than MS Access Posted by trnospam NO[at]SPAM earthlink.net at 4/7/2004 5:10:36 AM (sorry for the cross post - not sure where most people are on these sites)
We're having trouble with a new SQL Server installation upgraded from MS
Access.
A very large update query affecting 750,000 records with an inner join takes
more than an hour to run on SQL Server and was actually fas...more >>
Data Compression possible in SQL Server? Posted by Jack Victor at 4/6/2004 4:55:23 PM Hi,
I'm wondering if it is possible to compress the data in SQL Server. For
instance, in Oracle, there are routines you can use in stored procedures
to compress and decompress data. Is this possible to do in some way with
SQLServer?
Thanks!
Jack...more >>
defination in script Posted by Roy at 4/6/2004 2:17:47 PM Hi All,
I need to create a script, of an existing table, and create the table on
another database. Everything works except, it did not include the
definations. Is there an option I am overlooking that would include the
definations?
I am using Enterprise Manager and all tasks, Generate SQL Scrip...more >>
SELECT & number of line Posted by myname at 4/5/2004 12:21:37 PM Hello,
I'm using SQL Server 2000.
I would like each line of my SELECT to contain a column
giving the number of the current line.
It seems the only way to do that is something like:
INSERT identity(int,1,1) as lineNumber,* INTO newTable FROM oldTable
But oldTable as an identity column...more >>
Finding and inserting consecutive pairs Posted by myname at 4/5/2004 11:12:42 AM Hello,
I'm trying to insert into a table consecutive pairs from another table.
Right now, I'm using a cursor but I wonder if there's a faster way.
Example:
My table1 contains a column of integers: 1, 20, 3, 45, 12
I want to obtain this in a two columns table Table2 :
(1;3) (3;12) (12...more >>
Need Help with complex stored proc SQL Server 2000 Posted by mlr263 NO[at]SPAM netscape.net at 4/3/2004 1:13:22 AM Hi,
I have a table which specifies relations between two people (person1,
person2, relationship). An individual could be listed in either the
person1 column or the person2 column. If I want to find all the
relations for a specific person, I need a stored procedure which would
search both co...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |