sql ÓαêµÄʹÓÃ
Ò»¸öÀý×Ó£º´Ótszl±íÖвé³öÊý¾Ý£¬¸ù¾Ýcs×ֶεÄÖµ¾ö¶¨ÍùBOOK_SERIAL±íÖвåÈ뼸ÐÐÊý¾Ý¡£
declare @num int
declare @id varchar(60)
declare @classbm varchar(60)
set @classBm='101'
declare id cursor for select id,cs from [tszl]
open id
fetch next from id into @id,@num
while @@fetch_status!=-1
begin
while(@num>0)
begin
set @num = @num-1
INSERT INTO [BOOK_SERIAL]
([id]
,[classBm]
,[state])
values(@id,@classBm,'0')
end
fetch next from id into @id,@num
end
close id
Ïà¹ØÎĵµ£º
-- Ò»£º ´¦Àíδ²éµ½µÄ¿ÕÖµ
select
case when exists(select EndPrice from T_stock where BOMSN='0109')
then (select EndPrice from T_stock where BOMSN='0109')
else 0 end
--¶þ£º¸üÐÂ×Ö¶ÎÖµ
--strNum ÊýÁ¿
--strId ÐòºÅ
update T_buy_Pro set Co ......
ÒªµÃµ½Ä³Ò»ÌìÊÇÐÇÆÚ¼¸£¬ÐèÒªÓõ½ SQL Server ÖеÄÈÕÆÚº¯Êý£ºdatename()¡£ ½ñÌìÊÇÐÇÆÚ¼¸£¬Àý×Ó 1£º 1: set language N'English'
2: select datename(weekday, getdate())
3:
4: Wednesday
½ñÌìÊÇÐÇÆÚ¼¸£¬Àý×Ó 2£º
1: set language N'Simplified Chinese'
......
²âÊÔÈËÔ±ÒªÕÆÎյĻù±¾µÄSQLÓï¾ä(ÉÏ)
  ......
µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄÐÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄÐÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ÐÒ飬ÓÒ¼üµ ......