Viewing 15 posts - 1,246 through 1,260 (of 13,849 total)
Yuck!
If you can't change that sync stuff, here is one idea.
Create a table called FileNamesProcessed (or whatever) and write the 'current' file name to that at the end of a...
August 5, 2022 at 8:19 am
Best practice is to archive unzipped files after processing them. Just move them to an Archive folder. That way, you know that anything in your updates folder has not yet...
August 5, 2022 at 7:27 am
--deleted
August 4, 2022 at 5:06 pm
Supplement: As I found out there are 3 more constraints to the same table [tblLookupCountries] which cannot be deleted.
OK, you made it sound like this was something which used...
August 4, 2022 at 11:58 am
According to the MS documentation, error 3737 is "Could not delete file '%ls'. See the SQL Server error log for more information."
What error message are you seeing?
August 4, 2022 at 11:13 am
I will put this rather more forcefully than Steve Collins.
If the following code gives you a varchar/numeric conversion error, there is no doubt at all that the datatypes of the...
August 4, 2022 at 7:16 am
If you remove the existing data from the Excel file, does the new data get written to the file?
August 3, 2022 at 9:40 am
What happens when you run this? Does the existing data in Excel get overwritten, or does the Excel file remain unchanged?
August 2, 2022 at 12:09 pm
You might check the schema change history report (data from default trace).
On the database, right click, choose Reports > Standard Reports > Schema Changes History from context menu.
Good tip....
August 1, 2022 at 4:53 pm
Are you sure you want duplicate rows repeated?
A combination of GROUP BY and COUNT will get you the results you need.
July 31, 2022 at 2:26 pm
Do all of your existing FULLNAME values conform in format exactly to the two examples you have provided? I ask because names are usually much more complicated to fix than...
July 29, 2022 at 2:33 pm
thanks reply ,
I just guess it is Oracle I am not sure , I am new to it .
this ER diagram is from the vendor , they just ask...
July 29, 2022 at 2:26 pm
Do you have access to the database containing this table? If you do, try generating the 'CREATE TABLE' script for it. When you see that, it should help explain what...
July 29, 2022 at 10:28 am
I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far...
July 29, 2022 at 10:20 am
I think I can help with most of that.
P = Primary Key
F = Foreign Key
The PK_ and FK_ are constraint names, these correspond with the P and Fs.
Red asterisk means...
July 29, 2022 at 9:14 am
Viewing 15 posts - 1,246 through 1,260 (of 13,849 total)