sql server recover deleted rows

Query all indicateSelect name from sysobjects where xtype= ' u 'SELECT * FROM Sys.tablesQuerying all table names and rows in the databaseSELECT A.name, B.rowsFrom sysobjects as a INNER joins sysindexes as B on a.id = b.IDWHERE (A.type = ' u ') and (B.indid in (0, 1))ORDER by A.name,b.rows DESCQuery all indication and space consumption \ line numberSelectobject_name (ID) tablename,8*reserved/1024 reserved,RTrim (8*dpages) + ' KB ' used,8* (reserved-dpa

The following is a master in the SQL Bar solution, announced. For your reference: Let's say there's a list of school numbers, names, schools, three columns. And then insert it into the table. 040501 Sun Ming Shandong University 040502 Li Hao Shandong Normal University 040503 Wang Gang Yantai University How to insert these three rows of data Ah ~~~~~~~ Copy Code code as follows: Insert Table na

1--Create a test table2 CREATE TABLE [dbo]. [Testrows2columns] (3[Id] [int] IDENTITY (1,1) not NULL,4[UserName] [nvarchar] ( -) NULL,5[Subject] [nvarchar] ( -) NULL,6[Source] [Numeric] ( -,0) NULL7 )8 GO9 Ten--inserting test Data One INSERT into [Testrows2columns] ([Username],[subject],[source]) ASELECT N'Zhang San'N'language', -UNION All -SELECT N'John Doe'N'Mathematics', -UNION All -SELECT N'Harry'N'English', theUNION All theSELECT N'Harry'N'Mathematics', theUNION All -SELECT N'Harry'N'languag