At work, sometimes you need to copy all the file names in a folder, this time if you copy the sticky paste, then it is really possible to make you copy to soft. So is there any way to get it done quickly?
1
Enter the Registry Editor, click Start, enter regedit in the search box, and enter.
Then navigate to: Hkey_classes_rootfoldershell, create a new one named "Copylist", then create a new item under it,
View all two-level domain names under a top-level domain
C:\Documents and Settings\administrator>nslookup
[This is the first step of the command.] ' nslookup ' command. ]
Default Server:YOY.mshome.net
address:192.168.0.1
> set Type=ns
[Step two.] ' Set Type=ns ']
> server ns.xinnet.cn
[Step three.] ' Server ns.xinnet.cn ']
Default Server:ns.xinnet.cn
address:202.106.124.195
> LS hoky.org
[Step f
Tags: for dea orm MySQL IDE question inf mysq SQSelect Group_concat (column_name Separator ', ') as column_name from INFORMATION_SCHEMA. COLUMNS WHERE table_name = ' t_tk_question_info ' and table_schema = ' dsideal_db ';Select Group_concat (column_name Separator ', ') as column_name from INFORMATION_SCHEMA. COLUMNS WHERE table_name = ' t_sjk_paper_info ' and table_schema = ' dsideal_db ';Select Group_concat (column_name Separator ', ') as column_name from INFORMATION_SCHEMA. COLUMNS WHERE table
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
Label:--Query database allSELECT (case if A.colorder=1 then d.name else null end) Table name,A.colorder field ordinal, a.name field name,IsNull (G.[value], ") as [description]From Syscolumns ALeft join Systypes B on A.xtype=b.xusertypeINNER JOIN sysobjects D on a.id=d.id and d.xtype= ' U ' and d.nameLeft join syscomments E on a.cdefault=e.idLeft joins Sys.extended_properties G on a.id=g.major_id and a.colid=g.minor_idLeft join Sys.extended_properties F on D.id=f.class and f.minor_id=0Where b.nam
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--query primary keyWHERE (name in(SELECT name from sysindexesWHERE (id = a.id) and (Indid i
Script file See: Https://coding.net/u/hust_wsh/p/GenerateIcons/gitFor use, add a few notes:1. Preparation: Save the Jsx file locally and put it in Photoshop's preset script folder, in the Adobe Photoshop installation directory Presets\deco directory, for example my is in: D:\Program files\adobe\adobe Photoshop CS6 (\presets\deco Bit)2. Open or restart Photoshop, you can see the generateicons in the Script menu, such as:3. Open the corresponding icon PSD file (must), and then click the Generateic
Today in the project shipped to this question, is in the original xib is suitable for all the iphone screen, but now it is necessary to adapt to the iphone also to adapt to the ipad, make a very big, now in order to achieve this effect, the boss gave me two ways, is on the basis of xib modified, Directly on the code, not much to say.The first way: Modify the Xib
1, the original database of the project is SQL Server, now you need to import the original database into Oracle. Now you want to use Java code to get all the table names, whether there is data in the table, and the table data details.2. Open SQL Server, use the command to get all tables select name from SysObjects where xtype= ' U ' ORDER by NAME3. You can connec
Tags: close result blog name connection avoid data table encountered intStart by querying the owner,table_name,comments (description, annotations) of all tables, where owner is the category you want to query Select tcom. OWNER, tcom. Table_name,tcom. COMMENTS
from
all_tab_comments tcom
where
owner= 'sadmin' and Table_type='table '; To count the number of records per table, you can make a nested query, first selecting
When the sheet of an Excel file is more often, it is time to get all the sheet names.XL = PD. Excelfile ('foo.xls') xl.sheet_names # See all sheet names xl.parse (sheet_name) # read a specific sheet to DataFrameYou can also read all the sheet directly and set the SheetName to none. The result is a dict. df = pandas.
Original: Java bulk modify the code for all suffix names in the specified folder with a different suffixSource code: Http://www.zuidaima.com/share/1550463660264448.htmToday there is a need to put a folder under all the suffix named JSP changes to FTL, originally wanted to use bat to implement the BAT's advanced syntax is also not familiar with, and later found th
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 s
Label:C # get all table and column names in an Access databaseString ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + @ "Data Source=e:\report20100819\report20100819.mdb";OleDbConnection Conn = new OleDbConnection (ConnectionString);Conn.Open (); DataTable shematable = conn.getoledbschematable (OleDbSchemaGuid.Tables, new object[] {null, NULL, NULL, "TABLE"});foreach (DataRow Dr in Shematable.rows){
File name/*
* Created on 2004-12-9
* I haven't found a common software that has this feature, so I wrote this class
* You can list files in the CD in TXT file, easy to find in the future, or print out.
* Do not need to find a disc in a CD-ROM to find a CD, slow and loss of optical drive.
* Of course, you can also select a directory to record all the file names under the directory.
*/
/**
* @author Shi Weif
Tags: blog http io color os for SP data onOriginal: SQL Server queries the database for all table names + fieldsSELECT * 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 ' √ '
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 key name5. Queryin
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.