Parameters
- condition
- A new condition to add.
SqlSelectStatement stmt = new SqlSelectStatement(); stmt.Columns.Add(new SelectColumn("EMP")); stmt.Columns.Add(new SelectColumn("SAL")); stmt.Tables.Add(new SelectTable("emp")); stmt.AddHavingCondition("SAL > 1000"); //select JOB,SAL from emp having SAL > 1000 SqlCommand command = new SqlCommand(stmt.ToString());
Dim stmt As New SqlSelectStatement stmt.Columns.Add(New SelectColumn("EMP")) stmt.Columns.Add(New SelectColumn("SAL")) stmt.Tables.Add(New SelectTable("emp")) stmt.AddHavingCondition("SAL > 1000") 'select JOB,SAL from emp having SAL > 1000 Dim command As New SqlCommand(stmt.ToString)