Interested to Buy Any Domain ? << Click Here >> for more details...
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
4 12312sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8428Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
IBM,
6 10686Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
4 20055What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
ABC,
1 3151
What are sql functions? Describe the different types of sql functions?
What is the difference between drop and truncate commands?
What does the hierarchical profiler does?
What is where clause in sql?
what is the difference between delete and truncate commands? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Why is a primary key important?
What is a database event trigger?
Is it important to partition hard disk?
Explain unique key in sql.
Can we join more than 2 tables in sql?
What is record in pl sql?
Can we use pl sql in sql server?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are the qualities of 2nf?
