| Table of Contents |
|---|
Advanced functions allow you to filter results and/or get user input to add to your find.
...
| Paste code macro | ||
|---|---|---|
| ||
SELECT dbo.localizedate(DateTime, 'ZipCode'); |
Change DateTime to the datetime needing to be localized, and ZipCode to the zip code to use to determine the timezone for localizing the datetime value. Using the statement above will result in a YY-MM-DD hh:mm:ss.s. For example, the date output would be 2020-09-04 17:17:20.887.
...
Example 2
Return the current X Dispatch Operations App user.
| Paste code macro | ||
|---|---|---|
| ||
DECLARE @User VARCHAR(20)
SET @User = '{{UserID}}'
SELECT @User |
...
| Expand | ||
|---|---|---|
| ||
"ÆÆ" (ALT + 1 + 4 + 6)x2 - Placing this string in the front of a query will allow for Inserts into tables, dropping columns and tables, etc. "ææ" (ALT + 1 + 4 + 5)x2 - This has the same functionality as "ÆÆ", but the string is removed from the query once the query is run.
|
...