|
|
|
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 how to add new column like existing one? Posted by AFN at 1/29/2005 9:44:12 PM What's the best way to add a new column Y to an existing table that already
has existing column X, and I want Y to be x+3? I need to actually save the
value in the database, so yes, I do want a new column.
...more >>
distributed transaction giving error on win 2003 Posted by bijupg at 1/29/2005 8:18:07 PM Hi Guys,
I AM USING DISTRIBUTED TRANSACTION WITH 2 sql server 2000
on
win2k and is working fine.
but the same transaction not working in win2003.
i am getting the following error.
Server: Msg 7391, Level 16, State 1, Procedure P2, Line 5
The operation could not be performed because th...more >>
Auto Number Posted by souris at 1/29/2005 5:03:21 PM May I have an auto number to reset to one if primary key change?
For example,
Key Field Auto number field
1 1
1 2
2 1
I want to auto number reset to one every time Key field change value.
Any informat...more >>
Lock a row Posted by souris at 1/29/2005 5:00:05 PM I wanted to locked to hide a record to other user if the record is viewing
by one user.
Are there any way to do this?
Does lock the record can hide this record to other user?
Any information is great appreciated.
Souris
...more >>
Primary Key - Multiple Columns Posted by bill_morgan_3333 at 1/29/2005 4:37:01 PM Friends,
In Access I can set Primary Keys on two columns so that, together, those two
columns comprise a Primary Key.
Is there a way, through T-SQL, to define two or more columns as the Primary
Key on a table? For example, it may be that the [sku] column contains
duplicate values and the...more >>
How to save the SP result? Posted by Gabriel South at 1/29/2005 4:23:41 PM Hi!
How can i save the resultant recordset generated by an Stored Procedure to
another table (with the same structure) ?
I think its some like INSERT * INTO tmptable FROM **Exec mySProc**
Can you help my?
Thanxs, Gabriel.
...more >>
@@IDENTITY Programming Jitters Posted by Manish Sawjiani at 1/29/2005 6:53:02 AM Hi Experts,
I have done this and it is working but am getting the jitters and it is
making me spend sleepless nights:
Dim rsMaster as New ADODB.Recordset
Dim tempRS as New ADODB.Recordset
cn.BeginTrans
rsMaster.AddNew
rsMaster.Fields!Date = txtDate.Text
rsMaster.Fields!Ref =...more >>
Delete Duplicates Posted by Enrique at 1/29/2005 3:35:02 AM I have this table:
CREATE TABLE [Resultados] (
[Cliente] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Serie] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Numero] [int] NULL ,
[Fecha] [datetime] NULL CONSTRAINT [DF_Resultados_Fecha] DEFAULT (getdate()),
[To...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |