web stats analysis

Archive for March 9th, 2013

A Project with an output type of Class Library cannot be started directly

Follow below steps 

1. Right click on your project.

2. And click on Set as StartUp Project

3. Now run your project

 

Sql query for change datatype of a column

How to change the data type of a column with query?

Change the data type of a column with query?

Changing the datatype of a Column

SQL Query to modify a column datatype lenght

Solution

ALTER TABLE table_name
ALTER COLUMN column_name datatype

Example 

ALTER TABLE tbl_customer
ALTER COLUMN First_Name nvarchar(50)