News

Create a user defined function 'fnEmpCode' to get new Employee code of specified length and specified prefix using following query :- CREATE FUNCTION fnEmpCode ( @EmpPrefix VARCHAR(10), @EmpLength INT ...
So I've got this temp table in a stored procedure.<BR><BR>Here's some code:<BR><BR><pre class="ip-ubbcode-code-pre"><BR>Set @i = 1<BR>While @i <= 10<BR>Begin<BR>If ...