I'm trying to copy data from one table to another which has an Identity field in the destination table. The error message I get when I attempt to run DTS is 'Cannot insert a Null value into column...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10208628.html
Hi all
I Developed a project using VB6, MS SQL 7, and NT 4 as OS. When I wanted to add new record I created a recordset, opened it and then add the code:
RS.Addnew
RS!field1=
.....
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_20310773.html
Zones:
VB DBDate Answered: 06/15/2002 Rating: 8.8 Views: 0
In my SQL table I have a field (personID) set as identity.
When I add a record in that table in VB.net it doesn't show the correct personID it gives the next number. An example:
table in SQL
re...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20859015.html
Zones:
.NETDate Answered: 01/22/2004 Rating: 8.8 Views: 0
I am trying to get the identity of a record added with an ado dataset the sql in the dataset is :-
Insert into Timetran
(casecode, personno, date .........)
Values
(:ccode , :pno, :tdate, ......
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_21176928.html
Hello World!
Is there a way of creating a global identity field? For instance, In my application, I need to generate this auto-incremented unique identifier in the form: XXYYYYMMDDnnnnn
Whe...
http://www.experts-exchange.com/Database/DB2/Q_21669231.html
Zones:
DB2Date Answered: 12/19/2005 Rating: 8.4 Views: 0
Currently the insert is being handled by a sql statement not stored procedure. An example of the insert:
Insert into Customers (Phone, F_Name, L_Name) values (txtPhone.text, txtFName.text, txtL...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21845159.htm...
Hi,
I have 2 tables which are related to each other via composite primary key relationship... ie: table A has one primary key which is connected to two primary keys (composite) of table B, so th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20567364.html
Zones:
MS SQL ServerDate Answered: 09/04/2003 Rating: 7.0 Views: 0
I am using start transaction, commit and rollback on a table that has an identity field. Whenever I do a rollback because the user has cancelled the input the identity field is still incremented. ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20902565.html
Zones:
MS SQL ServerDate Answered: 03/02/2004 Rating: 8.8 Views: 0
Have an Excel spreadsheet that I would like to append to an MS SQL table.
The spreadsheet has 4 columns, the table has 6 columns.
In the table is an additional Identity key field, and an additi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20912831.html
Zones:
DatabasesDate Answered: 03/09/2004 Rating: 7.8 Views: 0
Basically, I'm trying to do some calculations on a subquery, and in order to pull them off, I need each record that gets returned from the subquery to be numbered, in order.
I've got:
SELECT ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21329013.html
Zones:
MS SQL ServerDate Answered: 02/25/2005 Rating: 9.0 Views: 0
