Tony Fu's Blog

select t0.family_ident,ss.student_number,ss.first_name,ss.last_name,ss.grade_level,to_char(ss.DISTRICTENTRYDATE,'MM/DD/YYYY'),to_char(ust.CUST_VISAEXPIRE,'MM/DD/YYYY'),to_char(ust.CUST_PASSPORTEXPIRE,

if object_id('finaltest') is not null    drop proc finaltest   go    create proc finaltest  @student_number INT output, @lastfirst varchar(50) output, @input_

--Create Procedure--  if object_id('inputtest') is not null  drop proc inputtest  Go  create proc inputtest  --This is proc declare, NOT variable declare--

When you declare like:   select * into @testitout from students  or  DECLARE @TESTITOUT TABLE  select * into @testitout from students  or 

Some time, we need some variable to transfer number, date or even table.  For accomplish tasks like that , I will introduce some build-in function of sql server in this instruction.  

--Create Procedure-- if object_id('outputtest') is not null drop proc outputtest Go  create proc outputtest --This is proc declare, NOT variable declare-- @

When you exec script like   begin tran exec tonytest rollback tran commit tran  You will see an error like   Msg 3902, Level 16, State 1, Li

SQL give you the capability to define your own procedure, Here is an example.  create procedure Tonytest --after create this Procedure, you can use alter instead of create to

Below link is a good source for learning cursors in sql http://www.cnblogs.com/moss_tan_jun/archive/2011/11/26/2263988.html   And I already made a little script for  example. T

with Core as  (select co.course_number, (case  when termid=((substr('&param1',1,4))-'1990') *100 then substr('&param1',1,9) when termid=((substr('&param1',1,4))-'1990')

Try to make a script   To get full info   For a random Female (or Male) student.