create view V_tableTemp as select a.* from TEMPCLIENT a ,TEMPCLIENTSTUFF b where a.CORNO<>'' and a.CORNO = b.CORNO select * from V_tableTemp sqlserver 中创建表按照视图结构,并插入数据.相当于 oracle 中 create table tableTemp as V_tableTempSELECT * INTO tableB fro
语法: select x into new_tableName from ori_tableName 例如: SELECT [site] ,[day] ,[val]/31.4 [val] into t_init FROM [RainFactor].[dbo].[t_factor] order by [site],[day]
直接上代码: 第一部分: case class OrdPacsresult_obj(pk_dcpv: String, result_obj: String) 第二部分: def ordsubj: Unit = { import sparkSession.implicits._ import sparkSession.sql val dataset: Dataset[OrdPacsresult_subj] = sql("select pk_dcpv,result_obj,result_subj f