use pubs

go

create table test (c1 int)

begin tran

alter table test add c2 int

sp_help test

rollback

sp_help test

go

drop table test

select a.* from test a

 where exists(select * from test b where type = 'Avail' and a.master=b.master)

 and exists(select * from test c where type='oper'and a.master=c.master)

 and type in ('Avail', 'Oper')

Should result include 1210 as well?

If exists(select * from information_schema.column where table_name='T_Customize' and column_name='IncludeQuestion')

alter statement

Just guessing:

SELECT ordbot.[time]

            ,ordbot.density

            ,...

select * from nigo a,

 (select internalid, min(event_date) as event_date from nigo group by internalid) b

 where a.internalid = b.internalid and a.event_date = b.event_date

declare @i int

select @i=dbo.GetEmployeeid('Schaefer')

SELECT     mail, sn, givenname

FROM         dbo.udf_GetEMpsBYManager(@i)udf_GetEMpsBYManager

insert into tablename exec proc_A(1,2,'Test), then query the tablename

or

convert proc_A to table function and query directly from the function.

convert or cast in decimal data type.

something like convert(decimal(6,2), column/10.0)

try sp_cursor_list

Try lower function

Use isqlw in command line instead.

Configuration file (-C) can help you.

Check syntax with isqlw /? from prompt.

I would use same logic in update statement to check.

Try this

select sl.slstamp, fi.fistamp

from sl inner join fi on cast(sl.adoc as bigint(18))=fi.fno and sl.ref=fi.ref

where sl.origem='SL' and

(sl.cm=75 or sl.cm=76 or...

Would this help?

select EventNumber, EventNameID=Max(EventNameID), StartDate=Min(StartDate), EndDate=Max(EndDate) from test

 group by EventNumber

Use convert function

select id, convert(varchar(10), dd, 120) from temp