|
|
|
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 |
Filter by week: 1 2 3 4 5 Updating a row in a recordset Posted by Charlie at 9/7/2007 5:04:32 PM What properties to you set to make a SQL 2005 recordset updatable?
In Access, it's
Recordset.edit
Recordset!FieldName=SomeValue
Recordset.update
Any help is appreciated.
...more >>
Add records in a table Posted by Hamilton sucks at 9/7/2007 2:47:56 PM Hi:
I need to add some records in a table called location(primary key:
loc_id). What I want to do is for each location in the table, I add
the same record but with a different loc_id, which can be a random
string. All the other column should contain the same value. Can anyone
give me a hint on...more >>
One bound form does NOT save record - please help! Posted by teddysnips NO[at]SPAM hotmail.com at 9/7/2007 8:44:35 AM ACCESS Front End
SQl Server 2k Back End
The application is a perfectly straightforward MS Access MDB file that
is linked to a SQL Server database on a LAN.
The application has been stable for six years. However, earlier this
month the SQL Server box crashed, owing to another database growi...more >>
char vs varchar and indexes Posted by Nick Chan at 9/6/2007 9:43:04 PM all these while i've only used varchar for any string
i heard from my ex-boss that char helps speed up searches. is that
true?
so there are these:
1) char with index
2) char without index
3) char with clustered index
4) varchar with index
5) varchar without index
6) varchar with clust...more >>
Complicated query Posted by Nick at 9/6/2007 10:29:30 AM Hi,
I have two tables Trade table and Cons table. Records are inserted in
both the tables independent of each other. There are fields like
Exc_Ref, Qty, Date in both the tables.
I need to write a query which should give me records :
1. Where there is missing Exc_Ref value in either of the...more >>
JDBC connections w/ AD login? Posted by aj at 9/6/2007 9:42:18 AM I'm a newbie w/ SQL Server 2005.
We will be connecting to SQL Server 2005 via JDBC. We have made this
work by using an SQL Server account, rather than an Active Directory
(AD) account, even though SQL Server IS in mixed authentication mode.
Does mixed mode mean you can connect either way, ...more >>
sql rules and udt Posted by Nick Chan at 9/6/2007 4:01:33 AM hello, i've just started playing around with rules and udt
is it possible to alter rule?
are rules 'slower' compared to check constraint?
...more >>
Help needed: Granting Create table permisions on specific Schema Options Posted by gdev at 9/5/2007 6:14:17 PM
Having some trouble getting my head around setting access to specific
schemas- here's my problem:
I've created a specific schema that I only want certain users to
control
Problem: Even though I give them full access....the cannot create
tables under that schema...my code is below (fl...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Grouping similar rows Posted by jan_soderman NO[at]SPAM yahoo.se at 9/5/2007 7:59:32 AM Hi
I would like to group rows based on order and similarity in a single
sql-query if possible:
A, 1, 50
A, 2, 50
A, 3, 100
A, 4, 50
A, 5, 100
A, 6, 100
Would come out as:
A, 1, 50, 2 <-- Last value shows number of grouped rows
A, 2, 100, 1
A, 3, 50, 1
A, 4, 100, 2
Any suggest...more >>
Importing images to SQL Server 2005 Express Edition database Posted by pompair at 9/5/2007 1:30:57 AM Hi,
Could someone give a pointer how to import couple of hundred images
into Sql Server 2005 Express Edition database?
Is there a tool for it? Can it be done with Sql Management Studio or
is it just a matter of writing own piece of software (a little helper
app) to do it?
-timonardo
...more >>
Changing data-types Posted by Danny at 9/4/2007 8:13:18 AM Hi All,
I have a varchar(255) column for storing text in english and in
hebrew.
It was a stupid mistake to set the data type to be varchar, because
now I need to store text in german and francais too.
Question: Is it safe to change the data type from varchar to nvarchar,
without damaging t...more >>
String/Date Concatenation causes conversion error - streamline fix suggestions Posted by Chris H at 9/4/2007 7:34:21 AM Hi,
I'm trying to concatenate a Description (nchar(100)) and Date
(datetime) as Description and my initial effort was just
"...description+' '+open_date as description..." which throws a date/
string conversion error; finally came up with a working string below
but don't think it's the optimal ...more >>
Is ROLLUP really better than doing a nested query when rank is involved? Posted by csimam NO[at]SPAM gmail.com at 9/4/2007 3:06:55 AM Here is a thread I posted elsewhere that I wonder if someone here
could shed some light on...
The original question I had:
--- BEGIN ---
Which one is better?
1. To perform aggregate queries on data, and use that data to home in
and perform more detailed analysis? This gives result sets tha...more >>
Format for six character date Posted by robboll at 9/3/2007 10:56:24 PM Using SQL Server 2000 in a view, if the data is Char and six
characters like: 081564
How do I convert it to a date that looks like: 08/15/1964 and is a
date.
I am trying:
CONVERT (varchar, SUBSTRING(Col005, 1, 2) + '/' + SUBSTRING(Col005, 3,
2) + '/' + SUBSTRING(Col005, 5, 2), 112)
bu...more >>
Different collations in a database Posted by urquell NO[at]SPAM gmail.com at 9/3/2007 2:02:23 PM Because of poor upgrading routines I have a SQL Server 2000 database
that has several collations on column level.
The SQL Server itself is correctly setup to use Finnish_Swedish_CI_AS,
the same as the database. However, a number of columns in various
tables also have Danish_Norwegian_CI_AS and
...more >>
Snapshot query Posted by jrpfinch at 9/3/2007 1:15:08 AM Hi
I am relatively new to databases. I would like to be able to run a
query that returns the t_no, b_no, status and cpu for the latest
record for each unique combination of (t_no, b_no and cpu) before a
given point in time (say @snap_time). d_no is an autoincrementing
primary key.
d_no t...more >>
Increasingly greater amounts of redundant aggregate data in queries? Posted by csimam NO[at]SPAM gmail.com at 9/2/2007 3:18:03 PM Hello,
I'd like to start by saying I'm not a DBA, rather I am a Java
developer. But I'm learning more and more about database design, and
it's very interesting.
Here is the general issue I'm facing:
Which one is better?
1. To perform aggregate queries on data, and use that data to home i...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |