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

¹ØÓÚSql´æ´¢¹ý³Ì


SQL ÖеĴ洢¹ý³Ì£º
1.ÔÚ½¨Á¢´æ´¢¹ý³Ì֮ǰ¼ì²éËùÃüÃûµÄ´æ´¢¹ý³ÌÊÇ·ñÓ¦¾­´æÔÚ¡££¨ÒòΪÈç¹ûͬÃû´æ´¢¹ý³ÌÒѾ­´æÔÚ£¬ÐµĴ洢¹ý³Ì½«²»±»½¨Á¢£©
if exists(select * from sysobject where name='proc name' and type='p')
drop proc proc name
   go
2.¶¨Òå´æ´¢¹ý³Ì
create proc test
@gradel int, --¶¨Òå±äÁ¿
@gradeh int output --¶¨ÒåÊä³ö±äÁ¿
as
...
go
3.Ö´Ðд洢¹ý³Ì
declare @l int,@h int
exec proc test 34,@h output
print @h
----------------------------------------------
ÏÂÃæÒÔÒ»¸öÀý×Ó˵Ã÷£º
ÊäÈëÁ½¸ö·ÖÊý£¬ÒªÇóдÁ½¸ö´æ´¢¹ý³Ì£¬Ò»¸ö¶ÔÊäÈë·ÖÊýÅÅÐò£¬ÁíÒ»¸ö²éѯÁ½·ÖÊý¶ÎÖ®¼äµÄ³É¼¨£º
Ò»¹²ÓÐÈý¸ö±í£º
s±í£º£¨s#£ºÑ§ÉúºÅ£¬sname:ѧÉúÐÕÃû£¬age:ÄêÁ䣬sex:ÐÔ±ð£©
c±í£º£¨c#£º¿Î³ÌºÅ£¬cname:¿Î³ÌÃû£¬teacher£ºÀÏʦ£©
sc±í£º£¨s#,c#,grade)
if exists(select * from sysobjects where name='sort'
          and type='p')
drop proc sort
go --¶¨ÒåÒ»¸ö´æ´¢¹ý³ÌÓÃÓÚÅÅÐò
create proc sort
@high int,
@low int,--¶¨ÒåÁ½¸öÊäÈë²ÎÊý
@hi int output,
@lo int output--¶¨ÒåÁ½¸öÊä³ö²ÎÊý
as
if @high<@low
begin
set @high=@high+@low
set @low=@high-@low
set @high=@high-@low
set @hi=@high
set @lo=@low
end
go --Èç¹ûδ°´Ë³ÐòÊäÈëÔòÅÅÐò
if exists(select * from sysobjects where name='search' and type='p')
drop proc search
go --¶¨ÒåÒ»¸ö´æ´¢¹ý³ÌÓÃÓÚ²éÕÒÏàÓ¦·¶Î§µÄ¼Ç¼
create proc search
@gradeh int,
@gradel int
as
select * from sc where grade between @gradel and @gradeh
if @@rowcount=0
print '²éѯʧ°Ü'
go
declare @h int,@l int
exec testpro 70,90,@h output,@l output
exec search @h,@l
²Î¿¼£ºhttp://hi.baidu.com/rosalind1717/blog/item/bcb26ceea5a418212cf534ce.html
http://hi.baidu.com/isbx/blog/item/3e06ae514c35ac878d543094.html


Ïà¹ØÎĵµ£º

SQL SERVERµÄÉ󼯹¦ÄÜ

      ÆôÓÃc2ÉóºËÃüÁîÈçÏ£º
      EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE      
      SQL ServerÒÔ128KB´óСµÄ¿éΪµ¥Î»°ÑÊý¾ÝдÈë¸ú×ÙÎļþ¡£Òò´Ë£¬µ±SQL Server·ÇÕý³£Í£Ö¹Ê±£¬×î¶à¿ÉÄܶªÊ§128
......

SQL»ù´¡½Ì³Ì

SQL ½Ì³Ì
1£©SQL ¼ò½é
SQL(Structured Query Language£¬½á¹¹²éѯÓïÑÔ)ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âÓïÑÔ¡£SQLͨ³£Ê¹ÓÃÓÚÊý¾Ý¿âµÄͨѶ¡£ANSI£¨ÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£©Éù³Æ£¬SQLÊǹØÏµÊý¾Ý¿â¹ÜÀíϵͳµÄ±ê×¼ÓïÑÔ¡£SQLÓï¾äͨ³£ÓÃÓÚÍê³ÉһЩÊý¾Ý¿âµÄ²Ù×÷ÈÎÎñ£¬±ÈÈçÔÚÊý¾Ý¿âÖиüÐÂÊý¾Ý£¬»òÕß´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£Ê¹ÓÃSQLµÄ³£¼û¹ØÏµÊý¾Ý¿â¹ ......

ÕÒЩ²»´íµÄsqlÃæÊÔÌâ(1)

Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
  select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
  fr ......

ASP.NET Excelµ¼Èëµ½SQL ServerÊý¾Ý¿â


ASP.NET Excelµ¼Èëµ½SQL ServerÊý¾Ý¿â
Ìṩ°ÑExcelÀïµÄÊý¾Ýµ¼Èëµ½SQL Server Êý¾Ý¿â£¬Ç°ÌáÊÇExcelÀïµÄ×Ö¶ÎÔÚSql Server±íÀï¶¼ÓУ¬²»È»»á³öÏÖ´íÎó¡£×¢ÊͺÜÏêϸŶ£¡ÒªÒýÓõÄÃüÃû¿Õ¼äÊÇ£º
using System.Data.OleDb;
using System.Data.SqlClient;
//²Ù×÷Àà
 public class ExcelToSQL
{
  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ