sql server synchronize tables between databases

the table and delete the table are as follows:Use Studbif exists (select * from sysobjects where name= ' Stumarks ')drop table StumarksCREATE TABLE Stumarks( Examno int identity (primary) key, Stuno char (6) NOT NULL, Writtenexam int not null, Labexam int not null)Go--Where the column attribute "identity (start value, increment)" means "Examno" is automatically numbered, also known as the identity columnALTER TABLE table nameAdd constraint constraint name

" and enter the corresponding port number SQL database Synchronous replication I. Establish a publishing and distribution server [Welcome to the Configure Publishing and Distribution Wizard]->[Select Distributor] ->[makes "@servername" its own distributor, SQL Server creates distribution

Label:MS SQL Server 1, querying all tables select [ID], [name] from [sysobjects] where [type] = ' u ' ORDER BY [name] 2, querying all Databases 3, select [Name] F ROM [sysdatabases] ORDER BY [Name] Query table field select [Name] from [syscolumns] where [name] = ' tablexxx ' ORDER by [Colid] Oracle 1. Find all indexes

name, the table name of the reference table and the corresponding key name, the following is divided into multi-step query):SELECT * from user_constraints c where c.constraint_type = ' R ' and c.table_name = table to queryQuery the column name of the FOREIGN KEY constraint:SELECT * from User_cons_columns cl where cl.constraint_name = FOREIGN key NameQuery the column name of the key referencing the table:SELECT * from User_cons_columns cl where cl.constraint_name = foreign key reference table ke

Section - class - database Development and ADODatabase SQl, creating databases and Tables , Adding and deleting statements , Constraints , Top and the Distinct, Introduction to Aggregation functionsGetting Started with SQL statements (scripts, commands)SQL full name is a st

To create the SQL statement for the database:1 UsePractice2 Go 3 if exists(Select * fromsysobjectswhereName='Practice')4 Drop Tablestore_information5 Create Tablestore_information6 (7StoreIDint Identity(1,1)Primary Key,--Column Properties "Identity (start value, increment amount)"8Store_namevarchar not NULL,9Store_moneydecimal NULL,TenStore_date Date not NULL, One)To delete a database, SQL

This article introduces two stored procedures that are very useful in the master database but not mentioned in SQL Server online textbooks. These System The process is very convenient for processing the following tasks, such as determining the storage space used, the number of rows, and the user table index. In the first process, sp_msforeachdb executes three commands for each database on the

Tags: style blog http io color using SP strong fileData backup has always been considered a database of life, that is, one of the main skills of a DBA, this article is about the SQL Server backup principle, the SQL Server database is divided into data files and log files. To enable the database to recover a consistent

1. When I first created an Oracle database table, I wanted to execute multiple tables at a time. I did not expect to click Executestatement, and I always reported a syntax error. You can refer to ExecuteasScript to create multiple tables. 2. I cannot import data from the Access Database today. First, my Access database has a password. 1. When I first created an Oracle database table, I tried to create mult

Recently, data is being input into the Oracle database. The number of tables in the database is large, and there are many data records in some tables. Some have fewer data records. At the beginning, a few tables are input into the database, I found that the data volume in the table was too large. I was wondering if I could use one-time data input. I found it onli

Next let's take a look at our commonly used drop function. This is used in mysql mssql access to delete SQL drop statements, Delete tables, delete databases, and delete indexes. Let's take an example here. Drop index Delete index Access:Drop index index_name ON table_name Mssql:Drop index table_name.index_name Mysql index deletion:Alter table table_name drop

generation state)GO --6, building a data dictionary tableCREATE TABLE arch_dict(ID INT not NULL,Dtype CHAR (2) not NULL,--typeDkey CHAR (4) Not NULL,--keyDvalue CHAR (4) not NULL,--valueSorting Sn INT,--IsValid TINYINT,--is effectiveDescrip NVARCHAR (200)--Dictionary description information)GO --7, set up the archive parameter tableCREATE TABLE Arch_parameter(ID INT not NULL,Archtype CHAR (4) Not NULL,--archive typeBegindate datetime,--Archive Start dateEndDate datetime,--Archive End DateOrgID