Database

• Can you put the data into an xml format and in the subquery use xquery to fetch the data again
• if you're inserting data into the database using this IN operator, you could use arrays to pass the data to a procedure
• if you're selecting data you can do the same and then return ref cursor
• possibly you could use UDT's in the above scenarios
• you could create a function as pipelined, pass the data to that with an array and then use the return value of the function as a table in your subquery etc.

CREATETRIGGER trigger_Update_ABC ON ABC
FOR Update AS
  UPDATE ABC
  SET ABC.Post = GetDate()
  WHERE ABC.ID IN (SELECT ID from inserted)

papy-boom wrote:

i don't have the column name of SELECT @@IDENTITY how can i manage it to get the value with a column name

papy-boom wrote:

you mean if i replaced by select max from my table it will works?

CREATE TABLE Artist (
   [Artist#] int           NOT NULL IDENTITY(1,1) PRIMARY KEY,
   [Name]    nvarchar(100) NOT NULL
);

INSERT INTO Artist ([Name]) VALUES (@name);
SET @artistIdentity= @@IDENTITY;

papy-boom wrote:

tried to get select @@IDENTITY AS returnedvalue to get the name of column but it doesn't work

papy-boom wrote:

i have a datareader to read the value returned value and the argument to pass to datareader is the name of the column so if my procedure return me a value without the name of column it's not simple to get the value

papy-boom wrote:

the method used in datareder is GetValueParam(Command,columName) the procedure dosen't return a name for this column

SELECT @@IDENTITY AS SomeColumnName

mil_an wrote:

I think the OSQL command is the alternative

OSQL -s <<SERVER_NAME>>\<<DB_NAME>> -U <<USERNAME>> -P <<PASSWORD>> -i <<PATH_TO_SQL_COMMAND_FILE>>

UPDATE <<TABLE_NAME>>
SET <<Column>> = '<<VALUE>>'
WHERE <<PREDICTAES>>
GO

[Shared Memory]SQL Server does not exist or access denied.<br />
[Shared Memory]ConnectionOpen (Connect()).