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.
Explain about the Distributed Query in the SQL Statement.
Explain about the plan freezing in SQL server 2008.
Describe the Hot Add CPU in sql server 2008.
Define the Notification services.
Illustrates the working of Notification Services?
Illustrate the SQL Deadlock in Structure Query Language?
Define the Synonyms in Structure Query Language.
What are included in SQL Server 2008 for automatic auditing?
Illustrates the term Distributed Queries?
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.
18,76,764
1923660 Asked
3,689
Active Tutors
1419325
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!