Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL¡¡Êý¾Ý¿âÉú³É×Ô¶¯±àºÅ´úÂë

--exec  [P_AutoGenerateNumber]  'reception_apply','generate_code','',7
/*
 ¹ý³Ì˵Ã÷:Éú³É×Ô¶¯±àºÅ 
 ´´½¨Ê±¼ä:2010Äê1ÔÂ12ÈÕ
 ×÷Õß:feng
 debug:ÉÐδ¿¼ÂDZàºÅÒç³öÇé¿ö
*/ 
ALTER proc [P_AutoGenerateNumber]
  (
  @tableName varchar(100)='meeting_apply', --±íÃû
  @byteName varchar(100)='generate_code',  --×Ö¶ÎÃû
  @Remark   varchar(10)='M',   --±êʾ
  @subLen   int=4            --½ØÈ¡³¤¶È
  )
  WITH  ENCRYPTION   
  as
   
  declare   @SQLString   NVARCHAR(4000)   
  declare   @OutputValue   int 
  declare   @subLenVar   NVARCHAR(20) 
  declare   @TempValue varchar(20)
  set @subLenVar =convert(varchar(20),@subLen)
  set @TempValue ='00000000000000000000'  
 
  declare @OutputValueToVar varchar(20)
  
  set @SQLString = N'select @OutputValueEx=count(*) from    '+@tableName+' where generate_code is not null or generate_code!=''''' 
  EXECUTE   sp_executesql   @SQLString,   N'@OutputValueEx int output',@OutputValueEx= @OutputValue  output
  
  if @OutputValue !=0  
  begin
   SET   @SQLString   =  N'SELECT  @OutputValueEx=max(cast(right('+@byteName+','+@subLenVar+') as int))+1   


Ïà¹ØÎĵµ£º

Sql Server ×Ö·û´®¾ÛºÏº¯Êý

 Sql Server ÓÐÈçϼ¸Ö־ۺϺ¯ÊýSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MIN£¬µ«ÊÇÕâЩº¯Êý¶¼Ö»ÄܾۺÏÊýÖµÀàÐÍ£¬ÎÞ·¨¾ÛºÏ×Ö·û´®¡£Èçϱí:AggregationTable
Id Name
1 ÕÔ
2 Ç®
1 Ëï
1 Àî
2 ÖÜ
Èç¹ûÏëµÃµ½ÏÂͼµÄ¾ÛºÏ½á¹û
Id Name
1 ÕÔËïÀî
2 Ç®ÖÜ
ÀûÓÃSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MINÊÇÎÞ·¨×öµ½µ ......

SQLÓï·¨ÓëÃüÁî


SQLÓï·¨ÓëÃüÁî
SELECT Óï¾ä
SELECT[predicate]{*|table.*|[table.]field [,[table.]field2[,...]]} [AS alias1
[,alias2[,...]]]
from tableexpression [,...][IN externaldatabase]
[WHERE...]
[GROUP BY...]
[HAVING...]
[ORDER BY...]
[WITH OWNERACCESS OPTION]
SELECT Óï¾ä°üÀ¨ÏÂÃæ¼¸¸ö²¿·Ö
predicate ......

sqlÓï¾ä²éѯ½á¹ûºÏ²¢union ºÍunion allÓ÷¨

sqlÓï¾ä²éѯ½á¹ûºÏ²¢union ºÍunion allÓ÷¨
 
--ºÏ²¢Öظ´ÐÐ
select * from A
union
select * from B
--²»ºÏ²¢Öظ´ÐÐ
select * from A
union all
select * from B
°´Ä³¸ö×Ö¶ÎÅÅÐò
--ºÏ²¢Öظ´ÐÐ
select *
from (
select * from A
union
select * from B) AS T
order by ×Ö¶ÎÃû
--²»ºÏ²¢Öظ´ÐÐ
sel ......

SQL Server Á¬½Ó×Ö·û´®ºÍÉí·ÝÑéÖ¤

SQL Server .NET Data Provider Á¬½Ó×Ö·û´®°üº¬Ò»¸öÓÉһЩÊôÐÔÃû/Öµ¶Ô×é³ÉµÄ¼¯ºÏ¡£Ã¿Ò»¸öÊôÐÔ/Öµ¶Ô¶¼ÓɷֺŸô¿ª¡£
         PropertyName1=Value1;PropertyName2=Value2;PropertyName3=Value3;.....
ͬÑù£¬Á¬½Ó×Ö·û´®±ØÐë°üº¬SQL ServerʵÀýÃû³Æ:
     ......

SQL Server ±ÊÊÔÌâ

Ò» µ¥´Ê½âÊÍ(2·Ö/¸ö) 34·Ö
¡¡¡¡Data Êý¾Ý Database Êý¾Ý¿â RDBMS ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ GRANT ÊÚȨ
¡¡¡¡REVOKE È¡ÏûȨÏÞ DENY ¾Ü¾øÈ¨ÏÞ DECLARE ¶¨Òå±äÁ¿ PROCEDURE´æ´¢¹ý³Ì
¡¡¡¡ÊÂÎñ Transaction ´¥·¢Æ÷ TRIGGER ¼ÌÐø  continue Ψһ unqiue
¡¡¡¡Ö÷¼ü primary key  ±êʶÁÐ identity Íâ¼ü foreign key  ¼ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ