Viewing 15 posts - 1 through 15 (of 17 total)
That will work too.
or you can do this....
insert into TableName(FieldName) select current_timestamp
June 15, 2010 at 12:57 pm
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...
June 15, 2010 at 10:49 am
This often happens if the data is too big... but it could also be corrupted. Does the query bound to a link sql tables?
April 26, 2010 at 12:30 pm
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...
April 23, 2010 at 2:27 pm
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...
April 23, 2010 at 12:34 pm
Another thing is ...
DELETE #temp
OUTPUT DELETED.*;
in the following DELETE statement returns all columns deleted from the #temp table
April 23, 2010 at 12:19 pm
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...
April 23, 2010 at 12:03 pm
Hi,
Looks like you are missing a field here...
Here is the syntax... Please review again.
[Database].[dbo].[Table].[Fields]
Hope this helps... Koncentrix
April 22, 2010 at 1:44 pm
Check this approach... Simple and effective as well.
SELECT
S.ServiceId,
STUFF(
(
SELECT ',' + [Description]
...
April 22, 2010 at 11:45 am
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...
April 17, 2010 at 8:45 am
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...
April 17, 2010 at 8:42 am
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...
April 17, 2010 at 8:35 am
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...
April 17, 2010 at 8:25 am
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...
April 17, 2010 at 8:17 am
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.
April 17, 2010 at 8:05 am
Viewing 15 posts - 1 through 15 (of 17 total)