How to maintain a fill factor in existing indexes?
Write an sql query to find the names of employees start with ‘a’?
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?
What is the difference between count () and rowcount ()?
What are a database and a data warehouse?
How send email from database?.
3 Answers CarrizalSoft Technologies, Merrill Lynch,
Can we do dml on views?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
UPDATE statement can on a single table or on the multiple table?
How to send email from database?
What are different type of Collation Sensitivity?
What is the significance of null value and why should we avoid permitting null values?
Explain what are the events recorded in a transaction log?