Class Query
SQL Server Query class
Inherited Members
Namespace: DataTables.DatabaseUtil.Sqlserver
Assembly: DataTables-Editor-Server.dll
Syntax
public class Query : Query
Constructors
| Improve this Doc View SourceQuery(Database, String)
Create a query instance specifically for SQL Server
Declaration
public Query(Database db, string type)
Parameters
Type | Name | Description |
---|---|---|
Database | db | Host database |
System. |
type | Query type |
Methods
| Improve this Doc View Source_BuildLimit()
Create LIMIT / OFFSET for SQL Server 2012+. Note that this will only work with SQL Server 2012 or newer due to the use of the OFFSET and FETCH NEXT keywords
Declaration
protected override string _BuildLimit()
Returns
Type | Description |
---|---|
System. |
Limit / offset string |
Overrides
| Improve this Doc View Source_Exec()
Execute the SQL command
Declaration
protected override Result _Exec()
Returns
Type | Description |
---|---|
Result | Result instance |
Overrides
| Improve this Doc View Source_Prepare(String)
Bind parameters to the SQL statement
Declaration
protected override void _Prepare(string sql)
Parameters
Type | Name | Description |
---|---|---|
System. |
sql | SQL command |