SQL Server - 随笔分类 - Snapping

sql server process query

摘要：sp_whosp_who2kill 54 阅读全文

posted @ 2008-07-08 18:15 Snapping 阅读(193) 评论(0) 推荐(0)

The report server cannot decrypt the symmetric key

摘要：http://andreascode.blogspot.com/2006/04/report-server-report-server-cannot.html Report Server: The report server cannot decrypt the symmetric key If you ever come across this error message in SQL S... 阅读全文

posted @ 2008-02-20 11:14 Snapping 阅读(279) 评论(0) 推荐(0)

install report server

摘要：1. uninstall sql server2005, 2. uninstaill vs20053. uninstaill .net framework2.04. install sp3 for sql20005. install report server for sql 2000 xpBut I met the problem error info at the end of the ins... 阅读全文

posted @ 2008-02-20 10:23 Snapping 阅读(318) 评论(0) 推荐(0)

Create table 完整版

摘要：USE SnappingTestGO CREATE TABLE DBO.FreeGift( FreeGiftID int identity(1,1) not null, FreeGiftType char(1) not null default('')) alter table dbo.FreeGift add constraint PK_FreeGift primary key (FreeGif... 阅读全文

posted @ 2007-03-27 14:08 Snapping 阅读(248) 评论(0) 推荐(0)

Update...from...

摘要：update sls.dbo.newegg_somasterset sodate = getdate()from sls.dbo.newegg_somaster ainner join sls.dbo.newegg_soTransaction bon a.sonumber = b.sonumberwhere a.sonumber = 1779881 阅读全文

posted @ 2007-03-27 09:24 Snapping 阅读(141) 评论(0) 推荐(0)

收集：SQL SERVER 未正式开放的分页存储过程

摘要：SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO /*--利用SQL未公开的存储过程实现分页方法简单且效率高,已知的问题就是要多返回一个空的记录集解决的方法是在前台调用时,用 set recordset=recordset.nextrecordset的方法跳过第一个记录集此方法由J9988提供,我只是将它改成了方便调用的存储过程... 阅读全文

posted @ 2007-03-21 16:36 Snapping 阅读(258) 评论(0) 推荐(0)

snapping