在存储过程中如下:
SET @SQL = 'SELECT DISTINCT CONVERT(CHAR(10),a.print_time,102) as print_time,a.requisition_from,a.outpatient_id,a.inpatient_id,space(500) AS chinese_name, 1000000000.00 AS charge,d.chinese_name as hotpital ,a.patient_name ' +
'INTO ##LisTable1 ' +
'FROM lis_requisition_info a, ' +
' lis_requisition_item b, ' +
' lis_base_data d, ' +
' lis_charge_item c ' +
'WHERE (a.receive_time BETWEEN ''' + @DateFrom + ''' AND ''' + @DateTo + ''') AND' +
' d.base_data_id ='''+ @Requisition_from +''' AND ' +
' a.requisition_from ='''+ @Requisition_from +''' AND ' +
' a.requisition_from = d.base_data_id AND ' +
' a.requisition_id = b.requisition_id AND ' +
' b.charge_item_id = c.charge_item_id AND ' +
' a.requisition_state <> ''deleted'' AND ' +
' a.patient_type <> ''9'' AND ' +
' a.requisition_state <> ''returned'' '
创建临时表##LisTable1, space(500) AS chinese_name这样写会把chinese_name的字段类型变成varchar(500) 我想让这个字段的类型是text,该怎么写,谢谢各位!
SET @SQL = 'SELECT DISTINCT CONVERT(CHAR(10),a.print_time,102) as print_time,a.requisition_from,a.outpatient_id,a.inpatient_id,space(500) AS chinese_name, 1000000000.00 AS charge,d.chinese_name as hotpital ,a.patient_name ' +
'INTO ##LisTable1 ' +
'FROM lis_requisition_info a, ' +
' lis_requisition_item b, ' +
' lis_base_data d, ' +
' lis_charge_item c ' +
'WHERE (a.receive_time BETWEEN ''' + @DateFrom + ''' AND ''' + @DateTo + ''') AND' +
' d.base_data_id ='''+ @Requisition_from +''' AND ' +
' a.requisition_from ='''+ @Requisition_from +''' AND ' +
' a.requisition_from = d.base_data_id AND ' +
' a.requisition_id = b.requisition_id AND ' +
' b.charge_item_id = c.charge_item_id AND ' +
' a.requisition_state <> ''deleted'' AND ' +
' a.patient_type <> ''9'' AND ' +
' a.requisition_state <> ''returned'' '
创建临时表##LisTable1, space(500) AS chinese_name这样写会把chinese_name的字段类型变成varchar(500) 我想让这个字段的类型是text,该怎么写,谢谢各位!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货