dotnet365.Com

SQL Truncate Table

admin — Sun, 01 Jan 2012 17:17:21 +0000

The SQL Truncate Table command do delete the rows from a database table. And the SQL Truncate table syntax is below:

Truncate Table Student

Here Truncate is same as Delete command which do not have the Where Condition and tow statements are as follows..

Truncate Table Student

Delete from Student

We can use the Truncate Command when we need to delete all the rows in the table.

SQL Delete

admin — Sun, 01 Jan 2012 02:54:14 +0000

The SQL Delete command is used delete the data from the database table. The easy and simple SQL Delete command syntax will look like this

DELETE FROM TABLENAME

The above mentioned SQL Command will delete the data from the TableName

DELETE FROM EMPLOYEE WHERE DEPARTMENT = “MECHANICAL”

SQL Update

admin — Sat, 31 Dec 2011 08:58:19 +0000

SQL Update command used update the data in database table. The SQL Update basic syntax will look like this

Update TableName SET ColumnName1 = Value1, ColumnName1 = Value2,…

Please find the SQL Update Syntax

Update EmpTable SET DepartmentName = “ComputerTechnology”

SELECT DISTINCT

admin — Fri, 30 Dec 2011 17:30:43 +0000

SELECT command The syntax is as follows:

SELECT DISTINCT “columnname” FROM “TableName”For example, to select all distinct stores in Table Department Table Department

Select distinct Emp_Dept from Deptartment

Result:

IT Department HR Department Finance Department

SQL Where

admin — Fri, 30 Dec 2011 17:25:18 +0000

If we want to select data from table with conditionally

The syntax is as follows..

SELECT “columnname” FROM “TableName” WHERE “condition”

Table Employee

SELECT Emp_Name FROM Employee WHERE Salary > 10000

Result:

Mahesh

SQL Select Into

admin — Fri, 30 Dec 2011 16:30:31 +0000

SELECT Column1, Column2, Column3,
INTO Table_Name
FROM TableActual

(OR)

SELECT *
INTO Employee_Table
FROM Employee

SQL Select

admin — Fri, 30 Dec 2011 16:21:02 +0000

SQL Tutorial – To Study SQL
SELECT Column1, Column2, Column3,
FROM Table_Name

(OR)

SELECT *
FROM Table_Name

What is architecture ? 2/3 Tier explain

admin — Fri, 02 Dec 2011 14:57:47 +0000

What is architecture ? 2/3 Tier explain

(OOP’s)Object Oriented Programming in .Net

admin — Fri, 02 Dec 2011 14:50:41 +0000

What is address used in WCF? and transport schema are in WCF?

admin — Mon, 28 Nov 2011 17:51:46 +0000

Address is a way of letting client know that where a service is located.
Address is used to find the service is located
In WCF, each service is associated with a unique address.
This will refers to location of the service and transport schemas.
Here below transport schemas mentioned which is used to support the WCF
HTTP
TCP
Peer network
IPC (Inter-Process Communication over named pipes)
MSMQ