易截截图软件、单文件、免安装、纯绿色、仅160KB

连接ms sql数据库写法

windows 集成验证:
<connectionStrings>
   <add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;database=Test;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
  </connectionStrings>
或者
<connectionStrings>
<add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;Initial Catalog=Test;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
混合验证:
<connectionStrings>
      <add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;Initial Catalog=Test;uid=sa;pwd=caipeng" providerName="System.Data.SqlClient"/>
  </connectionStrings>
取ConnectionStr:
string conn=System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;


相关文档:

SQL 获取列名 利用系统表

SELECT sysobjects.name,syscolumns.name
from  sysobjects,syscolumns
WHERE(sysobjects.id=syscolumns.id)
select col_name(OBJECT_ID('staff'),17)
select name
from syscolumns
where id=object_id('你的表名'); ......

sql查找重复数据

1.查找重复数据表的id以及重复数据的条数
select max(id) as nid,count(id) as 重复条数 from tableName
group by linkname Having Count(*) > 1
2.查找重复数据表的主键
select max(id) as nid from tableName
group by linkname  Having Count(id) > 1
3.删除重复的数据
delete from table ......

Auto process Cube with SQL Agent job

(1)     Connect to the Analysis server, select the database which we want it to be automatically processed. Right click on this database, choose ‘Process’:
(2)     In the opening ‘Process database’ form, click the ‘Script Action ......

PL/SQL集锦

--设置数据库输出,默认为关闭,每次新打开窗口都要重新设置
set serveroutput on
--调用     包           函数    参数
execute dbms_output.put_line('hello world');
--或者用call调用,相当于java中的调试程序打桩
call d ......

SQL Server 2005 不允许远程连接解决方法

刚刚安装的数据库系统,按照默认安装的话,很可能在进行远程连接时报错,通常是错误:"在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接) "搜MSDN,上面有一片机器翻译的文章,是在让人难以明白,现在 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号