Database

-- First declare the variable
DECLARE @myIntegerVariable int
 
-- Now it can be used.
SET @myIntegerVariable = 12;

-- To get the result of a column in a SELECT statement that returns just one row. 
SELECT @myIntegerVariable = COUNT(*) FROM MyTable;
 
-- To use as a filter in a SELECT statement
SELECT * FROM MyTable WHERE MyColumn = @myIntergerVariable

CREATE PROCEDURE dbo.MyProc
@myFirstParameter int,
@mySecondParameter varchar(20)
AS
-- Do the processing of the Stored Procedure
GO

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

SELECT mineralID, SUM(value)
FROM MyTable
GROUP BY mineralID

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

<br />
CREATE VIEW vw_Mineral_total<br />
AS<br />
SELECT mineralID, SUM(value)<br />
FROM MyTable<br />
GROUP BY mineralID<br />

<br />
CREATE VIEW vw_Mineral_AVG<br />
AS<br />
SELECT mineralID, AVG(value)<br />
FROM MyTable<br />
GROUP BY mineralID<br />

btnOk_Click() Event

getintform1.btnOK_Click(null,null);

....
...
Form1 getintform=new Form1();
...
public Form2()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
getintform.btnOK_Click(null,null);//
// TODO: Add any constructor code after 
}
....
private void Form2_Load(object sender, System.EventArgs e)
{
....
int getmyint;
getmyint=getintform.myint;
....
}