摘要：Declare@tTable (IDint,FNamevarchar(20),CNamevarchar(20),CAgevarchar(20))InsertInto@tselect 1,'吴亮','吴1','3岁'Unionselect 1,'吴亮','吴2','5岁'Unionselect 1,'... 阅读全文

摘要：declare @studentnumber int;select @studentnumber=count(1) from [HistoryScoreForEachItemOfStudents] select Name '姓名', t2.banji '班级',Testnumber '考号', sc... 阅读全文

摘要：alter proc save_menu_user@xml xml,@loginId varchar(200)asbeginset nocount on set ARITHABORT ON declare @tdemotab table(sutid varchar(1000),loginid varchar(1000),mid int) insert into @tdemotab select 0 Stuid,T.a.value('@loginId','varchar(200)') loginId,T.a.value('@mid','in 阅读全文