![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
xiyuansanlian
这个作者很懒,什么都没留下…
展开
-
sqlserver 夸接数据库连接
select * from opendatasource ('sqloledb','Data Source=127.1.1.1;User ID=XXX;Password=XXXX ;database=datebasename;').XXX.dbo.tablename原创 2014-12-26 14:13:42 · 142 阅读 · 0 评论 -
触发器和存储过程
USE [ALM] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[PROC_SYNCH_IRREG_SOFTLIST] AS BEGIN DECLARE @k NVARCHAR(255) DECLARE @j NVARCHAR(255) DE...原创 2014-12-26 15:37:05 · 85 阅读 · 0 评论