Common errors in SQL server

This post is about serval common errors in sql server.

1.login failed for user sa because the account is currently locked out.the system administrator can unlock it.(Microsoft sql server,error:18486)

solutions: execute the following command.

ALTER LOGIN sa WITH PASSWORD = 'yourpassword' UNLOCK ;

2. compare and concatenate the null value.

solutions:use isnull function.

isnull(field1,'')=isnull(field2,'')

!Attention: null+""=null

to be continued...