sql server - column update without using trigger -

-

SCENARIO:

मेरे पास दो टेबल हैं, टेबल 1 (कॉल 1 डेट) और टेबल 2 (कॉल 2 varchar (20 ))।

आवश्यकता:

जब भी कोई भी कॉल 2 में मान को अपडेट करता है, तो आज की तारीख को कॉल 1 में डाला / अपडेट किया जाना चाहिए। यह ट्रिगर्स का उपयोग किए बिना किया जाना चाहिए।

अब, मैं ऐसा करने के लिए संभव कुछ भी नहीं सोच सकता। इसलिए, मुझे आपकी मदद की आवश्यकता है; कृपया।

धन्यवाद।

यह उपयोग किए बिना स्वचालित रूप से नहीं किया जा सकता चलाता है। तालिका 1 को अपडेट करने के लिए आपको मैन्युअल रूप से एक स्टेटमेंट चलाने की आवश्यकता है अपडेट तालिका 2 चलाना और एक लेनदेन के अंदर टेबल 1 स्टेटमेंट को अपडेट करना आप अपने डेटा की अखंडता सुनिश्चित कर सकते हैं।


Comments

Post a Comment

Popular posts from this blog

ios - Form Sheet content disappearing -

-
Image
I am trying to apply a form sheet. Looks like this on the storyboard: App background only when I run Appears and everything else is hidden. I am presenting a form sheet using model sheets - I am working with the form sheet and I (WREGLR Regular) size. Why is this happening?
Read more

Lists in scheme -

-
I am trying to write a function in the plan that takes every item list and class in the list, then returns the list As is (list xyz) . However, I'm not sure how to write a code that would do this. So far, I have (defined (category = list list) (cond [(empty? List) false) [and (list (SQL) (first A-list)) (Square-list) (The rest is a list)))]) but it returns to the list (cons y (cons z empty)) What can I do to return it to the list only in (list xyz) ? Thanks! You're almost there - make sure you type cons and List (The text book explains this section 13. You can find copies online). Conflict The first element for the 'rest' part and (usually) one (potentially empty) list as an example, (Opposition 1 blank) Number 1 as its first element and the empty list is in the form of 'rest' (Opposition 1 (Opposition 2 Empty)) No. 1 before Element, and (Opposition 2 empty) is in the form of 'rest'. List is just a simple shorth...
Read more

List View in C# -

-
I have a ListView in my C # and I want to select an item based on the number I give . Is it possible? Example: If my list adds, multiplied and divides as elements in the list, so if I give 2, then it has to be multiplied. All this should be programmatically If this is ListItem value 2 - I just had to go with it: _listView.SelectedValue = "2"; Or maybe more correct: _listView.SelectedValue = _input.ToString ();
Read more