sql server copy table to another database

if exists (select 1 from sysobjects where name = ' Sysproperties ' and xtype = ' V ')BeginDROP VIEW syspropertiesEndGOCREATE VIEW syspropertiesAsSELECT class as id,minor_id as smallid,* from sys.extended_properties-------Get the table structure in SQL Server 2005, execute the above statement firstSELECTTable name = Case A.colorder If 1 then c.name ELSE ' END,Orde

Tags: Log procedure create pre from creat exec space beginTo create a stored procedure: CREATE PROCEDURE [dbo].[Sys_viewtablespace] as BEGIN SETNOCOUNT on; CREATE TABLE [dbo]. #tableinfo (table name[varchar]( -) COLLATE Chinese_prc_ci_asNULL, number of records[int] NULL, reserve space[varchar]( -) COLLATE Chinese_prc_ci_asNULL, use space[varchar]( -) COLLATE Chinese_prc_ci_asNULL, the index occupies spac

Get extended properties for all dbo tables:SELECT * from fn_listextendedproperty (null, ' schema ', ' dbo ', ' table ', default, NULL, NULL)The approximate result:ObjType objname Name ValueTable name extended property name valueTo get the extended properties of a table:SELECT * FROM:: Fn_listextendedproperty (null, ' user ', ' dbo ', ' table ', ' name ', ' column ', NULL)Name=ms_description is a system-prov

Label:In the first case, append the data from the a database. dbo.a table to the B database. DBO.B table (condition: B table is already created in the B database )Inert into B database.

Tags: style blog color io data div SP CTI Log--determine if the database existsif exists(Select * fromsys.databaseswhereName= 'Database name')Drop Database [Database name]--determine if a table existsif exists(Select * fromsysobjectswhereId= object_id(N'[

DECLARE @name varchar, @newname varchar (@colname varchar) DECLARE ABC cursor for Select (a.[name] + '. ' + b.[name]) as TableName, b.[name] colname From dbo.sysobjects A, dbo.syscolumns b where a.id = b.ID and a.xtype= ' U ' Open ABC Fetch next from ABC into @name, @colname While @ @fetch_status =0 begin Set @newname =Upper (@colname) EXEC sp_rename @name, @newname, [COLUMN] Print @colname print @NEWNAME Fetch next from ABC into @name, @colnam

Tags: end col insert signed cut Sig EFI mit nbsp Dynamically copy data from one table to another table based on table data Copy the track table records to the corresponding track_ according to the mac_id two digits. In the

server| Data | database In fact, as long as the use of the system built-in stored procedures sp_spaceused can get information about the table such as: sp_spaceused ' tablename ' The following is a stored procedure for easy writing, which is to save all information about the current table in a specified

1. number of records in each tableSelect A.name as Table name , Max (b.rows) as number of record strips From sysobjects A, sysindexes bwhere a.id=b.id and a.xtype= ' u 'GROUP BY A.nameORDER by Max (b.rows) desc2. Total number of recordsSelect SUM( number of records ) as total record Count from( 　　Select Top 10000 a. Name as table name ,Max(b. Rows) as record number from sysobjects a ,sysind

Tags: io color for SP data on BS AD EFSELECT * from Information_schema.columns WHERE table_name= ' account 'SELECT(Case time A.colorder=1 then d.name Else ' end) as table name,--returns null if the table name is the sameA.colorder as Field ordinal,A.name as field name,(Case is ColumnProperty (a.id,a.name, ' isidentity ') =1 then ' √ ' else ' end) as identification,(Case if (SELECT count (*) from sysobjects-

declare @low int, @unit varchar (), @val decimal (18,4)Set @unit = ' KB 'Set @val = case when @unit = ' KB ' then 1024x768 when @unit = ' MB ' then 1024*1024 else 1 endSelect @low = D.low from Master.dbo.spt_values dwhere D.number = 1 and D.type = ' E 'SELECT A.name, B.rows, LTrim (str (b.reserved * @low/@val, 15,0) + "+ @unit), LTrim (str (b.used * @low/@val, 15,0) + "+ @unit)From sysobjects as aINNER JOIN sysindexes as B on a.id = b.IDWHERE (A.type = ' u ') and (B.indid in (0, 1))ORDER by B.ro

MySQL is very powerful, support direct copy database file Quick Backup, where is the database file?Open the MySQL configuration file My.iniand locate the datadir node, asDatadir= "D:/program files/mysql/mysql Server 5.1/data"Enter the above folder, you can see the new database