I Change the language for the database in Sql Server 2008 ( To Arabic_CI_AS )via the optional tab in database proprieties .
but when i Insert new record( have Arabic Text) in any table the text change to ???? .
actually the problem is that my project manager has asked me to do a project of merging different databases in sql server 2008 these databases are on oracle, my sql and sql server now the problem is that the database have a column of unicode data
Is these differences are correct or not as interviewer said me these are incorrect....please guide me...
Difference between function and SP
Procedure can return zero or n values whereas function can return one value which is mandatory.
Procedures can have input/output parameters for it whereas functions can have only input parameters.
Procedure allows selectas well as DML statement in it whereas function allows only select statement in it.
Functions can be called fromprocedure whereas procedures cannot be called fromfunction.
Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.