![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
liuyun2008
努力工作,快乐工作,享受生活
展开
-
SQL Server 2005 收缩数据库日志
backup log 数据库名 with no_log dbcc shrinkdatabase (数据库名)原创 2008-07-27 21:57:00 · 726 阅读 · 0 评论 -
怎样找被删除的标识行号 sql server 2005
方法一:use AdventureWorksselect row_number() over(order by DatabaseLogID ) from DatabaseLog exceptselect DatabaseLogID from DatabaseLog 方法二:use AdventureWorksselect * from DatabaseLog order原创 2008-07-27 21:59:00 · 469 阅读 · 0 评论 -
[转] 用ROW_NUMBER()实现取指定行的数据 和从一个表中向另一个表中插入数据并实现某字段每行递增
以下示例将返回行号为 50 到 60(含)的行,并以 OrderDate 排序。 USE AdventureWorks; GO WITH OrderedOrders AS(SELECT SalesOrderID, OrderDate, ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader )转载 2009-04-27 19:51:00 · 680 阅读 · 0 评论 -
(转)人民币小写金额转大写(SQL)
以下转自 http://www.qeqoo.com/dev/database/dbms/3216.html -- ==================================================================== -- Title: 人民币小写金额转大写 -- Author: dobear Mail(MSN): dobear_0922@hotmail.com转载 2009-04-27 19:53:00 · 925 阅读 · 0 评论 -
汉字转换成拼音字头
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].[fun_getPY](@str nvarchar(4000)) returns nvarchar(4000) as begin declare @word nvarchar(1),@PY nvarchar(4000) set @PY=set @str = lt转载 2009-04-27 19:56:00 · 732 阅读 · 0 评论 -
sql server 捕获错误行号
BEGIN TRYselect dbo.change_pycode(order_name) from yz_order_item order by order_code END TRYBEGIN CATCH SELECT ERROR_NUMBER() as ErrorNumber, ERROR_MESSAGE() as ErrorMessageEND CATC转载 2009-04-27 19:49:00 · 666 阅读 · 0 评论