Posts

VB Script Basics

Vb Script tool : To Execute VB script we need not any tool all you need to write code in notepad and save it with .vbs extension .Double click the saved file to execute your code Variables :  It is container and it is used for temporary storage in VBS only way to declare variable is Dim  Syntax : Dim <Variable name> Example : Dim a,b,c a = 100 b = 200 c = 300 Note : Even though if you forget to declare variable you code will get execute . To avoid unwanted variables we need to declare Declare and Initialize Variable in single statement : We can declare and initialize variable in single statement by using " : " Syntax: Dim <Variable Name> : <Variable Name> = <Variable Value> Example : Dim a : a = 100 There are two ways to declare variable in VBs 1.Implicit declaration Ex : a = 100 2.Explicit declaration Ex : Dim a a = 100 Option Explicit : To avoid undeclared variables in code we use option explicit S...

Sql Basics With Examples

Image
Sql Basics with example :                                                                      Chapter 1 Database A database is the place of storage of the data in the form of tables Data means information which is very useful. A database is also collection of 1 or more tables. Table – a table is a collection of rows and columns. A cell is an intersection of a row and a column A column is also called as a field / attribute A record is also called as a row / tuple. A table is also called as an entity / relation. Note :- ·          If we install any of the database related software(s) – we can create our own database, we can create our own tables and we can store the data inside it. ·     When we install any database s/w(s) –...