- 博客(3)
- 资源 (19)
- 收藏
- 关注
转载 V_AllTable 表信息 数据库 SQL2008
<br />SELECT TOP (100) PERCENT d.name AS TableName, a.colorder AS Orders, a.name AS FieldName,<br /> (CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIdentity') = 1 THEN '√' ELSE '' END) AS Identitys,<br /> (CASE WHEN (SELECT CO
2010-08-10 13:02:00 585
转载 TinfoAll 查询所以表关系
<br /><br />create FUNCTION [dbo].[TinfoAll] RETURNS TABLE AS <br />RETURN <br />select TOP 100 PERCENT * from (<br />select<br /> -- tabledesc,<br /> all_name,<br /> column_id = convert(varchar(100),column_id),<br /> columnname,<br
2010-08-03 14:00:00 480
原创 sql日期格式
CREATE FUNCTION [dbo].[DateValue] (@time smalldatetime)RETURNS smalldatetime WITH SCHEMABINDING AS BEGIN --RETURN CONVERT(smalldatetime, CONVERT(char(8), @time, 112), 112) --2005RETURN cast( CONVERT(char(8), GETDATE(), 112) as DATE) --2008END
2010-08-03 09:34:00 443
dll注册信息查看
2019-02-27
用了好几年的树形笔记本项目管理软件 myBase-Desktop_6.3.4 汉化注册版本
2017-08-09
pdf编辑工具PDF Editor
2011-08-26
键盘鼠标录制回放器-AutoCAD中 实现宏功能
2011-08-26
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人