Posts

Showing posts from 2013

Top 20 SQL Interview Questions & Answers

-
SQL  is a language for accessing and manipulating database standardized by ANSI. To be successful with database-centric applications (which includes most of the applications Data Warehousing domain), one must be strong enough in SQL. In this article, we will learn more about SQL by breaking the subject in the form of several question-answer sessions commonly asked in Interviewes. SET UP OF SAMPLE DATA FOR PRACTICING SQL For the purpose of our demonstration, we will primarily use two database tables with just a few records - EMPLOYEE table and DEPT table. EMPLOYEE table will contain 10 records pertaining to 10 employees with funny sounding names of an imaginary organization and DEPT or Department table will contain 5 departments of that organization.  Click here to download  the DDL/INSERT statements for this data if you want to practice the below SQLs in your personal computer Contents of these tables are not same with Oracle emp and dept tables!! What is ...
Post a Comment
Read more

Asp.Net: insert images into database and how to retrieve an...

-
Asp.Net: insert images into database and how to retrieve an... : insert images into database and how to retrieve and bind images to gridview using asp.net save and retrieve images from database using c#...
Post a Comment
Read more

INSERT IMAGE INTO MS SQL DATABSE USING ASP.NET

-
Here i am posting both design view and cod behind......... 1.Design Side Code <%@ Page Language="C#" AutoEventWireup="true" CodeFile="AccessUpload.aspx.cs" Inherits="AccessUpload" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <style type="text/css"> body{font-family: tahoma;font-size: 80%;} .row{clear: both;} .label{float: left;text-align: right;width: 150px;padding-right: 5px;} </style> </head> <body> <form id="form1" runat="server"> <div> <div class="row"> <span class="label"><label for="FirstName">First Name: </label></span> <asp:TextBox ID="FirstName...
Post a Comment
Read more

30 tally erp 9 manual pdf free ebook

-
30 tally erp 9 manual pdf free ebook download from s3.amazonaws.com
12 comments
Read more

Server control and HTML control.

-
 Explain the difference between Server control and HTML control. Answer: Server events Server control events are handled in the server whereas HTML control events are handled in the page. State management Server controls can maintain data across requests using view state whereas HTML controls have no such mechanism to store data between requests. Browser detection Server controls can detect browser automatically and adapt display of control accordingly whereas HTML controls can’t detect browser automatically. Properties Server controls contain properties whereas HTML controls have attributes only.
Post a Comment
Read more

components of web form in ASP.NET

-
 Explain the components of web form in ASP.NET Answer: Server controls The server controls are Hypertext Markup Language (HTML) elements that include a runat=server attribute. They provide automatic state management and server-side events and respond to the user events by executing event handler on the server. HTML controls These controls also respond to the user events but the events processing happen on the client machine. Data controls Data controls allow to connect to the database, execute command and retrieve data from database. System components System components provide access to system-level events that occur on the server.  Describe in brief .NET Framework and its components. Answer: .NET Framework provides platform for developing windows and web software. ASP.NET is a part of .Net framework and can access all features implemented within it that was formerly available only through windows API. .NET Framework sits in between our application progra...
Post a Comment
Read more

NATURE

-
Image
Post a Comment
Read more

CHILD

-
Image
Post a Comment
Read more
-
Great ability develops and reveals itself increasingly with every new assignment.
Post a Comment
Read more
-
Ability will never catch up with the demand for it.
Post a Comment
Read more

Interview Question & Answer

-
Image
SQL SQL JOIN The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. Tables in a database are often related to each other with keys. A primary key is a column (or a combination of columns) with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table. Eg.  SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name The SQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order. SQL UNION Syntax SELECT column_name(s) ...
Post a Comment
Read more