declare @table1 table (date datetime,Agrid int,chkId int,name varchar(18) )
insert into @table1 values('03-11-2004',102252271 ,100061, 'a''b''c')
insert into @table1 values('03-11-2004',102252271 ,100842, 'Eli OldName')
insert into @table1 values('11-11-2004',102252271 ,100843, 'Eli OldName') ;
select * from @table1 where name ='a''b''c'
This will help u. worked for me...
kunalsmehta
Last Activity: Apr 22 '09, 09:23 AM
Joined: Apr 13 '09
Location:
-
What errs r u getting. post the errs with test data
KunalLeave a comment:
-
this is the way u can enter special characters in db.
for inserting ' you need to insert ''
thats itLeave a comment:
-
select
C.Name,
S.LastStatus,
max(Sched.LastR unTime)
from Schedule Sched
join ReportSchedule RS on Sched.ScheduleI D = RS.ScheduleID
join Catalog C on RS.ReportID = C.ItemID
join Subscriptions S on C.ItemID = S.Report_OID
group by C.Name,
S.LastStatus
Order by C.NameLeave a comment:
-
insert into @table1 values('03-11-2004',102252271 ,100061, ';Eli NewName''"')Leave a comment:
-
Hi, try this
declare @table table (col1 int, col2 int ,col3 varchar)
insert into @table values (2100, 2200, 'V')
insert into @table values (2200, 2307, 'V')
insert into @table values (2200, 2308, 'm')
insert into @table values (2307, 2400, 'V')
insert into @table values (2400, 2500, 'V')
insert into @table values (2600, 2700, 'V')
insert into @table values (2700, 2800, 'V')
select...Leave a comment:
No activity results to display
Leave a comment: