SQL Server Express

RE: import_failure

• by winash

• Database Journal

• Reply

Hi, How about setting the colum type for this column as something like varchar(20) during import and then using the convert(datetime) function to convert this varchar value into a datetime value... -- whoops...the convert datetime for a value like 050203 will convert it to '2005-02-03'...I assume that you need it to be converted to something […]

2003-05-02

How to run a fast querie from a HUGE Database

• by NelsonVere

• SearchSQLServer

• Topic

My database is huge 5 millions records plus. I need run a querie on a way to give the results fast, it's taking 17 minutes to give the results to the user. I'm using sql 2000 and a normal select statement. Any Ideas ??? thanks

2002-03-26

3 reads

Accessing the Code Of A View

• by twosober

• CodeProject.com

• Topic

Is there an easy way (besides copying and pasting) for me to get the actual code from a View stored on my SQL box to an ASP page so that it can be modified and then re-created. Thanks In Advance

2002-03-22

Interview with Author Fernando Guerrero

• by Brian Knight

• Database Journal

• Topic

Comments posted to this topic are about the content posted at http://www.sql-server-performance.com/fernando_guerrero_interview.asp

2002-03-22

3 reads

SQL Server 2000 Installation problem

• by gampsv

• Database Journal

• Topic

I am facing problems in installing SQL server 2000 on a DELL system. It gives me the following error 13:38:53 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER" 13:38:53 Process Exit Code: (267) The directory name is invalid. 14:01:26 A service control operation failed for the MSSQLServer service: 267 The directory […]

2002-03-20

234 reads

Get Children?

• by CMS

• Database Journal

• Topic

I have lots of hierarchical lookup values that are stored in a table with the structure ID INT Parent Char 6 Key Char 6 Value Varchar 50 The nesting level can be up to 8 levels. I need to create a stored procedure that would return a recordset with all children and accepts the key […]

2002-03-19

Microsoft Sets New World Record

• by Brian Knight

• Database Journal

• Topic

Comments posted to this topic are about the content posted at http://www.microsoft.com/sql/evaluation/compare/SAPSales.asp

2002-03-17

3 reads