calculate the volume through function.ģ5. Write a c program to show the use of static variable.ģ4. Write a program to differentiate local and global variable.ģ3. Write a program to swapping of two number using call by value and call by reference.ģ2. Write a program to demonstrate the command line argument.ģ1. Write a program in c to perform maths and character library function using switch case.ģ0. Write a c program to following pattern:Ģ7. Write a c program to following pattern:Ģ6. Write a c program to the following pattern:Ģ5. Write a c program to following pattern:Ģ4. Write a program in c to check Armstrong no.Ģ3. Write a program to convert decimal to binary.Ģ2. Write a program in c to check whether the no is prime or notĢ0. Write a program to find Fibonacci series upto n termsġ9. Write a program in c using goto statementġ8. Write a program in C to print sum of odd no between 0 to 10 using continue.ġ7. Write a program by using switch case if user enter 11 it will have are area of circle and when user enter 22 it will have area of rectangle and when user enter 33 it will give area of square when user enter 44 it will give area of triangle.ġ6. Write a program to print multiplication table of given number. Write a program in C to read any Month Number in integer and display Month name in the word.(using switch case)ġ4. On the basis of percent provide grade like:ġ3. Write a program to take input of 5 subject. Write a program to find largest among three no using nested if statement.ġ2. Write a program to find even and odd no by using if else statement.ġ1. Write a program to check whether enter year is leap or not(if …else)ġ0. Write a program in c for increment and decrement operator.ĩ. Write a program in c to convert the temperature centigrade into Fahrenheit.ĬONDITIONAL AND BRANCHING STATEMENT LOOPS:Ĩ. Write a program to use of bitwise operator (left shift and right shift).ħ. Write a program to compare two no by using of ternary operator in c.Ħ. Write a program to find the average of three numberĥ. Write a program to find the average of three numberĤ. Write a program to calculate the simple interestģ. Write a program in which to declare all data type like integer ,double, float, long int and print value in specified formatĢ. SQL can set permissions on tables, procedures, and viewsĪlthough SQL is an ANSI/ISO standard, there are different versions of the SQL language.1.SQL can create stored procedures in a database.SQL can create new tables in a database.SQL can execute queries against a database.In 1986, and of the International Organization for Standardization (ISO) in SQL became a standard of the American National Standards Institute (ANSI).SQL lets you access and manipulate databases.SQL stands for Structured Query Language.SQL is a standard language for accessing and manipulating databases. String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION SQL Server Functions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |