跟小D每日学口语

文章分类 -  Database

sql server日期时间转字符串
摘要:sql server日期时间转字符串日期时间转字符串Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16 Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06 Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06 阅读全文

posted @ 2011-03-03 06:19 简简单单幸福 阅读(871) 评论(0) 推荐(0)

The ultimate guide to the datetime datatypes
摘要:Updated for SQL Server 2008OverviewThe purpose of this article is to explain how the datetime types work in SQL Server, including common pitfalls and general recommendations.Thanks to SQL Server MVP Frank Kalis, this article is translated to German.There is also a Russian version, thanks to Evgeny V 阅读全文

posted @ 2011-02-15 02:43 简简单单幸福 阅读(322) 评论(0) 推荐(0)

How to format datetime & date with century?
摘要:How to format datetime & date with century?Execute the following T-SQL scripts in Microsoft SQL Server Manangement Studio Query Editor to demonstrate T-SQL convert and cast functions in transforming string date, string time & string datetime data to datetime data type. T-SQL date / datetime 阅读全文

posted @ 2011-02-15 02:35 简简单单幸福 阅读(503) 评论(0) 推荐(0)

dbo.sysobjects type
摘要:select * from dbo.sysobjects where type not in('S','D','K')2008年09月17日 星期三 上午 10:37详解:select * from dbo.sysobjects where type not in('S','D','K')('S','D','K') 值xtype char(2) 对象类型。可以是下列对象类型中的一种: C = CHECK 约束 D = 默认值或 DEFAULT 约束 F 阅读全文

posted @ 2011-02-09 04:50 简简单单幸福 阅读(657) 评论(0) 推荐(0)

The Hidden Costs of INSERT EXEC
摘要:The Hidden Costs of INSERT EXEC INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post I will cover h 阅读全文

posted @ 2011-02-08 12:55 简简单单幸福 阅读(238) 评论(0) 推荐(0)

SQL:JOIN之完全用法
摘要:SQL:JOIN之完全用法2008-04-20 20:28外联接外联接可以是左向外联接、右向外联接或完整外部联接。在 FROM 子句中指定外联接时,可以由下列几组关键字中的一组指定:LEFT JOIN 或 LEFT OUTER JOIN。左向外联接的结果集包括 LEFT OUTER 子句中指定的左表的所有行,而不仅仅是联接列所匹配的行。如果左表的某行在右表中没有匹配行,则在相关联的结果集行中右表的所有选择列表列均为空值。RIGHT JOIN 或 RIGHT OUTER JOIN。 右向外联接是左向外联接的反向联接。将返回右表的所有行。如果右表的某行在左表中没有匹配行,则将为左表返回空值。FUL 阅读全文

posted @ 2011-01-23 03:32 简简单单幸福 阅读(446) 评论(0) 推荐(0)

Sql 基本知识
摘要:-------------------------------------------创建数据库-----------------------------------------------------------------------create database web -- 创建数据库 名为 webon( name=stu, -- 主数据文件名 stu filename="d:\haima... 阅读全文

posted @ 2009-12-17 15:39 简简单单幸福 阅读(152) 评论(0) 推荐(0)

Oracle里时间的应用
只有注册用户登录后才能阅读该文。

posted @ 2009-07-13 09:53 简简单单幸福

oracle中自动增长列
只有注册用户登录后才能阅读该文。

posted @ 2009-07-13 09:53 简简单单幸福

oracle存储过程基本语法
只有注册用户登录后才能阅读该文。

posted @ 2009-07-13 09:50 简简单单幸福