|
|
|
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 31 incorrect settings: 'ANSI_NULLS., QUOTED_IDENTIFIER'. Posted by matty2112 NO[at]SPAM hotmail.com at 10/26/2003 10:01:52 PM Getting an "incorrect settings: 'ANSI_NULLS., QUOTED_IDENTIFIER'."
error after creating a view.
We wanted a composite unique constraint that ignored nulls, so we set
up a view using the following script:
/* --- start --- */
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET...more >>
Trim String Posted by freger at 10/26/2003 9:20:46 PM Hi,
I have a column in an SQL table which i would like to trim
the spaces between string.
e.g EV 21 to EV21
Can anyone tell me how to do it manually. I know i can do
it automatically in DTS. But I would like to do an one-off
from the query analyzer. Can someone tell me.
Thank you....more >>
long running query Posted by George Morton at 10/26/2003 8:43:29 PM I have a query that filters based on transaction date. However, performance
suggests that entire table is being scanned <am using WHERE date BETWEEN
LowDate and HighDate.
Any suggestions to make this dog fly? TIA George.
...more >>
Long running query Posted by George Morton at 10/26/2003 8:42:10 PM I am looking for help on a query which filters transactions based on a date
range <WHERE date BETWEEN LowDate and HighDate.
Slow performance indicates query is scanning all transactions.
Every record has a valid date. Any suggestions to make this query fly?
TIA George.
...more >>
Help with SQL crosstab Posted by rt at 10/26/2003 7:04:42 PM Hello,
I'm having problems getting results for a "crosstab". (I quote crosstab
because SQL really doesn't support crosstabs.)
Assume I have the following data (Much simplfied)
Table1
Id Name
1 N1
2 N2
3 N3
Table2
ParentId LastUpdate(datetime) Attribu...more >>
Same logical databae name...... Posted by Gary Smith at 10/26/2003 6:32:52 PM I am using SQL Server 2000.
I have the same logical database name for different databases. Is it OK to
continue or do I have to address this issue ?
Thanks,
Gary
...more >>
Newbie: Date vs. char datatype Posted by middamian NO[at]SPAM yahoo.com at 10/26/2003 6:21:32 PM Hello,
In my application I use a date without time part - it will never have
a time part.
What is the best way for storing this date: In a smalldatetime column
or in a CHAR column as yyyyMMdd?
This column is used in a lot of queries.
Thank you,
Mid...more >>
Translating script from Oracle to SQL Posted by Morten K at 10/26/2003 4:12:40 PM I have a DB - script written originally for Oracle but now
I need to re-write it for use on SQL Server 2000. Seeing
datatypes and keywords differ, i was wodering if there is
an "easy" way to convert the script so I can use it on the
SQL Server.
What I am looking for is either a tool wich wo...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Comparing Two Tables for Inaccuracies Posted by David C at 10/26/2003 3:53:43 PM Hi Everyone,
I was hoping you all might be able to help, I need to do a validation on
some data that was brought across into our SQL db from a legacy
mainframe.
I have the mainframe data in a temp SQL l table with the columns Title,
Issue, Outlet, Sales Qty, Dist Qty, Extras Qty, Returns Qt...more >>
Grouping by dates, in 15 minute values Posted by Glenn Wilson at 10/26/2003 2:22:24 PM
I have to run a report on a table returning the results
in a table that is broken down into 15 minute groups.
The data for this report is generic and and basicly a
sample as follows
id date
15482 20-10-2003 12:56:23
17586 20-10-2003 12:45:12
13751 20-10-2003 14:23:12
......more >>
Repost: MSDE crash... What to do with the dump file???? Posted by José Joye at 10/26/2003 11:35:19 AM I get from time to time a MSDE crash and I got a SQL dump that tells me to
send the information. However, I do not know to whom and at which condition.
Does anyone has an idea about it?
Last time I got the error, the following (only part of the file is
provided )
The following SP was call...more >>
delete from <table> from <source> ? Posted by konsu at 10/26/2003 11:09:52 AM hello,
i am lost:
this is how i create a table:
set nocount on
if exists(select * from sysobjects where id = object_id(N'mytable') and
objectproperty(id, N'isusertable') = 1)
drop table mytable
create table mytable (id uniqueidentifier not null, value char(16) not null)
go
inser...more >>
Should I use Linked Server or Replication ? Posted by Tristant at 10/26/2003 11:06:42 AM Hi SQL Gurus,
This is a design question.
I have a system that must be implemented across two servers ('politically'
decided by the owner)
Server1 : Sales Order, Invoicing, Delivery Note (Order Processing)
Server2 : Inventory, AR etc.. and the rest of the system.
The two servers, on different...more >>
How to write SP - Insert multi records Posted by Jean at 10/26/2003 10:41:58 AM Hello,
I have a classical ASP web data entry form with 20 rows that allows users to
enter multiple records at once, my questions are:
a.. How do you write a SP that will insert multiple rows to my destination
table?
b.. How do you determine the number of rows entered by a user on the we...more >>
Logfile name Posted by martin at 10/26/2003 9:40:33 AM Hi,
Is it possible to pick up the name of the log file on disk (full path) and
size of it in MB by using T-SQL.
I have just written a script to loop though all of the databases on the
server and truncate the logfile.
however I would like to be able to display the full path of the log file and...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |