数据库编程基础

use db2013170149
select * from sa2013170149
use db2013170149
select * from sa2013170149.xushengxinxi
use db2013170149
create table students
(
	stuNo varchar(10) primary key,
	stuname varchar(10) not null,
	sex char(2) not null,
	age int
	)
insert into sa2013170149.students values(001,'小李','男',18)
insert into sa2013170149.students values(002,'小王','女',16)
insert into sa2013170149.students values(003,'小张','男',19)
insert into sa2013170149.students values(004,'小马','女',17)

select *from sa2013170149.students

use db2013170149
	select top(3)* from sa2013170149.students 
	where ( sex='男' and age>=18 )

use aspnetdb
	create table STU
		(
		XH char(10) not null primary key,
		XM char(8) null,
		NL int
		)

	insert into STU values(001,'张三',18)
	insert into STU values(002,'李四',16)
	insert into STU values(003,'王五',17)
	insert into STU values(004,'马六',19)
	 
	select * from STU

	update STU set XM='小马' where XH=004

	select * from STU

	delete from STU where XH=003

	select * from STU

	drop table STU

1、
create  function  gs(@x  int)
returns  int   as
begin
        declare  @i  int, @sum  int
        set  @i=1
        set  @sum=0
        while  @i<=@x
              begin
                      set  @sum=@sum+@i
                      set  @i=@i+1
               end
         return  @sum
end
select  dbo.gs(100)


2、
create  function  gs(@x  int)
returns  int   as
begin
        declare  @i  int, @sum  int
        set  @i=2
        set  @sum=0
        while  @i<=@x
              begin
                      set  @sum=@sum+@i
                      set  @i=@i+2
               end
         return  @sum
end
select  dbo.gs(100)


3、
create  function  gs(@x  int)
returns  int   as
begin
        declare  @i  int, @sum  int
        set  @i=1
        set  @sum=0
        while  @i<=@x
              begin
                      set  @sum=@sum+@i
                      set  @i=@i+2
               end
         return  @sum
end
select  dbo.gs(99)


4、
create function qiuhe(@x int,@k int)
returns int as
begin
declare @i int,@sum int
  set @i=1
  set @sum=0
  while @i<=@x
      begin
       if @i%@k=0
       set @sum=@sum+@i
       set @i=@i+1
      end
  return @sum
end
select  dbo.qiuhe(100,3)


5、
create function qiuhe(@x int,@k int)
returns int as
begin
declare @i int,@sum int
  set @i=1
  set @sum=0
  while @i<=@x
      begin
       if @i%@k=0
       set @sum=@sum+@i
       set @i=@i+1
      end
  return @sum
end
select  dbo.qiuhe(100,5)


6、
create function qiuhe(@x int,@k int)
returns int as
begin
declare @i int,@sum int
  set @i=1
  set @sum=0
  while @i<=@x
      begin
       if @i%@k=0
       set @sum=@sum+@i
       set @i=@i+1
      end
  return @sum
end
select  dbo.qiuhe(100,7)


7、
create function qiuhe(@x int,@k int)
returns int as
begin
declare @i int,@sum int
  set @i=1
  set @sum=0
  while @i<=@x
      begin
       if @i%@k=0
       set @sum=@sum+@i
       set @i=@i+1
      end
  return @sum
end
select  dbo.qiuhe(100,11)