Create an instance of SQL 2005

Dear friends,

I deleted the instance of SQL 2005, and now I want to create and I dont know how! Colud you tell me?
Thanks.

Insert the setup media and install it again, you have the chance to name of new instance there. (don′t forget to patch the system again after installing the instance from scratch)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

CR10 & CR11 with lotus Notes R6

Hi all friends
does anyone know where i can download CR10 or CR11 even demo version?
does CR10 & CR11 working with lotus notes??Check out here
http://support.businessobjects.com/

Coverting Int to DateTime Recommendation?

Friends,

I have a database that I am in the process of converting to a new application. All the dates are currently stored as an numeric YYYYMMDD format. I am hoping someone can suggest the best way of dealing with these in SQL Server. Should I convert them to DateTime formats for example, and what is the best way to do this?

Any input would be greatly appreciated.

J.H.

yes you should do it.

the best way?

this is how I would do it -

create function YYYMMDDToDate(@.date int)
returns datetime
as
begin
declare @.datestring char(8)
set @.datestring = cast(@.date as char(8))
return convert(datetime, substring(@.datestring,1,4) +'-' +
substring(@.datestring,5,2) +'-' +
substring(@.datestring,7,2), 127)
end
go
alter table affectedtable add newDateColumn datetime;
go
update affectedtable
set newDateColumn = dbo.YYYMMDDToDate(oldDateColumn);
alter table affectedtable drop column oldDateColumn;
exec sp_rename 'dbo.affectedtable.newDateColumn', 'oldDateColumn', 'COLUMN';

|||

The trick is that MSSQL recognizes dates in YYYYMMDD format unambigously. So may just convert it twice as:

select cast(cast(20060104 as varchar) as datetime)