Cập nhật:
CREATE PROCedure capnhat
@Ma_NhaCC nchar(10),
@Ten_NhaCC nvarchar(50),
@Ten_NguoiTX nvarchar(50),
@ChucDanh_NguoiTX nvarchar(50),
@Dia_Chi_NhaCC nvarchar(50),
@Thanh_Pho nvarchar(50),
@Vung_MaHopThu nchar(10),
@Quoc_Gia nvarchar(50)
As
Begin
update NhaCC set Ma_NhaCC=@Ma_NhaCC,Ten_NhaCC=@Ten_NhaCC,Ten_NguoiTX=@Ten_NguoiTX,ChucDanh_NguoiTX=@ChucDanh_NguoiTX,Dia_Chi_NhaCC=@Dia_Chi_NhaCC,Thanh_Pho=@Thanh_Pho,Vung_MaHopThu=@Vung_MaHopThu,Quoc_Gia=@Quoc_Gia
where Ma_NhaCC=@Ma_NhaCC
end
exec capnhat NCC02,'','','','','','',''
Thêm DL :
CREATE PROC SP_INSERTNhaCC
@Ma_NhaCC nchar(10),
@Ten_NhaCC nvarchar(50),
@Ten_NguoiTX nvarchar(50),
@ChucDanh_NguoiTX nvarchar(50),
@Dia_Chi_NhaCC nvarchar(50),
@Thanh_Pho nvarchar(50),
@Vung_MaHopThu nchar(10),
@Quoc_Gia nvarchar(50)
As
if not exists(select*from NhaCC where Ma_NhaCC=@Ma_NhaCC)
Begin
Insert into NhaCC (Ma_NhaCC,Ten_NhaCC,Ten_NguoiTX,ChucDanh_NguoiTX,Dia_Chi_NhaCC,Thanh_Pho,Vung_MaHopThu,Quoc_Gia)
values(@Ma_NhaCC,@Ten_NhaCC,@Ten_NguoiTX,@ChucDanh_NguoiTX,@Dia_Chi_NhaCC,@Thanh_Pho,@Vung_MaHopThu,@Quoc_Gia)
end
go
exec SP_INSERTNhaCC 'NCC04','Dai Hai','Hoang','Dai Ca','123 nguyen xi','Tp HCM','84','Viet Nam'
Tính ngày trong tuần :
create function thu(@ngay datetime)
returns nvarchar(10)
as
begin
declare @st nvarchar(10)
select @st=case datepart(dw,@ngay)
when 1 then 'chu nhat'
when 2 then 'thu hai'
when 3 then 'thu ba'
when 4 then 'thu tu'
when 5 then 'thu nam'
when 6 then 'thu sau'
else 'thu bay'
end
return (@st)
end
select dbo.thu('04/14/1988')
Xóa DL :
create procedure XoaDL
@Ma_NhaCC nchar(10)
as
begin
delete from NhaCC where Ma_NhaCC=@Ma_NhaCC
end
Exec XoaDL 'NCC01'