Monday, February 22, 2016

Maximise speed of Oracel input componenet



Hello,
We can maximize data reading speed in Oracle input by using Use cursor option,
I've checked with 65,000 and its working very fast.

Please let me know if any problem :)




Tuesday, February 16, 2016

How to see table columns in MS SQL SERVER


How to see table columns in MS SQL SERVER
select * from information_schema.COLUMNS where TABLE_NAME='employee'