C#연동 예제

090315_null.zip

create table USERS
(
 SN int not null primary key identity(1,1),
 NAME nvarchar(24),
 DUTY nvarchar(12),
 MOBILE nvarchar(18)
)

insert into USERS values('홍길동', '사원', '000-0000-0000')
insert into USERS values('홍길동', '사원', '000-0000-0000')
insert into USERS values('홍길동', '사원', null)
insert into USERS values('홍길동', '사원', '')

create proc selectAll
as
begin
select * from USERS
end