C#

msiexec /i myinstaller.msi /q

tasklist /FI "imagename eq msiexec.exe"

select distinct ColumnA from Table1 union select ColumnA from Table2

select Table1.ColumnA from Table1 where Table1.ColumnA not in (select ColumnA from Table2)

select Table2.ColumnA from Table2 where Table2.ColumnA not in (select ColumnA from Table1)

Select A.ColumnA from
A left join B
on A.ColumnA=B.ColumnA
where B.ColumnA is null

Select B.ColumnA from 
B left join A
on B.ColumnA=A.ColumnA
where A.ColumnA is null

Select A.ColumnA from
A join B
on A.ColumnA=B.ColumnA

Wayne Gaylard wrote:

Hope this makes sense.

private void richTextBox1_ContentsResized(object sender, ContentsResizedEventArgs e)
 {
     textBox1.Text = e.NewRectangle.Width.ToString();
 }

 private void button1_Click(object sender, EventArgs e)
 {
     richTextBox1.Font = new System.Drawing.Font("Arial", 36F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
 }

Dave Kreskowiak wrote[^]:

If you have to hit that limit, you've got bigger issues with your application...

It's System.Int32.MaxValue, or 2,147,483,647. But since you wont be able to reach that limit without generating an OutOfMemory Exception, it's limited by available memory.

thatraja

---

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone

kgaurav.kumbhawat wrote:

add around 3000 columns to a dataset table

Mycroft Holmes wrote:

You can find the limitations in MSDN but I don't have a link.

From MSDN[^]:

To add rows to a DataTable, you must first use the NewRow method to return a new DataRow object. The NewRow method returns a row with the schema of the DataTable, as it is defined by the table's DataColumnCollection. The maximum number of rows that a DataTable can store is 16,777,216. For more information, see Adding Data to a DataTable.

thatraja

---

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone