Sql on update no action

The code is working fine when the table has primary key associated. However due to some restrictions I will not be able to have a primary key for some tables.

I want to implement the same trigger in those tables too. When there is primary key, that primary key needs to get inserted into the audit table and if there is no primary key, i want a specific column value to get inserted instead of the primary key value into the audit table. For example, i have a student table in which there is a student id, name, dob. So when i update the name or dob, i need the student id to get inserted into the Pk column of the audit table.

I tried modifying the code by checking the pkcols for Null and if its null to get the old value as the primary key however I was not able to do it. Net application. Is it possible to expose the above action in a report generated using reporting services?

Thanks in advance, Arun. Hi guys,I wanna ask bout the problem with my web application. I'm doing a select a statement from table 1 and and with the query results i got, i need it to store the result on table 2. How will i do this? I need your tips and suggestions. If there isn't one directly below the parent category, the parent category is dropped from the list. Hi All, I have a situation where there are two tables Negotiation and Rubrics. A single negotiation can have N number of Rubrics.

Hence it has Primary Key - Foreign Key relationship. Now I am using two different updatable recordset, to make changes from the form. The problem is with the close button we have in Negotiation Form.

For example, a user says create negotiation and fills in d details in the Neg form, and adds several rubric to it which opens a seperate rubric form. When each rubric is created and comes back to negotiation form, the record is actually updated in the database from the recordset. Since Rubric is a different recordset. Now, When i say close from the Negotiation Form.

The changes should not be committed or in other words, no changes should be committed, generally its should be rolled back to the original state.

Since all the rubric info is already in the database, this is a problem. Please suggest us how this can be implemented. Thanks in advance. Greetings - I have a report which contains quite a few parameters for user input. This has been done via the parameter order. Is this functionality currently supported? Fortunately most of my batch loads do not use the job scheduler but run by way of DOS batch scripts. When I went to restart the Service I noticed that in the properties for the Services for all the SQL Server services that in the recovery tab that the First Failure, Second Failure and Subsequent failures were all defaulted to "take no action".

My question is what should they be set to "Restart the Service"? I searched MSDN and the web and didn't find anything on this subject. Is there any harm is setting them all to "Restart the Service"? This leads me to wonder why wouldn't they be defaulted to "Restart the Service". Thanks, DaveK. Hello Is it possible to create a trigger with multiple actions? Could somebody please confirm if the syntac in this multiple action trigger is ok.

Hello all, I've run into a situation which I'm not sure which option to use. I have a web-based app that needs to send an email to a user once an auction has ended the user being the winning bidder. The backend of the app is SQL Third, specify the name of the parent table to which the foreign key references and a list of comma-separated columns that has a link with the column in the child table. The foreign key constraint ensures referential integrity. It means that you can only insert a row into the child table if there is a corresponding row in the parent table.

Michael Berkowski Michael Berkowski k 42 42 gold badges silver badges bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.