create a user in T-SQL

USE [My_Database]
GO
CREATE USER foouser FOR LOGIN [foo\myuser]
GO