Posts

Showing posts from November, 2023

Visual Basic 10 program for beginner students

 Visual Basic 1. write a program to print "Hello World" in Visual Basic.     Module Module1         Sub Main ()             Console. WriteLine ( "Hello, World!" )         End Sub     End Module     Module Module1         Sub Main ()             Console. WriteLine ( "Hello, World!" )         End Sub     End Module 2. write a program in visual basic to use variable and input method.     Module Module1         Sub Main ()             Dim name As String             Console. Write ( "Enter your name: " )             name = Console. ReadLine ()             Console. WriteLine ( "Hello, " & name & "!" )         End Sub     End ...

Database SQL

SQL Database 1. How can we create a table in SQL "Employee" table: 1. CREATE TABLE Employee: This is the beginning of the SQL statement. It instructs the database to create a new table named "Employee." 2. (EmpId smallint IDENTITY(1, 1) PRIMARY KEY:  This part defines the first column of the "Employee" table. EmpId:** This is the name of the column, representing the employee's identification number. smallint:** This is the data type of the column. It's used for small whole numbers. IDENTITY (1, 1):** The "IDENTITY" property is applied to this column, which means it will automatically generate unique values. The two numbers in parentheses indicate that the values will start at 1 and increment by 1 for each new record. PRIMARY KEY: This constraint is added to the column to ensure that each value in this column is unique, serving as a unique identifier for each employee record. 3. EmpName VARCHAR(50): ** This line defines the second column ...