Thursday, July 30, 2015

How to compare two tables schema by SQL query in MS SQL?

How to compare two tables schema  by SQL query in MS SQL?
SELECT name,system_type_id,user_type_id,max_length,precision,scale,collation_name,is_nullable into #Tablescehma1
FROM sys.columns WHERE object_id = OBJECT_ID('TABLE1')

SELECT name,system_type_id,user_type_id,max_length,precision,scale,collation_name,is_nullable into #Tablescehma2
FROM sys.columns WHERE object_id = OBJECT_ID('TABLE2')

select * from #Tablescehma1
except
select * from #Tablescehma2

Monday, July 27, 2015

Secondary skills for software engineers

Secondary skills for software engineers
http://radek.io/2015/07/27/secondary-skills-for-software-engineers/

What are the most important skills?
1. Language(s)
2. Problem
3. Naming
4. Communication
??

Thursday, July 23, 2015

In ASP.NET Logout: GET or POST?

In ASP.NET Logout: GET or POST?

I just switch from POST to GET, and tested in Chrome, no problem found for now
Suggestion from Stackoverflow
http://stackoverflow.com/questions/3521290/logout-get-or-post