[DiscordArchive] wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
[DiscordArchive] wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
Original source
wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
rektbyfaith
10-25-2023, 02:22 PM #1Archived author: IDUnknown • Posted: 2023-10-25T14:22:42.369000+00:00
Original source
wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
Original source
I did not design the TSQL syntax, I just live by it.
rektbyfaith
10-25-2023, 02:22 PM #2Archived author: Abillister • Posted: 2023-10-25T14:22:57.036000+00:00
Original source
I did not design the TSQL syntax, I just live by it.
Original source
lol
rektbyfaith
10-25-2023, 02:23 PM #3Archived author: IDUnknown • Posted: 2023-10-25T14:23:02.725000+00:00
Original source
lol
Original source
But I can assure you (I spend a LOT of time in MSSQL) that the formating is correct. MySQL and MSSQL have some differences but generally speaking the "transact SQL" (tSQL) is pretty interchangable.
rektbyfaith
10-25-2023, 02:23 PM #4Archived author: Abillister • Posted: 2023-10-25T14:23:47.491000+00:00
Original source
But I can assure you (I spend a LOT of time in MSSQL) that the formating is correct. MySQL and MSSQL have some differences but generally speaking the "transact SQL" (tSQL) is pretty interchangable.
Original source
you literally made me *ALMOST* spit coffee out my nose. THat was a good chuckle
rektbyfaith
10-25-2023, 02:23 PM #5Archived author: IDUnknown • Posted: 2023-10-25T14:23:49.208000+00:00
Original source
you literally made me *ALMOST* spit coffee out my nose. THat was a good chuckle
Original source
will UPDATE item_template
SET bonding = 2
WHERE bonding = 1
rektbyfaith
10-25-2023, 02:24 PM #6Archived author: IDUnknown • Posted: 2023-10-25T14:24:37.030000+00:00
Original source
will UPDATE item_template
SET bonding = 2
WHERE bonding = 1
Original source
apply to everything?
rektbyfaith
10-25-2023, 02:24 PM #7Archived author: IDUnknown • Posted: 2023-10-25T14:24:44.139000+00:00
Original source
apply to everything?
Original source
It will apply to everything that currently has a 'Bonding = 1'
rektbyfaith
10-25-2023, 02:25 PM #8Archived author: Abillister • Posted: 2023-10-25T14:25:04.089000+00:00
Original source
It will apply to everything that currently has a 'Bonding = 1'
Original source
Damn wife is nagging me ... Off to do my man chores. Doesn't she know I am doing something super important right now?
rektbyfaith
10-25-2023, 02:25 PM #9Archived author: IDUnknown • Posted: 2023-10-25T14:25:20.860000+00:00
Original source
Damn wife is nagging me ... Off to do my man chores. Doesn't she know I am doing something super important right now?
Original source
gah ...
rektbyfaith
10-25-2023, 02:25 PM #10Archived author: IDUnknown • Posted: 2023-10-25T14:25:32.138000+00:00
Original source
gah ...
1 Guest(s)
1 Guest(s)