Private: MY Note

สร้าง store procedure :
CREATE PROCEDURE get_date
@r varchar(20)  out
AS
begin
     select @r =  getdate()
end
GO
————————
เรียกใช้ procedure:
declare @r varchar(20)
exec get_date @r out
select @r ddd

ref: http://www.awprofessional.com/articles/article.asp?p=25288&seqNum=9&rl=1

declare @str varchar(12), @i int
set @str = ‘test1′
set @i = len(@str)

while(@i<10)
begin
 set @str = ‘0′ + @str
 set @i = @i + 1
end

select @str