score:4
This is the syntax used in your specific program (Datazen Dataview) to substitute parameters.
So what you're seeing are that the SQL variables @prmFromDT
and @prmToDT
are being filled with parameters.
Reference:
In previous versions of Datazen, all parameter substitution was done inline. This necessitated the use of quotes to wrap string values (ex. WHERE x = '{{ @Xvalue }}'). While this is still the case for non-DB connections types, it is advised not to do so for DB types. While DB types will automatically unwrap the quotes from around a parameter if the parameter is the only text contained within the quotes, if any other text is present, the query will surely fail. For example, while the above example evaluates to "WHERE x = @p1" something like "WHERE y = 'P001-{{ @Yvalue }}'" will evaluate to "WHERE y = 'P001-@p1'" which is clearly not proper SQL parameter syntax.
Source:
Also reference on how to use parameters in datazen and the resulting syntax: https://christopherfinlan.com/2015/06/10/how-to-enable-user-activity-reporting-on-your-datazen-dashboards/
More questions
- Double curly braces on SET operation sql
- Azure SQL Server firewall not allowing operation to connect even though option is set to yes in firewall settings
- Is there a way to aggregate a variable range of dates in SQL using a SET operation
- Invalid Operation Exception when trying to get decimal value from SQL into double
- Can SQL Server perform an update on rows with a set operation on the aggregate max or min value?
- SQLSTATE[01003]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation
- SQL set operation to update table based on values on another table
- How to set variable from a SQL query?
- What represents a double in sql server?
- How do I set a column value to NULL in SQL Server Management Studio?
- SQL Server loop - how do I loop through a set of records
- How can I set an SQL Server connection string?
- A strange operation problem in SQL Server: -100/-100*10 = 0
- How do you check if IDENTITY_INSERT is set to ON or OFF in SQL Server?
- set default schema for a sql query
- How do you set autocommit in an SQL Server session?
- Add a row number to result set of a SQL query
- sql set variable using COUNT
- Which sql server data type best represents a double in C#?
- Convert SQL Server result set into string
- How do I set a column in SQL Server to varchar(max) using ASP.net EF Codefirst Data Annotations?
- SQL Server, How to set auto increment after creating a table without data loss?
- Set a existing column of MS SQL table as NOT NULL
- Getting warning: Null value is eliminated by an aggregate or other SET operation
- how to set the query timeout from SQL connection string
- IDENTITY_INSERT is already ON for table 'X'. Cannot perform SET operation for table 'Y'
- How to set the default schema of a database in SQL Server 2005?
- SQL Server : set a variable in CASE statement
- SQL Server - use a parameter to select the top X of the result set
- Curly braces in T-SQL
More questions with similar tag
- How to write value based on combination of other values
- How to determine the primary key for a table in SQL Server?
- Which paging method (Sql Server 2008) for BEST performance?
- How do i prevent Linq from adding a GUID so that SQL server can do it?
- SQL Maintenance Plan - End Task
- Database inserts slow down the larger the table gets
- multi-part identifier could not be bound on where clause
- Microsoft Sync Framework - Performance and scalability
- query sql server - error when grouping fields
- How to create a database trigger with ADO.NET
- Should NULLS be handled in code or in the database? Advantages and Disadvantages?
- SQL only allow foreign keys where other column matches
- SQL MIN_ACTIVE_ROWVERSION() value does not change for a long while
- Stored procedure / view accesses another db on same server (security issue)
- SQL summary row after details
- Linq to sql - DateTime to Time
- How to execute multiple SQL files in one transaction in Azure?
- Generate new GUID in SQL Server if one is not provided
- SQL Server 2005 Group by alias
- Deferrable Constraints in SQL Server
- Use offset and fetch with case in MS SQL server
- Stored procedure using table with recipients
- retrieving sql data from each nth row only
- cannot use alias in ROW_NUMBER() over in SQL Server?
- SqlException.Number one value but two different documentations. How?
- Develop Locally on SQL Server 2005 then Deploying to Shared Hosting
- Transition of SQL Server's Login/User concept to Oracle
- Mixing an IF-statement in an UPDATE statement in SQL
- MSSQL Schema Compare by T SQL
- FluentMigrator - Check if Foreign Key exists before deleting it