At the Foxpro, it can controll with INDBC command which field be or not at a file.
Like : (FoxPro)
IF INDBC(_seek,"FIELD") = .F.
ALTER TABLE mal ADD COLUMN ("d" + ALLTRIM(STR(mary))) i NULL
ENDIF
At the Ms-Sql2000 Stored procedure I did a sample as follow. And I had trouble :
1- the row of "ALTER TABLE mal ADD @depo money null" it gives back syntax error for @depo
2- How can I get(handle) a field be or not at a file.
Note : I want to do this operations inside of the stored procedure.
Thanks
Sample code of SQL :
USE foxsql
DECLARE @depo nvarchar(9)
DECLARE depo_hrk CURSOR FOR
SELECT DISTINCT 'depo_' + cast(depo as nvarchar(4)) as depo FROM hrk ORDER BY depo
OPEN depo_hrk
FETCH NEXT FROM depo_hrk INTO @depo
WHILE @@fetch_status = 0
BEGIN
ALTER TABLE mal ADD @depo money null
FETCH NEXT FROM depo_hrk INTO @depo
END
CLOSE depo_hrk
deallocate depo_hrk