im new to trigger concept
when i insert data in a table [DSR_OUT_PRO] data get enter in another table ie [trg_Insert_DSR_OUT_PRO] but 2 times..
Is it ok, or something is wrong..
Here's my scenario:
I'm using the ASP.Net Membership provider, but I don't want to allow system administrators to DELETE any users. Instead, I simply want to mark them as locked out (aspnet_Membership.IsLockedOut) of the system so they can't log in when an administrator assigns them to a role titled "Inactive". Make sense? Right now my trigger isn't throwing any errors, but it's not working either. Here's my trigger (which is on the aspnet_UsersInRoles table):
[Code]....
Data from the server subscription cannot trigger table trigger
View 2 RepliesBasically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).
View 3 RepliesI want to create a trigger for insert and whenever i insert the data the trigger should fire and notify some value inserted i want to create log table to save this information,now i have created a trigger but i dont know how to map it to log table to notify the changes?
View 12 Repliesi need one query for display last enter row of table..
that table dont have id... that only have name, city, address... how get last enter the row to display...
I got data from different 2 tables and then this selected data trying to insert into new table. Selected data have multiple records.
how may i insert selected multirows into new table which has already been created into db.
Select fname, lname, Addresses.address from Persons Join Addresses on persons.ID = Addresses.PID
The result for this will be multi reocords then how can i insert into new table[already created]. within StoreProcedure
I have 3 tables. I need to insert data from 2 tables into the 3rd table.
The first table has 2 fields -- c_id, c_key
The second table has -- t_id, u_id, partial_c_key
I need to insert c_id, u_id in the 3rd table.
Problem is partial_c_key in the second table contains only a part of the c_key in the first table.
Ex:
First table:
c_id--c_key
1--200A
2--200B
3--200C
4--301A
Second Table:
t_id -- u_id -- partial_c_key
1--23--200
2--36--301
In the data above partial_c_key 200 has 3 c_ids in the first table (1,2,3 with values 200A, 200B, 200C) and 301 has just 1 which is 301A.
In the 3rd table I need to insert c_id, u_id so the data should be
u_id -- c_id
23 -- 1
23 -- 2
23 -- 3
36 -- 4
How do I write a query to accomplish that?
I want to insert some data into SQL Table.i'm using a form which contains one dropdownlistbox,four text boxes and one submit button.if i select a option in dropdownbox and entering somedata into the corresponding Textboxes and then clicking the submitbutton.it should inserted in to the correct table which one i have selected in the Dropdownbox option.
[Code]....
As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
i have table called templates, when user ordered a new template then the All the values are needed to be inserted into the User Template Table
How can we do this?
SQL For this? ..........
i just create table simply like this: create table tblDemo
(
PK_intID int primary key identify(1,1),
intHits int not null
[code]...
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
View 2 Repliesmy main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replieshow can i select a record from A table and insert into B table using linq?
View 2 RepliesI have two tables - Student and Advert.
I want to do the following;
1. Student is logged into their account (session is authenticated)
2. StudentID is primary key for that table, it is a foreign key for table Advert
3. When student is logged in, they create advert
What I want is their student Id to be input into the advert table when this new advert is created. How is this possible?
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Repliesi've created one package using ssis ..
That is used for transferring the data from the tableA to tableB daily at evening..
now my problem is ..
i've huge amount of data i.e upto 2GB of data while transferring for first time
the whole amount data is transferred.. and now i want to transfer only the daily updates
i.e what data i've entered today that much only it should transfer instead of whole data (2GB)..
how to do it .
I'm trying to build an asp.net application, where I have three tables.
tblRoute
tblHalte
tblHalteRoute
I want to insert a routeID into tblHalteRoute and for every routeID multiple halteID's
TblRoute has the needed fields (routeID(1) & allHaltes[halteID1,halteID2,halteID3])
--> so Every route has multiple Haltes that I can access by parsing the allHaltes field and using the IDS.
What I want to do is update tblHalteRoute like this
tblRoute.routeID(1), tblRoute.allHaltes(halteID1)
tblRoute.routeID(1), tblRoute.allHaltes(halteID2)
tblRoute.routeID(1), tblRoute.allHaltes(halteID3)
inserting these values into the tblHalteRoute .. I'm really not sure on where to look or how to start, I tried using SUBquerys with an Insert before a select, but no success.
I want to insert a new record into a table. The table has relationships with other secondary tables, For example:
Table: Stores
Table StoreCategories (a store can have many of these)
I want to insert a new store, get its ID and insert some categories in one go.
How do I go about this?
I am trying to insert data into two table at the same time , but i'm successding in inserting data into only one table at a time on button click .
[Code]....
When i run the code, data gets inserted into table "implantDetails" only. Are multiple INSERT statments allowed?
Split String from listbox to enter data in table
[Code]....