-
Entered data appears TWICE!!??
I'm JUST getting started with the online SQL tutorial. When I create a table and insert data, the data appears TWICE. A simple example:
***Create the table:
create table rnmrgntable
(first varchar(20),
last varchar(30));
***Insert data:
insert into rnmrgntable
(first, last)
values ('Bill' , 'Smith');
***Then look at the table:
select * from rnmrgntable;
And I get:
first last
Bill Smith
Bill Smith
What the heck's going on? It's really frustrating to try to start learning something new and not even be able to get through the first lesson!
-
Is there any trigger on the table that is inserting the row again?
-
Entered data appears TWICE
I'm sorry, but I don't know what you mean by "trigger." I'm just entering the data exactly as instructed in the tutorial.
-
From enterprise manager, right click on the table and go to manage triggers. Go to drop down to see if insert trigger is defined.
If there is no trigger then you must have inserted the row twice.
To confirm, delete all rows and insert again and select.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|