Viewing 15 posts - 6,646 through 6,660 (of 7,429 total)
Even if the table is ordered by date it will not help you when querying that column on such a huge table as the query has to read each item....
March 27, 2002 at 9:51 am
Type sp_who and find the connections to your database and the SPID they are connected with. Then type KILL (SPID) and it will try to stop their query and disconnect...
March 27, 2002 at 9:26 am
Duh, I read that, I guess it is time to go back to sleep. I will look around, I saw code like this here somewhere on how to search and...
March 27, 2002 at 9:24 am
I believ in the case on IsDate it actually performs a type change and looks for a return error which means cannot be formatted to that datatype. I am have...
March 27, 2002 at 9:17 am
You could use REPLACE function for each possiblity.
Ex. REPLACE(fldName,'<HTML>','')
But if you can be more specific exactly what is in the field might have something better out there.
"Don't roll your eyes...
March 27, 2002 at 9:09 am
Must be as VB itself never has given me any trouble. I will have to play with a bit one day to be sure what actually does what.
Never mind, I...
March 27, 2002 at 9:03 am
You parameters do not match with the ADO objects being sent thru or the sizes. Change this
cmd.Parameters.Append cmd.CreateParameter("StartDate", addatetime, adparamInput, 8)
cmd.Parameters.Append cmd.CreateParameter("AddDays", adInteger, adparamInput, 4)
cmd.Parameters.Append cmd.CreateParameter("NewDate", addatetime, adparamReturnValue, 8)
to
cmd.Parameters.Append cmd.CreateParameter("StartDate",...
March 27, 2002 at 8:58 am
First note this is for SQL 7 only and should not be used for 2000 as each DB have it's
own setting, also doing this on 7 will change the sort...
March 27, 2002 at 5:48 am
Correction to all that read this
First note this is not a method I have seen anywhere else and may not work (just a theory).
If you try please let me...
March 27, 2002 at 5:45 am
Try this
DECLARE @SQLString AS VARCHAR(400)
Declare @tablename as varchar(30)
set @tablename = 'TMP_BREAKDOWN_B1'
SET @SQLString = 'CREATE TABLE [' + @tablename + '](
ID_reason int,
ID_Subreason int,
LNE varchar(2)
)'
EXEC(@SQLSTring)
Etc.....
The create table function will not accept a...
March 27, 2002 at 5:00 am
I think you should take them out and flog the whole lot. Glad you found the problem though.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
March 27, 2002 at 4:57 am
Oddly enough all 3 returned 1 for me. What language are you setup with for date formating?
Sorry more specifically set default for me these all return 1. If I do...
March 27, 2002 at 4:47 am
Try this
'Note: variables in VBScript are only of the variant type so you do not declare type.
Dim DATABASE
Dim cmd
Dim params
Set DATABASE = Server.CreateObject("ADODB.Connection")
DATABASE.Open Application("DATABASE_ConnectionString")
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = DATABASE
cmd.CommandText...
March 26, 2002 at 6:03 pm
Steve's right, has always been said email has to be MAPI compliant, as for the NT4 2000 issue, 2000 should not have any issues with this.
"Don't roll your eyes at...
March 26, 2002 at 5:51 pm
Try
BACKUP LOG [dbname]
WITH TRUNCATE_ONLY
this should free up the space in the log so you can delete the secound file.
"Don't roll your eyes at me. I will tape them in place."...
March 26, 2002 at 5:49 pm
Viewing 15 posts - 6,646 through 6,660 (of 7,429 total)