Database

jaganil wrote:

my SQL Query is ---
select * from t_ItemPriceMaster Group BY c_DateForm Having ( ( max( c_DateForm )and c_SoftDelete='1')";

wrote:

where dataset tables stored ?

DataSet ds = GetDatasetFromDb();
if (ds != null && ds.Tables.Count > 0)
{
  foreach (DataRow row in ds.Tables[0])
  {
    // Do something
  }
}

SELECT MSysObjects.Name<br />
FROM MSysObjects<br />
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1));<br />

<br />
                foreach <br />
                ( <br />
                    System.Data.DataRow dr <br />
                in <br />
                    ((System.Data.OleDb.OleDbConnection) this.dbc ).GetOleDbSchemaTable<br />
                    (<br />
                        System.Data.OleDb.OleDbSchemaGuid.Tables<br />
                    ,<br />
                        new object[] { null , null , null , "TABLE" }<br />
                    ).Rows <br />
                )<br />

CREATE ASSEMBLY MyAssembly FROM 'c:\dev\MyAssembly.dll'
WITH PERMISSION_SET = SAFE

CREATE FUNCTION MyFunction(@Name NVARCHAR(30))
RETURNS INT
AS EXTERNAL NAME [MyAssembly].[MyDll.ClassName].[MyMethod]

FreeCastle wrote:

Mh yes it helps again But I think that I am somehow to stupid...

FreeCastle wrote:

In my c#-code I see that the implemented storedprocedure MyStoredProc has an output parameter with type of SqlGuid (which is a uniqueidentifier (I think)).

I have also another stored procedure that hasn't any output parameter, but which return value should I specify there ? NULL doesn't work

CREATE TRIGGER [InsertIntoTable2] ON [Table1] 
FOR INSERT
AS

INSERT INTO Table2
SELECT (Field1, Field2, (and so on)) FROM INSERTED