That will work too.

or you can do this....

insert into TableName(FieldName) select current_timestamp

Hi,

I am not sure what you are trying to do. But, I assume that you want to test how backup can recover up to the point the SQL got corrupted...

This often happens if the data is too big... but it could also be corrupted. Does the query bound to a link sql tables?

Did you try pinging the host were the instance is running? This could narrow down the troubleshooting, eliminating that network is not an issue.

I would also try connecting using odbc...

I am not sure as well so I posted my 2 cents of Eg. that will work with both version. I apologize, I think we crossed postings.

Cheers...

Another thing is ...

DELETE #temp

OUTPUT DELETED.*;

in the following DELETE statement returns all columns deleted from the #temp table

Before deletion you can insert the data you want to delete in a new #temp table using the sub query below. Eg.

create table #tempDEL ('id','data_type',...)

...THEN

insert into #tempDEL (select t1.id...

Hi,

Looks like you are missing a field here...

Here is the syntax... Please review again.

[Database].[dbo].[Table].[Fields]

Hope this helps... Koncentrix

Check this approach... Simple and effective as well.

SELECT

S.ServiceId,

STUFF(

(

SELECT ',' + [Description]

...

Hi...

You should Link or relink the tables to the new datasource, which is the SQL Database.

You should be able to achieve this using Link Tables in MS Access.

Thank you... Hope...

A Link from SQL Tables to MS Access should help joined both the local and the SQL objects.

This should be an easy way for you to append data from ms...

Hi...

After migrating to SQL. MS Access cannot control the table objects security - You must control it in SQL Database using SQL manager.

However on the other hand. You should...

Given you are using MS Access.

You can achieve the output by writing 2 querries...

1. query with the distinct filename

2. using crosstab with the filename col and AKA code being transposed

You...

MS Access is also a flat file. Every time you open a file a session is openned in computer management session folder. So, there is a way to kill that...

Try this approach...

SELECT STUFF((SELECT ', ' + Table.ColumnName FROM Table FOR XML PATH('')),1, 2, '') AS CSVField

Try to do a REPLACE of contents with ampersand.

Thank you... Hope this helps.