first names with apostrophes

In the development often encountered to put multiple IDs together with a symbol to separate the incoming database, that split is a big dealSELECTNpushid into#Temp fromTable1WHERE CHARINDEX(',' + CONVERT(VARCHAR(Ten), NCOULMN)+ ',',',' + '3305,3311,3314' + ',')> 0SELECT * from#TempThe columns here are for the int type, so you want to convert.For orders that order the master-slave table, from the table multiple names are stitched together--Instanc

Under what circumstances will the keyword be used as the column name, I feel1. The corresponding database does not know the corresponding column name is the keyword (did not try to create a table when the column name is specified as the keyword will not error)2. Database migration, from one database to another type of database, the original database platform, not the keyword column name is a keyword.Under SQL Server, if you update the keyword column, you can use double quotation marks or bracket

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 ' √ ' else ' end) as identification,(Case if (SELE

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

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){Console.WriteLine (dr["table_name"]);DataTabl

Reprint please indicate the source, thank http://blog.csdn.net/harryweasley/article/details/46557807The main purpose of this blog is to describe how to save the database files to the phone system files, and can display the names of the provinces and cities.There are three tables in the database, they are (I will upload the entire file and the database file later)Save tableCREATE TABLE IF not EXISTS ' fs_province ' ( ' Provinceid ' bigint (a) not NULL

varlist=[{name:"AAA", Score:80}, {name:"BBB", Score:70}, {name:"CCC", Score:90}, {name:"DDD", Score:60 }];functionComparefn (PropertyName) {return function(obj1,obj2) {varValue1 =Obj1[propertyname]; varvalue2 =Obj2[propertyname]; if(Value1 value2) { //return 1//max-min return-1//min-max }Else if(Value1 >value2) { //Return-1;//max-min return1;//Min-max}Else{ return0; }}}list.sort (Comparefn (' score ');//-1, sort from Min-max, 1 fro

(signed short); [EMAILNBSP;PROTECTED]@[EMAILNbsp;protected]void foo (unsigned short); [emailprotected]@[emailprotected]void foo (int); [emailprotected]@[emailprotected]void foo (signed int); [emailprotected]@[emailprotected]void foo (unsigned int); [Emailprotected]@[emailprotected]void foo (long); [Emailprotected]@[emailprotected]void foo (signed long); [emailprotected]@[emailprotected]void foo (unsigned long); [emailprotected]@[emailprotected]void foo (float); [Emailprotected]@[emailprotected]

Problem: Change the ing_ in the picture name to 0.Current directory: $ lspic,change_name.shpic/|__kk1/|__img_001.jpg|__img_002.jpg|__vv2/|__img_005.jpg|__abc_002.jpgSolve:Write the following in change_name.sh:#!/usr/bin/env SHCD picDir= ' ls. 'For dir in ${dir};d ofi [-D ${dir}];thenCD $dirRename ' s/img_/0/' *.jpgCd..FiDoneRun: Sh change_name.shResults:pic/|__kk1/|__0001.jpg|__0002.jpg|__vv2/|__0005.jpg|__abc_002.jpgThe shell traverses multiple folders and modifies file

CAT/ETC/PASSWD//View all user informationCAT/ETC/PASSWD|GREP User name//view information for a particular userCat/etc/group//View all group informationCAT/ETC/GROUP|GREP Group name//view information for a group nameGroups//view members of the currently logged in user groupGroups test//View the group that the test user is in, and the members in the groupWHOAMI//view current login user nameFind a group for newly added usersgroupadd developersThen create the user MX and add it to the developers use

In operation and maintenance work, sometimes need to query some domain name registration information (domain name NS, registered users, registered mailbox, etc.), you can use the WHOIS command.The WHOIS command is used to find and display user-related information for a specified account (or domain name), because it is located in the WHOIS database of network solutions, so the account name must be found on the above registry, and the name is not case-sensitive.That is, the WHOIS command lists inf

After the general configuration, in Windows Explorer to login to the Samba server, see the share directory but can not open, popup"cannot be accessed. You may not have permission to use network resources, please contact the administrator of this server to find out if you have access rights. The specified network name is no longer available. "Toss for a while, always not.Finally, by looking at the log file found under/var/log/samba/, [2016/08/24 01:04:09.910581, 0].. /source3/lib/popt_co

Problem:The directory structure is as follows:test/2001.01.01/2001.02.02/2001.03.02/2001.01.03/2001.02.04/2001.03.05/2001.01.04/2001.02.05/2001.03.07/2001.01.06/2001.02.06/2001.03.08/2001.01.12/2001.02.23/2001.03.09/2001.01.13/2001.02.26/2001.03.22/2001.01.24/2001.02.28/2001.03.24/Copy the same date in the test directory to the corresponding folder, such as 2001.01 ... Copy to 2001.01/,The code is as follows:CD ICESatC="' forfileinch`ls` Do#filelist [$c]=$file#c = 'Expr$c +1`D= 'ExprSUBSTR $file

Project development is done using eclipse, and sometimes you need to modify the name of the project, but you can still access it using the old project name when deployed to Tomcat in Eclipse.For example, the name of the original project is test, now I have changed to Pc-shop-web in Eclipse, but path is still test, this time can only be accessed through http://localhost:8080/test.Yes, it can be modified by the "Edit" button, but it's really annoying to have to modify every time you delete a deplo

In large-scale project development, you often need to look for the files you need in the huge file tree on the left side of Eclipse.At this point, you can use Ctrl+shift+r directly to call out the file lookup window. This is based on the file name to find files, for example, as long as the input you need to find the name of the file, you can get the corresponding search results.If you need to find files based on the strings in the file, you can switch to the File Search tab by ctrl+h the Find an

:[Email protected] ~]# hostnamectl set-hostname hyldb[[email protected] ~]# su-last Login:sun May Mode three: Configuration file manually modify the host nameGrammar:Modifying the hostname configuration fileCases:[[email protected] ~]# Cd/etc[[email protected] etc]# VI hostnamehyldb~[[email protected] etc]# su-last Login:sun May Summary:Hostnamectl-help/etc/hostnameOriginal works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the le

/*Create two threads, and run alternately on the main threadThe original thread has its own default nametread-number, which starts from 0Static thread CurrentThread () Gets the current thread objectGetName (): Gets the thread nameSet thread Name: SetName or constructor*/Class Test extends Thread{private String name;Test (String name){This.name=name;Super (name);}public void Run (){for (int x=0;x{System.out.println ((Thread.CurrentThread () ==this) + "..." +this.getname () + "Run ..." +x);}}}publ

Iamlaosong folder inside the image file is saved with a single scan, the file name is the mail number, now want to collect these mail numbers, because the volume is very large, it is not possible to intercept a single, only through the program implementation, assuming that the current worksheet B is placed in the folder of these image files, The following program can be used to tell the message number of these image files: Sub findname () Dim FS, F, F1, FC, Mydir MaxRow = Sheets ("Mail Number").

]) forresinresult_list:res.get ()Let's take a look at the effect.1. First I create a/put/directory on my server to store the files that need to be uploaded, the format of the file is as follows127.txt 139.txt 143.txtSo I can upload it to the specified server based on the file name.650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/80/wKioL1RpjI_hatg7AAH9K942FSs234.jpg "title=" 1.png " alt= "Wkiol1rpji_hatg7aah9k942fss234.jpg"/>As can be seen, according to my definition of the file upl

Due to the project needs, the user name of the Linux system needs to quickly get the group name, through the test summarized as follows:Method 1: Pass the groups command[[emailprotected]~]#foriin ' awk-f ': ' ' {print$1} ' NBSP;/ETC/PASSWD ';d ogroups $i;d one root:rootbin:bindaemonsysdaemon: daemonbinadmlpadm:admsyslp:lpsync: rootshutdown:roothalt:rootmail:mailuucp:uucpoperator: rootgames:usersgopher:gopherftp:ftpnobody:nobodyvcsa :vcsasaslauth:saslauthpostfix:postfixmailsshd:sshdntp :ntptcpdu