Database

IF NOT EXISTS (
  SELECT * 
  FROM   sys.columns 
  WHERE  object_id = OBJECT_ID(N'dbo.Cases') 
         AND name = 'DocketNumber'
)
BEGIN
    ALTER TABLE [dbo].[Cases]
        ADD [DocketNumber]              NVARCHAR (50)   NULL
END

Private Sub ExportTable()
      Dim rdr As SqlDataReader = Nothing

      Using SW As New StreamWriter("c:\temp\zMyTable.txt")
          Using sqlconn As New SqlConnection("<put your connection string here>")
              sqlconn.Open()

              Using sqlcmd As New SqlCommand("SELECT * FROM <some desired table>", sqlconn)
                  rdr = sqlcmd.ExecuteReader
                  While (rdr.Read)
                      Call ReadSingleRow(SW, "~", rdr)
                  End While
                  rdr.Close()

              End Using
          End Using
      End Using

  End Sub

  Private Sub ReadSingleRow(sw As StreamWriter, delim As Char, datareader As SqlDataReader)
      Dim i As Integer

      For i = 0 To datareader.FieldCount - 1
          If (i > 0) Then sw.Write("{0}", delim)
          sw.Write("{0}", datareader(i))
      Next
  End Sub

public void ExportTable()
{
    SqlDataReader rdr = null/* TODO Change to default(_) if this is not a reference type */;

    using (StreamWriter SW = new StreamWriter(@"c:\temp\zMyTable.txt"))
    {
        using (SqlConnection sqlconn = new SqlConnection("<put your connection string here>"))
        {
            sqlconn.Open();

            using (SqlCommand sqlcmd = new SqlCommand("SELECT * FROM <some desired table>", sqlconn))
            {
                rdr = sqlcmd.ExecuteReader;
                while ((rdr.Read))
                    ReadSingleRow(SW, "~", rdr);
                rdr.Close();
            }
        }
    }
}









Convert Code 

public void ExportTable()
{
    SqlDataReader rdr = null/* TODO Change to default(_) if this is not a reference type */;

    using (StreamWriter SW = new StreamWriter(@"c:\temp\zMyTable.txt"))
    {
        using (SqlConnection sqlconn = new SqlConnection("<put your connection string here>"))
        {
            sqlconn.Open();

            using (SqlCommand sqlcmd = new SqlCommand("SELECT * FROM <some desired table>", sqlconn))
            {
                rdr = sqlcmd.ExecuteReader;
                while ((rdr.Read))
                    ReadSingleRow(SW, "~", rdr);
                rdr.Close();
            }
        }
    }
}

foreach (string s in scripter.EnumScript(new Urn[] { table.Urn }))
            {
                sb.Append(s);
                sb.Append(Environment.NewLine);
}

Ebrahimaw wrote:

SQL Server in Visual Studio 2019

Ebrahimaw wrote:

SQL Server Management Studio

Ebrahimaw wrote:

SQL Server in Visual Studio 2019?

Ebrahimaw wrote:

Can I use it in Visual Studio 2019 for Large database

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.