By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
id | name | quantity | delivery | status |
---|---|---|---|---|
1 | Omer | 124 | 2022-10-18 00:00:00.000 | 0 |
2 | Jacob | 548 | 2022-11-05 00:00:00.000 | 0 |
4 | Hans | 548 | 2023-11-01 00:00:00.000 | 0 |
(No column name) |
---|
Hello, Omer todays order quantity 124 this order must be sent by the latest 18.10.2022. |
Hello, Jacob todays order quantity 548 this order must be sent by the latest 05.11.2022. |
Hello, Hans todays order quantity 548 this order must be sent by the latest 01.11.2023. |
Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
select name,quantity,format(delivery,'dd.MM.yyy') as [delivery] from message where status=0
(No column name) |
---|
replace(@template,'{{id}}',id) |
replace(@template,'{{name}}',name) |
replace(@template,'{{quantity}}',quantity) |
replace(@template,'{{delivery}}',delivery) |
replace(@template,'{{status}}',status) |
id | (No column name) |
---|---|
1 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
1 | Hello, Omer todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
1 | Hello, {{name}} todays order quantity 124.00 this order must be sent by the latest {{delivery}}. |
1 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 18.10.2022. |
2 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
2 | Hello, Jacob todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
2 | Hello, {{name}} todays order quantity 548.00 this order must be sent by the latest {{delivery}}. |
2 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 05.11.2022. |
4 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
4 | Hello, Hans todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}. |
4 | Hello, {{name}} todays order quantity 548.00 this order must be sent by the latest {{delivery}}. |
4 | Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 01.11.2023. |