SQL Server

All about SQL Server...

rss_feed Subscribe RSS

local_offer SQL Server local_offer t-sql

visibility 4
thumb_up 0
access_time 3 days ago

SQL Server has built-in function HASHBYTES that can be used to calculate hash values. The supported hash algorithms include MD2, MD4, MD5, SHA, SHA1, SHA2_256 and SHA2_512. The signature of this function is: HASHBYTES ( '<algorithm>', { @input | 'input' } ) ...

local_offer SSIS local_offer mssql

visibility 13095
thumb_up 0
access_time 7 years ago

SSIS (SQL Server Integration Service) provides a number of convenient tasks to enable data integration. Exporting data from database to Excel file is a common task in ETL (Extract, Transform, Load) projects. Constantly the users/customers may raise format request regarding the Excel extract. To ...

local_offer sqlite

visibility 685
thumb_up 0
access_time 12 years ago

今天自己使用SQlite数据库的时候创建了一个表 大致是:Create TABLE [Logs]( [LogID] int PRIMARY KEY NOT NULL ,[LogTitle] varchar(100) ,[LogContent] text ,[LogType] int NOT NULL DEFAULT 0 ,[LogAddTime] datetime );

Create Business Reports using SSRS

local_offer plot

visibility 922
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The general requirements for in this scenario are: Sales performance in different areas Sales amount for different products ...

local_offer SQL Server

visibility 893
thumb_up 0
access_time 11 years ago

我们都知道在一个表中当需要2列以上才能确定记录的唯一性的时候,就需要用到联合主键,当建立联合主键以后,在查询数据的时候性能就会有很大的提升,不过并不是对联合主键的任何列单独查询的时候性能都会提升,但我们依然可以通过对联合主键中的首列除外的其他列建立非聚集索引来提高性能。关于索引,可以参考我的这篇文章:http://hi.baidu.com/1987raymond/blog/item/a0f7b11062e1330a213f2e26.html

local_offer SQL Server

visibility 377
thumb_up 0
access_time 12 years ago

个人感觉这个存储过程写得比较的好:转载自:http://www.cnblogs.com/eme/archive/2006/12/19/597275.html

visibility 984
thumb_up 0
access_time 8 years ago

在低版本SQL Server中,对于一些常用的查询功能,我们可能需要运用复杂的逻辑,如临时表,游标等等来实现,这样可能会导致代码难维护,同时产生性能问题。本文将简述用自带的功能去简单的实现这些操作。 注意:一些功能仅在SQL Server 2012以及以上版本支持。 在很多Web应用程序中,我们需要实现分页功能,在过去,我们往往通过top语句实现或者通过ROW_NUMBER;在2012中加入了FETECH以及OFFSET标准SQL中支持的功能。下面的例子是查询第11到20行数据: select bp.Title,bp.CommentCount from ...

visibility 1013
thumb_up 0
access_time 12 years ago

首先,必须知道数据库服务器的地址(IP),连接用户名和密码、其次,可以按照下面几种方式进行:

visibility 949
thumb_up 0
access_time 11 years ago

Keywords: how to attach database without log file

visibility 364
thumb_up 0
access_time 13 years ago

恢复数据库的时候遇到这个错误解决办法