using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string __conStr = @"Data Source=(local)\S2005;Initial Catalog=Demo;Integrated Security=SSPI";
using (SqlConnection con = new SqlConnection(__conStr))
{
con.Open();
string __spName = "MyUsp";
string __tblName = "Customers";
string __sQuery = "";
__sQuery += "CREATE PROCEDURE " + __spName + "\r\nAS\r\n";
__sQuery += "Begin\r\n";
__sQuery += "SELECT * FROM " + __tblName + "\r\n";
__sQuery += "End\r\n";
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = __sQuery;
try
{
cmd.ExecuteNonQuery();
}
catch { }
con.Close();
}
}
}
}