Last Created Store Procedure SQL Server

SELECT * FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'

order by last_altered desc

Next Query

Solved : January, 2012 M4.2-R4: INTRODUCTION TO MULTIMEDIA

Multiple Choice

1.1 : C
1.2 : A
1.3 : D
1.4 : A

Get input type file size in KB

HTML

<input type="file" class="upload" onchange="readURL(this)" id="file" accept="image/x-

png,image/jpeg" />

<input type="button" value="Upload" class="btn btn-default" style="margin:auto;display:block" onclick="checksize(this)" />

Java Script

Get File Name in JavaScript:

document.getElementById('file').files[0].name

Get File Size in JavaScript:

Alter Table SQL Server

Making Unique key

Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);

2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : A

1.2 : C

1.3 : B

1.4 : C

1.5 : A

1.6 ; B

1.7 : A

1.8 : A

Jquery Preloader

Girfa Student Help

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specim

Solved July, 2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1  Multiple Choice

1.1 : D
1.2 : B
1.3 : A
1.4 : D
1.5 : D
1.6 : A

1.7 : D
1.8 : A
1.9 : D
1.10 : B

2 True/False

2.1 : T
2.2 : T
2.3 : T

January, 2014 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : B
1.2 : A
1.3 : B
1.4 : C
1.5 : B
1.6 : D
1.7 : A

HTML Tag CSS

<a> style change

    a.menu:link {color:black;}      /* unvisited link */

    a.menu:visited {color:black;}  /* visited link */

    a.menu:hover {color:#CCFF99;}  /* mouse over link */

    a.menu:active {color:yellow;}  /* selected link */

    a.menu:link{text-decoration: none} /* Hide Underline of link */

Example : <a class="menu">Link test</a>

Next Example

Setup locale date time zone

SQL server saves date in local region format, for example if you’re in india and hosting your site with godaddy and choose Asia server then your date will be 12 hour forward compare to current region.

July, 2014 M4.2- R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : C

1.2 : A

1.3 : C

1.4 : B

1.5 : C

1.6 : C
1.7 : A
Explanation : Old 2D cel animation and stop-motion animation both fall under the category of traditional animation,  both may use digital methods of filming in the end. The matters is the method of producing the animation itself. Cel animation uses hand-drawing, hand-inking, and hand-painting thousands of frames on clear cels that are displayed against painted backgrounds and photographed in rapid sequence, on the other end stop-motion animation involves working with physical models and objects captured on camera one frame at a time.

This hands-on method requires a team of artists, cleanup artists, painters, directors, background artists, and camera crews, along with the storyboard artists and scriptwriters to work out the original concepts. For large-scale projects, the amount of time, labor, and equipment involved is staggering.

1.8 : B

January 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : D
1.2 : A
1.3 : C
1.4 : A
1.5 : B
1.6 : B

July, 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : C
1.2 : D
1.3 : A
1.4 : D

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN-July-12 Solved

Multiple Choice

1.1 : A
1.2 : B
1.3 : D
1.4 : A
1.5 : A
1.6 : D
1.7 : B
1.8 : C

M2-R4 INTERNET TECHNOLOGY AND WEB DESIGN-Jan-13 Solved

Multiple Choice

1.1 : C
1.2 : C
1.3 : B
1.4 : A
1.5 : B
1.6 : D
1.7 : D
1.8 : C
1.9 : B
1.10 : D

Input type pattern

Form tag is one of the key tags of HTML through which users data are sent on server. While making a form there are lots of validation implemented to allow valid data only. As a developer we all know about importance of validation and we do lots of JS code for validation. Working with JS is not an easy task for beginner.

HTML 5 introduce built in validation using regular expression using pattern property. If you are using patter regular expression then this will save your time and it is supported by all model browsers. So using pattern, you do not to worry about browser compatibility.

Following code will help you to understand basics of pattern. Ones you will implement basics then after using regular expression you will be able to implement complicated validation rule.

Name :

Six Digit Pin :

Email :

INTERNET TECHNOLOGY AND WEB DESIGN July, 2013 Solved

Multiple Choice

1.1 : C
1.2 : B
1.3 : B
1.4 : B
1.5 : C

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN January, 2014 Solution

Multiple Choice

1.1 : D
1.2 : C
1.3 : C
1.4 : A
1.5 : A
1.6 : C

Solved July, 2014 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : B
1.2 : C
1.3 : B
1.4 : A
1.5 : C
1.6 : B

Solved July, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : C
1.2 : A
1.3 : B
1.4 : D
1.5 : C
1.6 : A
1.7 : A
1.8 : C

Solved January, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : C

1.2 : A

Explanation : Shortest Seek Time First

1.3 : D

Explanation : 

Seek time: Say you're reading some data from the (0,4). You receive instructions to read from track (2,5). The time it takes for you to move from track 0 to track 2 is seek time.

M1-R4: IT TOOLS AND BUSINESS SYSTEMS July 2011 Solution

Multiple Choice

1.1 : A
1.2 : B
1.3 : B
1.4 : A
1.5 : C
1.6 : D
1.7 : D

Paper IT Tools and Business Systems January 2011 Solution

Multiple Choice

1.1 : D
1.2 : D
1.3 : B
1.4 : A
1.5 : D
1.6 : B
1.7 : B

IT Tools and Business Systems -July-2010 Solution

Multiple Choice

1.1 : B
1.2 : B
1.3 : B
1.4 : D
1.5 : B
1.6 : A
1.7 : B
1.8 : A
1.9 : C

IT TOOLS AND BUSINESS SYSTEMS Jan-12 Solved

Multiple Choice

1.1 : B
1.2 : B
1.3 : C
1.4 : D
1.5 : C
1.6 : A
1.7 : B

July, 2012 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice

1.1 : D
1.2 : D
1.3 : D
1.4 : D
1.5 : D

Paper M1-R4: IT TOOLS AND BUSINESS SYSTEMS-jan-13 Solution

Multiple Choice

1.1 : A
1.2 : C
1.3 : B
1.4 : D
1.5 : A
1.6 : B
1.7 : D
1.8 : A
1.9 : D
1.10 : C

July, 2013 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice

1.1 : C
1.2 : D
1.3 : B
1.4 : C
1.5 : A
1.6 : D
1.7 : C
1.8 : B
1.9 : B
1.10 : C

CSS Selector

This page will help you to learn how you can user CSS on various types of HTML tag. If you have knowledge of CSS selector then you can make big changes of fo

July-2014 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Answer

Multiple Choice

1.1 : C

1.2 : B

1.3 :  D

1.4 : B

1.5 : D

1.6 : D

Image zoom inside of div

HTML

<div class="con">

<img src="1.jpg" class="test"/>

</div>

CSS

.test

{

       height:200px;

       width:200px;

Solution : July, 2015 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

Multiple Choice :

1. D
2.C
3.D
4.:A
5:C

6: B

import multiple CSS using single link

CSS file

File A1

.r1

{

       color:red;

}

File A2

.r2

{

       color:green;

}

File A3

.r2

Get Date Time (dd/mm/yyyy)

<script>

       var d = new Date();

       document.write(d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear());

Rules to declare a valid variable

List out the rules to declare a valid variable in ‘C’ program. Evaluate the following expression and show the hierarchy of operations:
( 2 + 4 ) / 3 + 2%3 * 2 – 5

Solution : 

Read List out the rules to declare a valid variable 

Expression Solve Steps

• (2+4)/3+2%3*2-5
• 6/3+2%3*2-5

Humanoid Robot MBA Project

Humanoid
Robot

Table of Content

    1. Acknowledgement

    2. Certificate

    3. Student  declaration

    4. Introduction

Structure Programming

Structure programming is a programming approach in which all the programming task is achieved through function/Methods that is sometimes it’s called modular programming. Structure programming uses procedure approach to solve a program using top down methodology. 

One big advantage of structure programming language is simplicity because we have to design programming task in modules which are connected to each other and can be called from any functions. We have all the modern powerful programming stuff like loop, switch-case, if-else etc that help to reduce the uses of goto statement because goto statement makes our program unstructured due to random move to any other statements.

While Loop with example

Q : Write and explain the action of WHILE statement. Develop a program in ‘C’ language to compute the average of every third integer number lying between 1 and 100. Include appropriate documentation.

Solution : 

While Loop

Array Input using function

A, B and C are three 3x3 matrices containing real elements. Write a ‘C’ function to input from user appropriate values into matrices A and B. Use suitable loops. Make use of pointers if necessary.

Solution : 

/*==============================

Girfa Student Help

Program : 3x3 Array input using function

More Program : http://girfahelp.blogspot.in/p/2-d-array-programming.html

================================*/

#include<stdio.h>

#include<conio.h>

#define MAX 3

void input(int [][MAX]);

void print(int [][MAX]);

HTML Sample Paper

Internet & Web Design (HTML)

Note : each Question carry one marks of part and only three question need to attempt in part two, each carry 10 marks . No negative marks penalty for wrong answer.

Name : __________________                                                                                                                   Time : 45  Minute

Part 1

Multiple Choice

1. ………. Is Self-close tag .
A) strong   B) pre   C)img   D) None

2. Each property of HTML tag is separated by
A) Double quote   B) Single quote   C) /   D)None

3.  Special character code in HTML start with ….
A) &    B)@     C)#    D)None

4.  tag doesn't usually appear in your document. But identify the page's author, keywords used for searching.
A) <head>    B) <title>   C) <meta>    D)<script>

5. Which of the following is odd one for a form.

Structure sorting,searching with array

Define a structure that describes a hotel. It should have members that include the name, address, grade, average room charge and number of rooms.

Write a function to perform the following tasks.

i) To print all hotels details of a given grade in order of charges.
ii) To print hotel details with room charges less than given values.

Solution :

/********************************

     Program : Structure sorting,searching with array

     for more program visit :http://girfahelp.blogspot.in/p/c-language-structure-programming.html

**********************************/

#include<stdio.h>

#include<conio.h>

#include<string.h>

#define MAX 10

typedef struct ht

{

     char name[30];

     char address[40];

     char grade;

     int room;

     int charge;

}hotel;

void input(hotel*,int);

void print(hotel *);

void printbyRate(hotel *,int,int);

void printByGrade(hotel *str,char,int s);

void main()

{

     int i,opt,rate;

     hotel rec[MAX];

     char ch;

     clrscr();

     printf("How many record you want to insert>> ");

     scanf("%

Get Single value from database using ajax

Store Procedure

USE [Girfa_StudentHelp]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[GetPhone]

(

   @id int

Get Data from server Using ajax

Target Audience

Beginners who are learning C# MVC and want to get record from SQL server to browser using jquery  ajax.

Store Procedure

USE [Girfa_StudentDB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter proc [dbo].[GetStudentList]

AS

BEGIN

     SET NOCOUNT ON;

           select roll,name,city from dbo.Student

     SET NOCOUNT OFF;

END

View

<input type="button" value="Get Data" onclick="GetData()"/>

<table>

    <thead>

Internet & Web design Sample paper set 2

I

Internet & Web Design

Time: 1 hour                                                                                           Name: ______________

Note: All question of part-1 is mandatory and each question is carrying one marks. 2 questions are compulsory out of 4 from part-2.

(Part one)

Multiple Choices

1.  Effectiveness of data communication is depend on

a)      Delivery   b) Accuracy   c)Timeliness   d)All

2. Which of the following is not considered as network performance criteria?

a) Performance    b) Reliability   c)Security   d) Brand

3. Application of data communication is

a) Marketing & Sales   b)Manufacturing c) EDI  d) All

Longest common sequence

Given sequences say “MNOP” and NPA”

Longest common sequence of LCS is a sequence that appears in the same relative order in both the given sequence but not necessarily in a continuous manner.

See the example

M

N

O

P

Time Complexity

O(expression) is the set of functions that grow slower than or at the same rate as expression. It indicates the maximum required by an algorithm for all input values. It represents the worst case of an algorithm's time complexity.

ROW_NUMBER SQL Server

When SQL query has been run a query for create some output then sql server track number row on per partition returned. Which you can show using row number on the basis of following example

Syntax:

SELECT ROW_NUMBER() OVER (Order by Column_name) AS RowNumber,Col1,Col2,…

FROM dbo.newadmission

Cyclic Redundancy check

CRC (Cyclic Redundancy check)

CRC is error detecting technique which is used to detect an error occurred during transmission. CRC technique used in networking, cd, dvd and many other types of memory devices. CHKDSK check disk error using CRC algorithms to find any error. 

A pattern of 0s and 1s can be represented as a polynomial with coefficient of 0 and 1. The power of each term shows the value of the bit. 

Algorithm

• Take Bit stream for transfer. 
• Divide your bit stream with a divisor which used both sender and receiver. Divisor may have any bit stream 0 or 1 but used the same for both end. 
• Divisor can also be represent using polynomial series as following rule.
  
  

Single Row Access MVC Razor

This post target when there is a need to get only single row and display them on a cshtml view.

@model Britanic_MIS.Models.CustomerModel