Database

INSERT INTO MyTable(Column1, Column2) VALUES(@value1, @value2);

cmd.Parameters.Add("@value1", someValue)
cmd.Parameters.Add("@value2", someOtherValue)
cmd.ExecuteNonQuery()

joon_ wrote:

is the Select Top functionality or an alternative available in sql server 2000?

joon_ wrote:

SELECT TOP didn't exist before 2005, did it..?

(SELECT * FROM table WHERE [somefield] = 0)<br />
UNION<br />
(SELECT * FROM table WHERE [somefield] <> 0)

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

amnaahmad wrote:

i have to join these three resultsets on a common field

amnaahmad wrote:

But CTE cannot be used in CLR stored procedures? Can it be?

SELECT a.column1, a.column2, b.column3, b.column4, c.column5, c.column6
FROM a
INNER JOIN b ON a.pk = b.fk
INNER JOIN c ON a.pk = c.fk

Zoltan Balazs wrote:

If I have a long Sql query executing that fetches a recordSet what is the best mode
to show a progress to the user?

joon_ wrote:

This would be cumbersome

shriku24 wrote:

i have problem to store audio file in database

byte[] audioData = SomeMethodForGettingTheAudioData();<br />
SqlCommand cmd = new SqlCommand();<br />
cmd.CommandText = "INSERT INTO SomeTable(AudioDataColumn) VALUES (@audioData)";<br />
cmd.Parameters.Add("@audioData", audioData);<br />
cmd.ExecuteNonQuery();

SqlCommand cmd = new SqlCommand();<br />
cmd.CommandText = "SELECT AudioDataColumn FROM SomeTable WHERE ID = @id";<br />
cmd.Parameters.Add("@id", someIdValue);<br />
byte[] audioData = (byte[])cmd.ExecuteScalar();