计算机数据库SQL常用测试题及答案.docVIP

----把表A的数据导入到表B(预先有的表结构)中 insert into b (userNames,ages,addresss)select userName,age,address from a; ----把表A的数据导入到表c(预先不存在的表)中 select * into T_Shop from T_Food; --根据年月，计算出当月的天数 DateDiff(dd,@tmpDate,DateAdd(mm,1,@tmpDate)) --获取当月天数 select day(dateadd(mm,1,getdate())-day(getdate())) --获取当月天数语句 select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(getdate()) as varchar) +-+cast(month(getdate()) as varchar)+-01 as datetime)))) select len(content) from T_nationContent where id=9 declare @messages VARCHAR(200) --返回信息 set @messages=datepart(day,getdate()) print @messages --当前日期转换为星期几 declare @messages VARCHAR(200) --返回信息 set @messages=datename(weekday,getdate()) print @messages 刪除主表中不存在記錄的從表資料 Delete B From DTL B Where Not Exists (Select 1 From MST A Where A.AD_NO = B.AD_NO And A.VERSION = B.VERSION And A.REVISION = B.REVISION) --随机读取一条数据 Select top 1 Content from T_news Order by newid(); sql for循環 declare @a int set @a=0 while @a=10 begin print @a set @a=@a+1 end @A,@B,@C你自己定義以下 Declare RuleCursor Cursor for select * from T2 where D=XX open RuleCursor fetch next from RuleCursor into @A,@B,@C while @@FETCH_STATUS = 0 begin insert into T1(D,E,F) values(@A,@B,@C) fetch next from RuleCursor into @A,@B,@C end close RuleCursor deallocate RuleCursor 求一个SQL查询写法表如下： 表1 brand codekey content1 a 1 ccc a 2 bbb a 3 ddd b 5 aaa ... 表2 brand codekey content2 a 1 xxx a 1 yyy a 2 zzz b 8 hhh ... 我想查询的是，当条件brand = a 时，查询结果如下： brand codekey content a 1 cccxxxyyy a 2 bbbzzz a 3 ddd 解释一下，返回的结果是key中不应该有重复的，对应的content列是相应的code