Explain about Character Functions
Explain about Character Functions.
Expert
Character Functions:
They are INITCAP, LOWER, SUBSTR, UPPER and LENGTH. Extra functions are GREATEST and LEAST. Group Functions returns effects based on groups of rows quite than one result per row, use group functions. Group functions are COUNT, AVG, MAX and MIN and SUM.
Give the advantages of MySQL in comparison to Oracle?
Explain about the sparse columns of sql server 2008.
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
In MySql table how many TRIGGERS are allowed?
Explain about the Commit.
Illustrates the JOIN commands?
What are the requirements for Hot Add CPU?
What are Union, Intersect and Minus?
Explain about a linked server?
What are the new capabilities of SQL server 2008 for persisting BLOB data?
18,76,764
1954174 Asked
3,689
Active Tutors
1433599
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!