|
|
|
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 Identity Col and Transactions Posted by aussie rules at 8/22/2004 11:30:34 PM Hi,
I have a table with an Identity col, and it seems that if i insert a record,
but then role back the transaction, the identity value does not get
release/rolled backed as well.
Is this normal ?
...more >>
how to order by string data type that is actually numeric? Posted by Bobby at 8/22/2004 10:34:06 PM Hi...
I just curios about this.
I have 1 tabel 'tbl1' and 1 column 'col1' as string
Col1
110
21
2
query --> "select * from tbl1 order by col1"
result:
Col1
1
10
2
21
Question: Can I order the data as numeric, not as string? How?
I want to get result
Data
Col1
1
2
10
21...more >>
How many Administration Fields are too many Posted by dsellers at 8/22/2004 9:49:02 PM I am trying to set up a simple level of auditing in my Database until I can
figure out how to do this in a batter fashion. If anyone has better thoughts
please let me know.
At the end of every table I add:
Version ROWVERSION,
DateCreated DATETIME NOT NULL,
CreatedBy NVARCHAR(50) NOT...more >>
Can we just use replace()? Posted by Hank at 8/22/2004 8:44:47 PM In the Client table, the FirstName looks like this:
SELECT FirstName
FROM Client
WHERE FirstName like '%/[0-9]/%'
AARON DAVID RINGSTAD 8/3/00 TANIS
LANDON DREW ALDRIDGE 12/8/00 ERIN
JOHNNA MANSON 11/9/00
CORNELIUS, TODD 2/6/04
BOYD HOFMANN & TODD HOFMANN 10/6/
SYLVAIN ...more >>
Can we just use replace() ? Posted by Hank at 8/22/2004 8:35:38 PM In the Client table, the FirstName column looks like this:
SELECT FirstName
FROM Client
WHERE FirstName like '%/[0-9]/%'
AARON DAVID RINGSTAD 8/3/00 TANIS
LANDON DREW ALDRIDGE 12/8/00 ERIN
JOHNNA MANSON 11/9/00
GAIL JOHANNESSON 1/9/02 GARRY
JANET LAIDLAW 11/3/00
MA...more >>
Creating table with Image datatype Posted by Apati at 8/22/2004 5:43:02 PM Hi,
Please, I like to know how to create a table with an Image and how to insert
and retrieve images from the database. Which datatype to use when creating
the table....more >>
SQL to get data from previous row Posted by Paul at 8/22/2004 4:11:10 PM I am more of a programmer than a database expert. I was
asked the following question at an interview that I could
not answer.
The question was:
Say a table with the following columns:
Date column and Index column.
For ex:
Date Index
01/01/2004 100
02/01/2004 101
03/01/200...more >>
Query Help Posted by Lontae Jones at 8/22/2004 1:51:05 PM Hello, my table schema is below
In my [DESCRIPTION] column the data is very long. I just need a query that
returns only 25 characters of description rather than an entire row.
CREATE TABLE [_TELMASTE_] (
[SEQUENCE] [int] NOT NULL ,
[LASTMODIFIED] [datetime] NOT NULL CONSTRAINT [DF_TELMA...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
VARCHAR2 data type Posted by Matt at 8/22/2004 1:27:55 PM seems like MS-SQL only supports VARCHAR data type for strings. If I have SQL
CREATE TABLE statements using VARCHAR2 data type, that means I need to
change the SQL CREATE TABLE statement?
please advise. thanks!!
...more >>
Text less than 50 characters Query help Posted by Lontae Jones at 8/22/2004 11:13:01 AM Hello,
I need a query that returns less than 50 characters on a text field.
Column called description...more >>
Want to kick off a child process from a parent process Posted by SQLDBA71 at 8/22/2004 8:41:02 AM I will appreciate if anybody can help me out with giving me some idea about
kicking off a child process from a parent process. For example everynight I
am running a dbcc showcontig process. In this same process I want to the
fragmentation of the table if it is less than a threshold then anothe...more >>
why does M$ charge permissitic locking? Posted by toylet at 8/22/2004 3:43:39 AM
back in Netware-DOS days, applications can connect to the file server
continueously to process data on the server harddisk. Netware counts
login-ids, not connections.
I don't understand, your honour.
--
.~. Might, Courage, Vision. In Linux We Mutate.
/ v \ http://www.linux-s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |