In the SELECT statement, the FROM clause is required except when the select list contains only constants, variables, and arithmetic expressions (no column names). Useful resources, FROM
productChanges = productInfo.GetChanges(DataRowState.Detached)
productChanges = productInfo.GetChanges()
Useful resources, DataSet.GetChanges Method
You are creating an ASP.NET application that will record each customer's entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty Web servers. As customers enter information into your application, maintaining state information will be important. This information should be stored securely and should be capable of being restored in the event that a Web server is restarted. Customers will enter data into three separate pages in your application.
Only the SQL Server data will remain save after restarting the server.
Select the correct option:
Query 2 will return an error
Both the queries will return the same set of records
Query 2 is perfectly correct
Query 2 would return one record less than Query 1
select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
In the sub query, '*' should be used instead of 'OrderID'
The sub query can return more than one row, so, '=' should be replaced with 'in'
The sub query should not be in parenthesis
None of the above
select * from orders where sum(amount) > 20000
select * from orders where sum(amount) > 20000 order by OrderDate
select * from orders group by OrderDate having sum(amount)>20000
select * from orders group by OrderDate where sum(amount) > 20000
Useful resources, HAVING clause
STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATETIME END_DATE DATETIME
The aggregate functions valid on the START_DATE column are:
Useful resources, Use Aggregate Functions
Marketing, Designing, production, Packing
What will be the result of the following query?
select * from table where department < 'marketing';
The query will return "Designing, Packing"
The query will return "Designing, production, Packing"
The query will return "packing"
Strings cannot be compared using < operator
The query will return "Designing"