Sqlserver的一些小笔记

1）获取实例名：SELECT @@SERVERNAME ,serverproperty('servername')

2）复制database1的table1到database2：

在database1的table1上右键->编写脚本为（s）->CREATE 到（C）->（点击）新查询编辑器窗口，就会出现该表的建表语句。然后把数据库改为database2，执行建表语句即可！

USE [statementlh]
GO

/****** Object:  Table [dbo].[account_bill]    Script Date: 2018/9/29 15:41:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[account_bill](
	[CLEAR_DATE] [varchar](8) NOT NULL,
	[TRANS_DATE] [varchar](8) NULL,
	[TRANS_TIME] [varchar](6) NOT NULL,
	[MRCH_NO] [varchar](19) NOT NULL,
	[TERMINAL_NO] [varchar](19) NOT NULL,
	[TRANS_TYPE] [varchar](20) NULL,
	[CARD_NO] [varchar](26) NULL,
	[TRANS_AMOUNT] [varchar](19) NULL,
	[CLEAR_AMOUNT] [varchar](19) NULL,
	[POUNDAGE] [varchar](10) NULL,
	[REFER_NO] [varchar](16) NULL,
	[FLOW_NO] [varchar](20) NULL,
	[CARD_TYPE] [varchar](32) NULL,
	[BANK] [varchar](40) NULL,
	[ORDER_NO] [varchar](32) NULL,
	[ORIGINAL_PAY_REFER_NO] [varchar](16) NULL,
	[MEMO_FIELD] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[CLEAR_DATE] ASC,
	[MRCH_NO] ASC,
	[TERMINAL_NO] ASC,
	[TRANS_TIME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

如果要将database1的table1表的数据插入database2的table1中，在database2中执行以下代码即可。

insert into [表名字] select * from database1.dbo.table1