摘要:
SQL Cross Join Last update on February 26 2020 08:07:43 (UTC/GMT +8 hours) What is Cross Join in SQL? The SQL CROSS JOIN produces a result set which i
阅读全文
posted @ 2021-05-11 16:45
HuairongChen
阅读(131)
推荐(0)
摘要:
.html <input type="search" autocomplete ="off" />
阅读全文
posted @ 2021-05-05 11:19
HuairongChen
阅读(60)
推荐(0)
摘要:
create table dbo.test1 (id int,name varchar(10))create table dbo.test2 (id int) insert into dbo.test1 values(1,'a')insert into dbo.test1 values(2,'b')
阅读全文
posted @ 2021-04-14 15:13
HuairongChen
阅读(203)
推荐(0)
摘要:
USE XXXGO IF EXISTS(SELECT 1 FROM sys.types WHERE NAME = N'StatusIdList' and is_table_type = 1) DROP TYPE [dbo].[StatusIdList]GO CREATE TYPE DBO.Statu
阅读全文
posted @ 2021-04-07 15:26
HuairongChen
阅读(174)
推荐(0)
摘要:
https://developer.mozilla.org/en-US/docs/Web/CSS/cursor
阅读全文
posted @ 2021-03-31 17:30
HuairongChen
阅读(56)
推荐(0)
摘要:
.css 类 .btnRequest{ font-size: 12px; padding-left: 18px; padding-right: 18px; border-width: 0px; } .selectedButtonStyle{ border-width: 1px; border-col
阅读全文
posted @ 2021-03-16 16:13
HuairongChen
阅读(879)
推荐(0)
摘要:
1.首先需要在对应的库里,创建一个KEY Use Financego OPEN MASTER KEY DECRYPTION BY PASSWORD = 'xxxwdwdjdhaw$lefjhes234fsfjs' goALTER MASTER KEY ADD ENCRYPTION BY SERVIC
阅读全文
posted @ 2021-03-15 11:37
HuairongChen
阅读(416)
推荐(0)
摘要:
<ng-template pTemplate="body" let-item let-i="rowIndex"> <tr [title] = " 'Tran Code : ' + item.tranCode + '\n' + 'Tran Code Description : ' + item.tra
阅读全文
posted @ 2021-03-08 10:27
HuairongChen
阅读(553)
推荐(0)
摘要:
select left('abcd',3) --'abc' select right('abcd',3) --'bcd' select SUBSTRING('abcd',2,8) --'bcd'
阅读全文
posted @ 2021-02-23 11:34
HuairongChen
阅读(304)
推荐(0)
摘要:
在数据库中,如果希望比对某个日期,是不是比当前时间相差的天数 例如:下一次付款的日子,要比当前时间减去30天 NEXTPAYDT >= dateadd(dd,-30,getdate()) 在C#中,如果希望获得新的制定日期 例如:当前时间的下两个月的1号 var NewDate = DateTime
阅读全文
posted @ 2021-02-23 11:04
HuairongChen
阅读(53)
推荐(0)