- 博客(5)
- 收藏
- 关注
原创 SQL SERVER 5
select TitleName, LEFT(TitleName,1)+' '+RIGHT(TitleName,1) as 出版物首位, Author。print '局部变量: @vanme:'+ @vname +' @vtime: '+ CONVERT(Varchar,@vtime,120)insert into publishers (PubCode,PubName) values('TDBC','人民出版社')where CategoryName in ('JAVA','电子商务','C#基础')
2023-05-25 16:44:45
44
原创 SQL server 4
insert into titles values('T014','网络数据库开发与设计','史俊','2','HXTD','28','2013-10-01')print'局部变量:@vaddr:'+@vaddr+'@vdate:'+convert(varchar,@vdate,120)select titleName,author,price*5 as'5倍价格',price。where author in('朱丽叶','谢海','刘东')set @vaddr='北京路68号'
2023-05-25 16:44:05
79
1
原创 SQL server 2
select year(replace(replace(replace('2013年10月21日','年','-'),'月','-'),'日',''))select cityname,citycode from city where CityName in('沈阳','深圳','青岛')print '局部变量:@vaddr:'+@vaddr+' @vnum:'+cast(@vnum as char(10))insert into city values('MSD','山东')
2023-05-25 16:42:11
61
1
原创 SQL server3
select a.*,b.PubName from city a inner join publishers b on a.CityCode = b.CityCode where a.CityName in ('广州','北京')select DAY( replace(replace(replace('2014年03月15日','年','-'),'月','-'),'日','') )update titles set Author = '张田' where TitleName = '数据库管理'
2023-05-25 16:41:39
82
1
原创 SQL server 1
insert into publishers values('ZLTC','蓝天出版社','020-83546627','越秀区果戈里大街12号','AGZ')select year(replace(replace(replace('2012年5月18日','年','-'),'月','-'),'日',''))print '局部变量:@vname:'+@vname+' '+'@vnum+:'+convert(varchar,@vnum)//6-1-2 使用PRINT语句输出局部变量和全局变量的值。
2023-05-25 16:40:17
78
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人