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.
How is MyISAM table stored?
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.
Define the Synonyms in Structure Query Language.
Illustrates architecture of SQL Server Notification services?
What are Union, Intersect and Minus?
Illustrates the term External Key Management in SQL server 2008?
What is the difference between BLOB and TEXT?
How would you enter Characters as HEX Numbers?
Illustrates the JOIN commands?
18,76,764
1946361 Asked
3,689
Active Tutors
1454602
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!