Alienus Non diutius

create proc viewRobotData ( @idx int, @visit int ) as begin declare @sensor char(5) declare @sensor1 char(1) declare @sensor2 char(1) declare @sensor3 char(1) declare @sensor4 char(1) declare @sensor5 char(1) if(not exists(select * from robotData where idx=@idx)) print('없음') else begin update robotData set visit = visit + @visit where idx = @idx select @sensor1 = sensorTouch, @sensor2 = sensorLi..

청강컴정/09DataBase기말고사 2009. 6. 7. 10:25

create proc robotDataInsert ( @title varchar(50), @folderName varchar(50), @contents varchar(4000), @imgCount tinyint, @robotLevel char(2), @robotSensor char(5), @errCode tinyint output ) as begin set @errCode = 0 declare @idx int declare @minIdx int declare @newIdx int declare @maxIdx int declare @buildLevel tinyint declare @sourceLevel tinyint declare @sensorTouch bit declare @sensorLight bit ..

청강컴정/09DataBase기말고사 2009. 6. 6. 22:17

create table robotData ( idx int not null primary key, title varchar(50) not null unique nonclustered, folderName varchar(50) not null unique nonclustered, contents text not null, date datetime default getdate(), visit int default 0, imgCount int default 0, buildLevel tinyint default 0, sourceLevel tinyint default 0, sensorTouch bit default 0, sensorLight bit default 0, sensorUltra bit default 0..

청강컴정/09DataBase기말고사 2009. 6. 6. 17:05

create function YorN(@data bit) returns char(1) begin declare @rslt char(1) set @rslt = case @data when 0 then 'N' when 1 then 'Y' end return @rslt end

청강컴정/09DataBase기말고사 2009. 6. 6. 17:04

create proc memberList as begin select mName+'('+mNickName+')' as mName, mID, left(mBirthday,4) +'년' + substring(mBirthday,6,2) + '월' + right(mBirthday, 2) + '일' as mBirthday, convert(char(16), mRegDate, 120) as mRegDate, mVisit, ERC_DB.dbo.YorN(mMailling) as mMailling from member order by mRegDate desc end

청강컴정/09DataBase기말고사 2009. 6. 6. 10:57

청강컴정/09DataBase기말고사 2009. 6. 5. 04:15

create proc memberLogin ( @mID varchar(20), @mPwd varchar(20), @mChk int output ) as begin declare @tempPwd varchar(20) if(exists(select * from member where mID = @mID)) begin if((select mPwd from member where mID=@mID) = @mPwd) set @mChk = 0 else set @mChk = 2 end else set @mChk = 1 end

청강컴정/09DataBase기말고사 2009. 6. 5. 04:13

create table robotData ( idx int primary key, title varchar(50) not null, sensor char(5) default '00000', buildLevel tinyint default 0, programLevel tinyint default 0, contents nvarchar(1000), visit int default 0, writeDate datetime default getdate() ) create proc robotDataInsert ( @title varchar(50), @sensor char(5), @buildLevel tinyint, @programLevel tinyint, @contents nvarchar(1000) ) as begi..

청강컴정/09DataBase기말고사 2009. 6. 4. 19:04