brand表结构如下
字段名 字段类型 默认值
ID Guid newid()
BrandName
Logo
BriefIntroduction
createTime DateTime getdate()sql语句如下:把某个表的数据插入到brand表中。
insert into brand(BrandName,Logo,BriefIntroduction)
select made.madename,made.madelogo,made.madehistory from made
inner join country on made.madecountry = country.countryname order by made.madefirstletter插入成功后,问题来了,所有数据的createTime的值都是一样。
请问如何让插入的每条数据中字段createTime 的值都不一样?
字段名 字段类型 默认值
ID Guid newid()
BrandName
Logo
BriefIntroduction
createTime DateTime getdate()sql语句如下:把某个表的数据插入到brand表中。
insert into brand(BrandName,Logo,BriefIntroduction)
select made.madename,made.madelogo,made.madehistory from made
inner join country on made.madecountry = country.countryname order by made.madefirstletter插入成功后,问题来了,所有数据的createTime的值都是一样。
请问如何让插入的每条数据中字段createTime 的值都不一样?
解决方案 »
- DataGridView.Columns.Clear() 会释放 DataGridViewColumn对象所占用的空间吗?
- 怎么利用timer控件让lable标签滚动起来???急急急!!!
- 请教正则提取网页url和网格数据
- C# 替换字符串
- [如何解决]除非 DataGridView 被数据绑定到支持更改通知并允许删除的 IBindingList,否则不能以编程方式移除行。
- 初学C#,但是不知道怎么配置环境,怎么编译???
- 怎样通过一个webForm打开另一个webForm
- C#中能否像Linux shell中快速将文件的首行去掉或者将除去首行的其他保存到另外一个文件中?
- 远程SQL数据库连接问题,请各位帮忙看看。
- VS2019 创建web项目 找不到MVC模板
- 一道有趣的面试题
- Visual Studio 2008与2005版C#在数据库操作上主要有哪些区别?
select made.madename,made.madelogo,made.madehistory,getdate() from made
inner join country on made.madecountry = country.countryname order by made.madefirstletter
select made.madename,made.madelogo,made.madehistory,getdate()
insert into brand(BrandName,Logo,BriefIntroduction,createTime)
from made
inner join country on made.madecountry = country.countryname order by made.madefirstletter
Oracle: SYSDATE
SQLServer: GETDATE()
create proc mypro
as
declare @brandname1 uniqueidentifier
declare @brandname2 nvarchar(50)
declare @brandname3 varchar(100)
declare @brandname4 nvarchar(4000)
declare cur cursor for
select country.countryid,made.madename,made.madelogo,made.madehistory from made
inner join country on made.madecountry = country.countryname order by made.madefirstletter
open cur
fetch next from cur
into @brandname1,@brandname2,@brandname3,@brandname4
WHILE @@FETCH_STATUS=0
begin
insert into brand(CountryID,BrandName,Logo,BriefIntroduction) values(@brandname1,@brandname2,@brandname3,@brandname4)
fetch next from cur into @brandname1,@brandname2,@brandname3,@brandname4
end
close cur
deallocate curexec mypro
你的那个某个表有没有这个时间字段咯 有的话就直接读出来再插入啦!!