Sql Server数据库

来源:互联网 发布:js注释快捷键 编辑:程序博客网 时间:2024/05/22 20:01

1,安装结果没有 SQL Server Manager Studio

2,Server=(local)\\SQLEXPRESS;Database=master;Trusted_Connection=True

using System;using System.Data.SqlClient;namespace Demo{    class Program    {        static void Main(string[] args)        {            string str = "data source =localhost;Database=master;integrated security=SSPI";            SqlConnection conn = new SqlConnection(str);            conn.Open();            string sqlStr = "SELECT * from master.dbo.spt_fallback_db;";            SqlCommand com = new SqlCommand(sqlStr,conn);            SqlDataReader sr = com.ExecuteReader();            Console.WriteLine(sr.GetName(3));            conn.Close();            Console.ReadKey();        }    }}


0 0
原创粉丝点击