Thursday 6 July 2017

Java Script Date dd/mm/yyyy format

Get Java Script Date dd/mm/yyyy format

<html>
<head>
    <title>Girfa Student Help</title>
    <script>
        function GetDate()
        {
            var d = new Date();
Read more »
Posted by at No comments:

Lucas Series

Lucas Numbers similar to the Fibonacci series that often occurs when working with the Fibonacci series. Edouard Lucas (1842-1891) (who gave the name "Fibonacci Numbers" to the series written about by Leonardo of Pisa) studied this second series of numbers: 2, 1, 3, 4, 7, 11, 18, .. called the Lucas numbers in his honour. On this page we examine some of the interesting properties of the Lucas numbers themselves as well as looking at its close relationship with the Fibonacci numbers. The following page generalises further by taking any two starting values.

/* #######    Girfa Student Help ###############
      Lucas Sequesnce Program
      for more program visit : https://girfahelp.blogspot.in/p/c-language-assignment.html
  ##############################################  */
#include<stdio.h>
void main()
{
    int a,b,c;
    clrscr();
    a=1;
Read more »
Posted by at No comments:

Saturday 24 June 2017

Number to word convert

Q : Write a program to convert a number into its equivalent word without using character array?

/* ##########################################
     Girfa : Student Help
     Program : Number to word converter
     for more program visit :
   ##########################################*/
#include<stdio.h>
#include<conio.h>
void single(int);
int reverce(int);
void ten(int);
void hundred(int);
void printhundred(int);
void main()
{
Read more »
Posted by at No comments:

Thursday 22 June 2017

Looping With Cursor SQL Server

Cursor is an database object which is use when there is a need to process table record row by row . you can access each field of your table at record by record.In relational databases, operations are made on a set of rows. For example, a SELECT statement returns a set of rows which is called a result set. Sometimes the application logic needs to work with a row at a time rather than the entire result set at once. In T-SQL, one way of doing this is using a CURSOR. For example when we want to get record from one table and need to insert into another with performing some logic or some conditions .For example if we want to get value from one table row by row  and need to perform some logic over that and update /insert into another table then we can use cursors. Cursor basically works as for/While loop.

USE [Girfa_tportal]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter procedure [dbo].[GetStudentContact]
as
begin
Declare @phone as varchar(15)
Declare @email as varchar(50)

Read more »
Posted by at No comments:
Subscribe to: Posts (Atom)