Search results for query: *

Thank You very much [Smile]

Hi all i think this is a long shot but: i was just wondering if it is possible to execute a stored procedure from an ASP page but not wait for it to complete before the rest of the page is loaded the stored procedure i am executing insert thousands of records into a database and takes a long...

Hi all I have just started working with stored procedures and i have a SP called SMS_RatioBarReport which calls the SP SMS_Ratio and then uses this value and inserts it into a temporary table. this is the SP I call ********************************************************** CREATE PROCEDURE...

Hi all I am trying to update a record where the date is equal to blah blah UPDATE v4_StatusLog SET [minutes]=301 WHERE PC_ID =125 AND PhoneId=1 AND DateStamp='16/12/2002' I have tried it without the comment marks but this still doesn't work has anyone got any ideas

Hi Everyone I am connecting to SQL Server through ODBC, i think i have connected using shared access to the database and also read and write access. The program i am running is selecting from the database fine, When it comes to inserting the project doesn't bomb out but it does not insert the...

Hi Andy I have been using DTS and the error i get relating to these columns is Insert error, column 14 ('TimeStamp',DBTYPE_DBTIMESTAMP) Status 6 Data Overflow. Invalid character value for cast specification. Any Solutions Thanks Danielle

I am having Problems importing data into SQL Server from Access database. The column is in date/time, LongTime format in access. I have tried copying it over just table to table and it doesn't work. Can anyone reccomend how i copy this data over and the best datatype for the SQL Server column...