摘要:
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 阅读全文
摘要:
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') 阅读全文
摘要:
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 阅读全文
摘要:
1.首先需要在对应的库里,创建一个KEY Use Financego OPEN MASTER KEY DECRYPTION BY PASSWORD = 'xxxwdwdjdhaw$lefjhes234fsfjs' goALTER MASTER KEY ADD ENCRYPTION BY SERVIC 阅读全文