Tony Fu's Blog

https://www.microsoft.com/en-us/download/details.aspx?id=52679  It is easy to get SQL server 2016 on Baidu or Google, or click this link to download. To set up SQL server 201

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')

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,

Sometime we need a new empty table has same columns with existed Table to store some components in, But re-design a new table is a demanding task, then try this out!  select * into

When you login, and enter your first script,  you may see this: Msg 208, Level 16, State 1, Line 1 Invalid object name 'ONE'.  For some reason, database may not recognize

It's easy to create tables in sql server.   There are 2 ways to accomplish this task.   Right click Tables, in the menu, select Table. Design your table on

When login, you will see this  Please leave it by default and click Connect.  Then you can see this window, then right click  Databases.  Give it

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