数据库里的 DateTime类型的字段怎么插入空值
1个回答
展开全部
在数据库中可以这样实现,
1】比如sql2000,sql2005中:
declare @name varchar(100)
select @name=sname from student where s_id=100
print @name
2】Oracle中可以这样写:
set serveroutput on;
declare
a varchar2(20);
begin
select sname into a from student where s_id=100;
dbms_output.put_line(a);
end;
1】比如sql2000,sql2005中:
declare @name varchar(100)
select @name=sname from student where s_id=100
print @name
2】Oracle中可以这样写:
set serveroutput on;
declare
a varchar2(20);
begin
select sname into a from student where s_id=100;
dbms_output.put_line(a);
end;
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询