摘要： USE pubsDECLARE tnames_cursor CURSORFOR SELECT state FROM authorsopen tnames_cursordeclare @state varchar(50)Fetch tnames_cursor into @statewhile (@@fetch_status=0)begin if(@state='CA') beg... 阅读全文