軟件測試開發技術SQL Server開發過程中的的常見問題總結

　　zip char (5) NULL ,

　　contract bit NOT NULL

　　)– Execute usp_Demo_AllAuthors storing the

　　– results in #Authors

　　insert into #Authors

　　exec usp_Demo_AllAuthors– Here we use the #Authors table. This example only

　　– only selects from the temp table but you could do much

　　– more such as use a cursor on the table or join with

　　– other data.

　　SELECT au_fName + ‘ ‘ + au_lname as [name]

　　, address+’, ‘+city+’, ‘+state+’ ‘+zip [Addr]

　　from #AuthorsDROP TABLE #Authors

文章來源于領測軟件測試網 http://www.kjueaiud.com/