Viewing 15 posts - 1 through 15 (of 17 total)
You cannot store 'blank' in a datetime column. Your best bet is to store it as null or 1/1/1900.
October 5, 2002 at 2:35 am
be sure to run "EXEC sp_updatestats" after the restore.
September 11, 2002 at 3:13 am
select *
from tb t1
where id=(select min(id) --or max
from tb t2
where t2.email=t1.email)
--
-oj
Rac v2.1 Public Beta RELEASED.
July 24, 2002 at 6:03 pm
Much is changed from sql7 to sql2k. You would probably want to set the compatibility level accordingly.
Follow this link for more info:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_da-di_5c8c.asp?frame=true
--
-oj
Rac v2.1 Public Beta RELEASED.
...
July 24, 2002 at 5:59 pm
You can post some code here so we can see what's wrong.
--
-oj
Rac v2.1 Public Beta RELEASED.
July 24, 2002 at 5:51 pm
You want to check for the existence of DF before performing the drop.
SELECT @sql='if object_id(''DF_RAW_ELIGIBILITY_INPUT_FILE'',''D'') is not null
ALTER TABLE RAW_ELIGIBILITY DROP CONSTRAINT DF_RAW_ELIGIBILITY_INPUT_FILE'
PRINT @sql
--
-oj
Rac v2.1...
July 24, 2002 at 5:50 pm
Save yourself some headache and download a free XP from Gert's site...
http://www.sqldev.net/xp/xpsmtp.htm
--
-oj
Rac v2.1 Public Beta Avail.
July 24, 2002 at 5:38 pm
select name,
case objectproperty(id,'ExecIsTriggerDisabled')
when 1 then 'Disabled'
else 'Enabled' end [status]
from sysobjects
where xtype='tr'
--
-oj
April 10, 2002 at 9:32 pm
what do you mean db dictionary? if you're looking for a tool to document your db, perhaps, you should check out greg's site...
--
-oj
April 5, 2002 at 11:10 pm
April 5, 2002 at 11:08 pm
here is an example for you...
create table t(i int)
go
create trigger ins on t
for insert
as
declare @sql varchar(255)
--create batch file
select @sql='echo dir ^>c:\out.txt >c:\r.bat'
exec master..xp_cmdshell @sql,...
April 5, 2002 at 11:07 pm
richard,
you initialized @new_type too late. you should move the whole begin/end
BEGIN
IF (@Type = 'Tables')
select @New_Type = 'U'
Else
IF (@Type = 'Views')
select @New_Type = 'V'
ELSE
IF (@Type = 'Procedures')
select @New_Type = 'P'
END
to...
April 4, 2002 at 1:19 am
levi,
use server network utility that comes with sqlserver to set the listening port.
--
-oj
April 4, 2002 at 1:06 am
Hi,
SELECT PO_Number, Part_Number
FROM OrderItem
WHERE
(Part_Number=@part_number1 and po_number=@po_number1) or (Part_Number=@part_number2 and po_number=@po_number2) or (Part_Number=@part_number3 and po_number=@po_number3) or (Part_Number=@part_number4 and po_number=@po_number4) or (Part_Number=@part_number5 and po_number=@po_number5)
--
-oj
March 30, 2002 at 3:25 am
this should get you started...
select isnull(max(id),0)+1
from tb
where convert(varchar,dtcol,112)=convert(varchar,getdate(),112)
--
-oj
March 29, 2002 at 2:29 am
Viewing 15 posts - 1 through 15 (of 17 total)