Question

如何将smalldatetime类型转换为datetime类型 求SQL代码

或者说不可以么？

Answer 1

datetime类型转换为datetime类型 求SQL代码
1 分钟前2271059759 | 分类：数据库DB | 浏

Answer 2

alter table 表名 alter column 字段名 datetime

Answer 3

declare @tablename sysnamedeclare @colname sysnamedeclare @sqlstr varchar(8000)declare cur cursor forselect a.name,b.name from sysobjects a,syscolumns bwhere a.id=b.id and b.xtype=58 and a.xtype='u'open curfetch next from curinto @tablename,@colnamewhile @@fetch_status=0begin set @sqlstr='alter table ['+@tablename+'] alter column ['+@colname+'] datetime' exec(@sqlstr)fetch next from curinto @tablename,@colnameenddeallocate cur

Answer 4

cast(列名 as datetime)

追问

直接写这个代码么？我怎么确定是转换那个表中的那个列呢？真心不懂啊