space1000
Last Activity: Jan 18 '08, 03:17 PM
Joined: Aug 6 '07
Location:
-
I should use a temporary table ##table_name and insert there the A column, then the B column, truncate the original table and insert the data from the ##table_name back into the original table. (You will have to write a cursor to enforce the numbering) -
try the charindex command. Use the help (F1) to help you with the syntaxLeave a comment:
-
The system administrator should give the user enough rights on the ntfs system....Leave a comment:
-
Did you create the file with sql server?? Remeber that U can't delete a file wich isn't yours if your not an administrator (windows) or sa(db).Leave a comment:
-
Could U please suply more information ?? error code 500 could mean anything. Please provide the command/ sql youre trying to executeLeave a comment:
-
You're probably not the owner of the dts.Leave a comment:
-
I think you posted at the wrong section.
Sql plus is an oracle tool.
Just run the command from the prompt with the sqlplus.exe and redirect (>) it to an output file.
You should the be able to read the files more clearly (use the pspad viewer, it's free and it can handle long records)Leave a comment:
-
Cool down. I don't have to know the reason why you want to block the port nor why the firewall doesn't want to do that for you. Simply open your network card properties and have a look into the advanced properties. You can block ports on the nic.Leave a comment:
-
I don't get the idea exactly. You could mount the dbf's into sql server and then analyze it all there with some sp's. Thats an easier way I think.
I didn't get the thing about rewriting the record. Please provide more informationLeave a comment:
-
try this one.
CREATE TRIGGER [LW_NO] ON dbo.AP_LIEN
AFTER INSERT
AS
DECLARE @LW INT
SELECT @LW =MAX(LW_NUMBER)
FROM AP_LIEN
UPDATE AP_LIEN
SET inserted.LW_NUM BER = @LW + 1
this way you only update the inserted record.Leave a comment:
No activity results to display
Leave a comment: