Can triggers stop a dml statement from executing on a table?
No Answer is Posted For this Question
Be the First to Post Answer
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How do you take the union of two tables in sql?
How to return multiple records from procedure?
How to order siblings in oracle hierarchy queries?
What is mutating error?
Explain mutating table error.
how to check myisam tables for errors? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
How many subqueries can be nested in a statement?
SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.
Is left join inner or outer?