Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged update



« Prev 1 Next »
This will create a table, create an update trigger to add current datetime to modify_date field, do 2 inserts, 1 update and display the results.
0 139 posted 7 years ago by kidmizere
SQL update examples using joins
1 104 posted 7 years ago by ed_trench
The inner join could be nested too
0 130 posted 9 years ago by preasha
0 100 posted 9 years ago by icebob
0 111 posted 9 years ago by lostumbrellas
To start my new post area I will share a simple stored procedure that will check if a record exists, if so update it, otherwise create it; Simple hum?! Just Update it to your needs :)
0 104 posted 9 years ago by Whiteagle
2 124 posted 10 years ago by ChrisCantley
This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.
2 147 posted 10 years ago by emregulcan
1 101 posted 11 years ago by thomasvdb
0 91 posted 11 years ago by ginoplusio
Wenn ein INSERT einen doppelten Wert erzeugen würde, wird das UPDATE ausgeführt.
1 93 posted 12 years ago by drk
4 138 posted 12 years ago by wolfie
Small query to help you relocate those modules you are not using anyways.
2 129 posted 12 years ago by torkil
« Prev 1 Next »