sql server 数据库小技巧记录

1.数据库还原后，数据库用户名的问题

exec sp_change_users_login 'AUTO_FIX', 'userloginname'

 

2.--  c.provincecode and m.provincecode  use different  Collate

 

--  c.provincecode and m.provincecode  use different  Collate
select c.cityname, m.description as provincename,c.provincecode,c.citycode  
from city c inner join    province m on c.provincecode Collate Database_Default  = m.provincecode 

 

 

 

3.

 

4.