sql-server


SQL Server Database Trigger Update different table on update


I'm trying to create a trigger on my SQL Server Database that will change the username in a table if the username changes in the User Table. I know that this is normally done by creating a relationship between the two tables to cascade the changes, but I seem to be running into the same issue as the person in this question: (Foreign key constraint may cause cycles or multiple cascade paths?). So I need to create a trigger that will do that for me, but what is confusing me is how do I get the old username value so I know what record to update in the WHERE section of the trigger?
Hopefully this wasn't to vague. Thank you.

Related Links

How to pass sql variable to like condition SQL Server 2012
Database normalization. Which is better, inserting in one row or multiple row?
SSIS - move xml files to appropriate folder depends on Conditional Split result
SQL Server query not returning expected row [duplicate]
Get count of Items by customer, along with count of records with different item types in SQL Server 2014
After apply Ms17-010 database confused [on hold]
Registered Servers for Azure SQL Databases
Azure search return parent and child records
How to identify a long-running query in the SQL Server database?
How to exclude items in Visual studio SQL schema compare based on string pattern or alternative
Dapper not updating object in database
SQL Multi-condition WHERE clause with one optional parameter?
T-SQL How to grant role to user with ADMIN/GRANT option in SQL Server 2008
SQL Server - Where CONTAINS (Field, SUBQUERY)
How to include Null value in Join?
SQL Server : sort based on current date for last 6 months

Categories

HOME
json
swift
signalr
checkbox
filterrific
angular-cli
ll
file-io
websphere-liberty
requirejs
netflix-feign
deeplearning4j
dropbox
hosts
xul
automata
opera-mini
cairo
attask
kitematic
piwik
fabric
iis-10
compare-and-swap
cell-array
jboss5.x
apache-cloudstack
read-write
geopy
data-extraction
pycparser
salesforce-chatter
transient
von-neumann
viewstate
geomesa
nodeclipse
code-composer
crop
amazon-clouddrive
archer
lumen-5.3
walmart-electrode
gist
spring-data-hadoop
chrome-remote-desktop
crystal-reports-8.5
ruby-on-rails-2
httplib2
emoticons
emgu
backstop.js
c#-interactive
galleriffic
easing
rstudio-server
foxit
scalar
spark-cassandra-connector
sun-codemodel
handlebars.java
anythingslider
getrusage
schtasks.exe
windows-vista
lmfit
rad
prezto
harp
viper-architecture
subversion-edge
adodb
sqoop2
gmaps4rails
kendo-mvvm
and-operator
scala-2.11
google-admin-audit-api
sid
factors
resource-files
java.util.date
nscolor
leptonica
digital-design
database-permissions
client-library
reporting-tools
mvccontrib
blockingqueue
cadisplaylink
legacy-code
objective-c-protocol
entity-framework-ctp5
msgbox
selectonemenu
hashalgorithm
curljs
rijndael
google-instant
winverifytrust
linfu
plinq
data-execution-prevention
hardware-infrastructure

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App