General Questions About Sql Server

I asked my tutor those questions and I want to ask you too


Hi
Sir


I hope you doing fine

I
have some questions please;



What is the diffrent between For Attach in Create Database
Command and Sp_Attach_DBWhat is the diffrent between store db file in folder and store
it raw partition e.g. C:What is the useful from TextImage_On in Create Table Command; it
is order Sql Server to stor the photo in diffrent table's fileCan you give us a basic steps to insert *.JPG photo in Sql
ServerIf I have this statement:



Create Table xTable



(
UserId
Int ,

UserName
VarChar ( 3 ) ,



Email
VarChar ( 10 ) Default ( UserId + '_' + UserName )
)



Why This Code not works and how can
I do this without using Triggers.



Can you tell us the different between Media Set and Media Family
and the useful of them. Can we do Backup and Restore Commands on Virtual Tape and How?When I write this code









Create Trigger xTrig on xTable
For Insert
AS

When this trigger will fire Before
Insert, during or after.



What is the useful from EDURE in Create ProcedureWhat is the useful from Recompile in Create Procedure In Sp_AddRole how can I create this role and make the owner
anther person e.g. sa What is the different between User and LogIn in Sql ServerWhat is the different between Role and Group in Sql ServerWhy can I add user to group in Sp_AddUser and I could not add
one in Sp_AddLogin






These lies work good



-- Add
New LogIn to ProgramManagerRole





Exec Sp_AddLogIn 'zProgramManagerUser' , '' ,
'C8_Ahmad_13430_NewSIS' , 'English'
Go

Exec Sp_GrantdbAccess 'zProgramManagerUser'



Go

Exec Sp_AddRoleMember 'ProgramManagerRole' ,
'zProgramManagerUser'

Go



But Why these lines not work good and give me a
msg with an error the Role name or User Name not in the db



-- Add
New LogIn to ProgramManagerRole

Exec Sp_AddLogIn 'zProgramManagerUser' , '' ,
'C8_Ahmad_13430_NewSIS' , 'English'



Go

Exec Sp_AddRoleMember 'ProgramManagerRole' ,
'zProgramManagerUser'



Go

Exec Sp_GrantdbAccess 'zProgramManagerUser'

Go
Thank you