Pages

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