比如字段是
123 1323
asdas asd
那么我想得到结果是
123
asdas
------解决方案--------------------
写反了.
select left(字段 , charindex( ' ' , 字段) - 1) from tb
------解决方案--------------------
先要drop掉test表.
ALTER PROCEDURE [dbo].[testProc]
AS
BEGIN
if exists(select 1 from sysobjects where xtype= 'U ' and name= 'test ')
drop table test
declare @test int;
select count(*) as c into test from table2;
print @test
END
------解决方案--------------------
select a,left(a,charindex( ' ',a)) FROM test