Differences

This shows you the differences between two versions of the page.

--- bizweaver:sql [2024/09/24 15:35]
dlee [Command Types]
+++ bizweaver:sql [2024/09/24 15:37] (current)
dlee [SQL Tips]
@@ Line 65: / Line 65: @@
-{{ :bw2:bizweaversqltool2.png |}}
 =====Stored Procedure (SQL Server only) =====
@@ Line 80: / Line 79: @@
-====== User Notes ======
+===== User Notes =====
   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.
@@ Line 88: / Line 87: @@
  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>
-====== SQL Test Run Option ======
+===== SQL Test Run Option =====
 Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement.
@@ Line 111: / Line 110: @@
 </WRAP>
-====== SQL System Variables ======
+===== SQL System Variables =====
 ^ Name           ^ Description         ^
@@ Line 124: / Line 123: @@
-======SQL Tips======
+=====SQL Tips=====
   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**

Wiki