![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL SERVER
huayang912
这个作者很懒,什么都没留下…
展开
-
SQL SERVER – Random Number Generator Script – SQL Query
<br />Random Number Generator<br />There are many methods to generate random number in SQL Server.<br />Method 1 : Generate Random Numbers (Int) between Rang<br />---- Create the variables for the random number generation<br />DECLARE @Random INT;<br />DEC原创 2010-11-12 14:40:00 · 888 阅读 · 0 评论 -
sql_add_remove_descripton
<br />DECLARE @table VARCHAR(50) ,<br /> @field VARCHAR(50)<br />SELECT @table = MIN(name)<br />FROM dbo.sysobjects<br />WHERE xtype = 'U' <br /><br />WHILE @table IS NOT NULL <br /> BEGIN<br /> <br /> SELECT @field = MIN(COLUMN_NAME原创 2010-06-09 09:36:00 · 384 阅读 · 0 评论 -
去掉sql server 字段中的回车
<br />比如 CustomerInfo 中有字段 Customer_DutyEMail 中可能有回车,则用如下语句去掉回车<br /> <br /> UPDATE dbo.CustomerInfo SET Customer_DutyEMail = replace(replace(Customer_DutyEMail,char(10),''),char(13),'')原创 2010-06-09 09:33:00 · 1088 阅读 · 0 评论 -
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
SERVER – 2008 – Configure Database Mail – Send Email From SQL DatabaseAugust 23, 2008 by pinaldave Today in this article I would discuss about the Database Mail which is used to send the Email原创 2010-05-07 12:55:00 · 966 阅读 · 0 评论 -
解决大批量数据TransactionScope出错问题
TransactionScope 是.net 提供的可提升<span class="t_tag" onclick="function onclick(){function onclick(){tagshow(event)}}">事务环境,开发软件的时候非常方便,但是在大数据量处理的时候,会莫名我出错,检查代码没有任何的错误 解决这个错误的方法:不用TransactionSc原创 2010-04-06 22:30:00 · 2832 阅读 · 0 评论 -
How To Split column In SQL
SET NOCOUNT ON DECLARE @Table table (Col001 varchar(100) NOT NULL) INSERT INTO @Table VALUES(AABY TAMARA J)INSERT INTO @Table VALUES(AADNESEN MARJORIE)INSERT INTO @Table VALUES(Paol原创 2010-04-02 14:19:00 · 718 阅读 · 0 评论 -
ReportViewer 错误
Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel.dll http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/38797563-69ab-4b40-8807-22ea2966475a原创 2010-03-24 16:39:00 · 590 阅读 · 0 评论 -
T4 template for generating SQL view from C# enumeration
Database tables often contain columns that store “codes”, or values with special meaning. In application code, these special values can be encapsulated as enumerations. This article demonstrates how原创 2010-02-07 20:19:00 · 1367 阅读 · 0 评论 -
SQL Server 2005: Recursive Hierarchies to XML
Suppose we have a recursive hierarchy stored in a relational database and we want to write it to XML. This might be for a variety of reasons – e.g. as a pre-cached input to a UI control, to export to转载 2010-02-07 19:32:00 · 447 阅读 · 0 评论