|
|
|
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 COLLATION for the reverse e character (nchar(399)) Posted by ata at 9/27/2003 11:32:19 PM hi,
I can insert the "reverse e character" (which is nchar
(601)) in a column that uses nchar or nvarchar.
but I must insert it in a column which is char or varchar.
how can I find which collation I must use?
best regards,
ata
...more >>
AutoNumber in SQLServer 2000 Posted by VideoSmeden at 9/27/2003 10:59:28 PM Hi
Please help me URGENT
How do i make an tableField with a
Auto-Incr, the same like in an access DB where it's
called AutoNumber
Thanx in advance
__________________________________________________________________ Flemming
Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>
Denormalizing a Column without using Cursor Posted by Jeff Swanberg at 9/27/2003 7:40:34 PM Here's a simplified version of the scenario (and, before anyone asks, NO I
can't change the structure - it's inherited and it is what it is):
Table1
StudentID, int
Lastname
Firstname
Table2
StudentID
ParentLastName
ParentFirstName
Is there a set-based solution to taking those two tab...more >>
Darn I should know this Posted by RD at 9/27/2003 3:34:27 PM Table groups with Groupid as PK, Groupname as a field
Table Users with UserId as PK, Username and Password as fields
Table UsersInGroups with a UinG as PK, Groupid as FK with Groups and UserId
as a FK with Users.
Given that there are some users but not all that belong to a group I want a
quer...more >>
Look at this important pack Posted by Timothy Drake at 9/27/2003 2:10:15 PM MS Client
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer
from these vulnerabil...more >>
Erro running a query if dashes present in the string Posted by Satvic at 9/27/2003 1:38:40 PM Hi all,
I have a table in the DB which holds ISBN book nubers .. which, as you know
have dashes (examlple: 0-98765-8-9).
When I run a query from an ASP page to find the number, it doesn't return
anything:
sISBN = "0-98765-8-9"
OpenSQL(select URL from ISBN_Redirect where ISBN=" & sISBN )...more >>
CORRECTION-inserting UNICODE characters Posted by ata at 9/27/2003 12:27:00 PM hi,
I'm trying to insert "reverse e" character with this
statement:
insert table1 values (...)
(... is for the "reverse e" character)
but inserts "?"
which settings must I check?
please help me?
best regards,
Ata
...more >>
inserting UNICODE characters Posted by ata at 9/27/2003 12:12:55 PM hi,
I'm trying to insert "reverse e" character with this
statement:
insert table1 values ('ə')
but inserts "?"
which settings must I check?
please help me?
best regards,
Ata
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ROWNUM equivalent in SQl Posted by LIN at 9/27/2003 12:04:56 PM Do we have a ROWNUM equivalent in MS SQl Server 2000?
Cheers,
LIn
...more >>
Proc Logic Question Posted by Jim Heavey at 9/27/2003 11:54:08 AM Hello, I am trying to learn how to code a proc with a
little bit of logic.
I have a table which cust_number as it key. I have two
parameters which come into the proc, one is @custNumber and
the other is @lastName. I want to use the @custNumber in
the where clause of my select.
If the que...more >>
FWD: Prove this correction pack from Microsoft Corporation Posted by Àëåêñàíäð Ñêëÿð at 9/27/2003 11:28:46 AM Microsoft Customer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to maintain th...more >>
Decimal or Float Posted by Kerri at 9/27/2003 10:01:50 AM Hi,
I have an ASP app that allows users to enter monetary
amounts.
I teh call a Srored proc that takes teh amount as a
decimal and does an insert.
If I input 100000000.00 into a decimal column (15,2) it
works OK.
If I input 1000000000.00 it tells me "Error converting
data type floa...more >>
Taste these critical patch Posted by Cathy Ruiz at 9/27/2003 9:45:36 AM MS Customer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to hel...more >>
Basic question Posted by Oliver Young at 9/27/2003 9:36:33 AM
I'm new to SQL Server 2000. I've just downloaded trial sofrtware. How can I set autoincrement column when creating table in
"Enterprise manager". What data type I have to choose?
...more >>
Formatting within a Stored Procedure Posted by CG at 9/27/2003 7:30:51 AM Hi,
I have a value in a DB Table whoich holds a value that
represents the number of months.
Is it possible to format this in my Stored Procedure to
display Years and Months in my result set.
e.g In my table my column value is 37 which is 3 Years 1
month.
Is this possible.
The reas...more >>
DTS vs Query Analyzer Error Posted by Andrea Worley at 9/27/2003 5:37:14 AM I have a stored proc that I run via a scheduled job. It
processes 10 views and appends data to a table. When I
run the stored proc in Query Analyzer, if one of the views
has an error, the other 9 still run. If it is running as
a job, if one of the view has an error, the whole job just
s...more >>
Take a look at internet patch from M$ Posted by GIACOMO at 9/27/2003 2:24:34 AM Microsoft Partner
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |