How to import to data in TEXT to SQL Sever

Inserting large amount of data in text files (such as CSV files) to SQL server the easiest solution is using bulk insert. This considerably reduce the execution time and increase efficiency. Assumed Altitude provide a explanation on how to do the basic type of Bulk insert in this post.
The basic insert query would like this,

BULK INSERT TABLE1

FROM 'D:\test.txt'

WITH (FIELDTERMINATOR =',' , ROWTERMINATOR ='\n')

this Here the test.txt text file name and TABLE1 is where data is inserted. this just simplest form of bulk insert. This can be more complex tasks with the use of format files.

Merry Christmas

http://www.assumedaltitude.lkblog.com/2012/12/merry-christmas.html

Thambara Wila (තඹර විල)

The Student Union of Faculty of Engineering, University of Ruhuna consists of nearly 800 students. They are well talented in both academic and non-academic activities. In order to improve their talents engineering faculty Students Union has decided to organize a concert called ‘TAMBARA-WILA’ (තඹර විල) in 24th of June 2012 from 3.00 P.M. to 7.00 p.m. at the Medical Faculty Auditorium, Karapitiya.
The main objective of this concert is to present creative artistic talents of engineering undergraduates to the external parties and make close relationship with them.

How to Import data in Excel sheet to SQL Express Database using AD-HOC Query

Have you tried to get data in Excel sheet to a SQL database? Here is how to do it step by step so anyone can understand it simply. So there is no need to search anymore. This is done using AD HOC query in SQL. You can either import all the columns or selected one as you prefer.

Internship In WSO2

Romesh Malinga a CSE (Computer Science Engineering) student from University of Moratuwa is undergoing his internship in WSO2. He has started blogging about his experience gathered in this internship in wso2. Its under the URL www.iwso2.blogspot.com. This can be helpful to any one who is willing to have a internship in wso2 and anyone interested in technologies AXIS2, OSGi ect.

Electronic Switching

This a article on electronic switching that will act as short-note for students doing electronics. This is from Romesh Malinga Perera's blog Execution Cycle.
This include basic switch types and there graphical representation. Also there is a brief description about how electronic switch operates
Enter Here to see the Original article.

Temple Of Tooth (ශ්‍රි දළදා මාලිගාව)

This is Temple of tooth Relic (Sri Dhaladha Maaligawa-ශ්‍රි දළදා මාලිගාව) in Kandy Sri Lanka.

One of the main tourist attractions in Sri Lanka and the most scared place for all of Buddhists in the world. These images are from post in Assumed Altitude on Temple of tooth.