Creating Login Users and Bind With Database User in MSSSQL

1)Add Login user to master db:
(To perform this operation, you need a valid login account information that can access master db)


CREATE LOGIN [AdminLogin]
WITH PASSWORD='XYZ'


2)Bind login user with db user:
(a default schema can also be used in the query)

CREATE USER AdminUser

FOR LOGIN AdminLogin

3)Giving insert,update permission to binded user:
(db_owner can be the best option for this)


EXEC sp_addrolemember N'db_owner', N'AdminUser'

NOTE:One login user can be used for many database users but for one database multiple users cannot be bind to same login user.

Ultimate Debugging Guide for xCode

I will update this post whenever I learn a new debugging technique.

1)Watchpoint: Keep track of a variable. With execution of the program paused at a breakpoint, select the variable in the Variable list in the Debugger window. You need to open variable list while debugging. Run > Variables View > Watch Variable

2)Memory Browser:Watch the memory while debugging. Run > Show > Memory Browsers

3)Fix: xCode allows to modify code while debugging with certain restrictions. After modification, Run > Fix. Look Apple Official Docs for more information...