SQL CONVERT

Use CONVERT: CONVERT (data_type [(length)], expression [, style]) SELECT CONVERT (varchar, getdate (), 120) 2004-09-12 11:06:08 select replace (replace (replace (CONVERT (varchar, getdate (), 120), / ‘- /’, / ‘/’), / ‘/’, / ‘/’), / ‘:/’, / ‘/ ‘) 20040912110608 SELECT CONVERT (varchar (12), getdate (), 111) 2004/09/12 SELECT CONVERT (varchar (12), getdate (), 112) […]

Read more

The DedeCMSV53 any variable coverage holes

DedeCMSV53 released, but still not the variable thorough repair coverage holes.¬†This loophole and ryat in that very similar ūüôā See the code in the core file include / common.inc.php // foreach($_REQUEST¬†as¬†$_k=>$_v) { ¬†¬†¬†¬†if(¬†strlen($_k)>0¬†&&¬†eregi(‘^(_|cfg_|GLOBALS)’,$_k)¬†&&¬†!isset($_COOKIE[$_k])¬†)//? ¬†¬†¬†¬†{ ¬†¬†¬†¬†¬†¬†¬†¬†exit(‘Request¬†var¬†not¬†allow!’); ¬†¬†¬†¬†} } This place can be bypassed by submitting _COOKIE variable filter cfg_ keyword followed by the code of the […]

Read more

Scrawl

Event-driven programming, known as the “form” and “control” object in¬†VB.¬†These objects interact with the user graphical interface (also known as the User Interface The user interface) and then design your application must take into account how users interact and procedures, users interact via mouse and keyboard with the application is the most direct and convenient […]

Read more

What is the “only” in the IT industry?

I am currently studying at the Guangdong University of Technology, the 06 session of Information Management and Information System, in September this year, entered the junior.¬†Programming, I have a strong interest in the IT industry will be tender enough to have a bright future, but their ability to feel confused, do not know their own […]

Read more

BULK INSERT large quantities of data

BULK INSERT [[‘database_name’.] [‘Owner’].] {‘Table_name’ FROM ‘data_file’} [WITH ([BATCHSIZE [= batch_size]] [[,] CHECK_CONSTRAINTS] [[,] CODEPAGE [= ‘ACP’ | ‘OEM’ | ‘RAW’ | ‘code_page’]] [[,] DATAFILETYPE [= {‘char ‘|’ native ‘|’ widechar ‘|’ widenative ‘}]] [[,] FIELDTERMINATOR [=’ field_terminator ‘]] [[,] FIRSTROW [= first_row]] [[,] FIRE_TRIGGERS] [[,] FORMATFILE = ‘format_file_path’] [[,] KEEPIDENTITY] [[,] KEEPNULLS] [[,] KILOBYTES_PER_BATCH […]

Read more

A deep understanding of the Oracle database startup and shutdown

First, the startup and shutdown of Oracle database To start and shut down the database must be a user of the Oracle administrator privileges landing, usually that is, the the SYSDBA privileges of the user login.¬†Generally we used the INTERNAL user to start and close the database (Internal user is actually a synonym for the […]

Read more

Reuse of the data table space (Reusing space in a table)

If you delete some rows of data, I need to compress the SQL Server database? For these spaces can be re-used, which is a very good question, the cut is often asked, which relates to the management of the SQL Server database to delete and compression mechanism. 1 understand how SQL Server automatically re-use of […]

Read more

Vista the sql2005 Additional database failure problem

Vista install SQL Server 2005/2008, the additional database error solution I installed SQL Server 2005 in Vista, detach the database, for additional following error occurred: Prompt “Unable to open the physical file ………… operating system error 5:” 5 (Access Denied) “(Microsoft SQL Server, Error: 5120) Online are said the problem is caused due to the […]

Read more

Table structure information inquiry

– Sql server 2005 – 1 table structure information inquiry – ================================================ ======================== – Table structure information inquiry – Zou 2005.08 (reference please retain this information) – ================================================ ======================== SELECT TableName = CASE WHEN C.column_id = 1 THEN O.name ELSE N” END, TableDesc = ISNULL (CASE WHEN C.column_id = 1 THEN PTB. [Value] END, N”), […]

Read more

Mysql command

USE <dbname> [LIKE wild]; show tables; show databases; ? / Help; exit / quit; mysqladmin version; mysql mysqladmin version; NET Start mysql; mysqladmin variables; mysqladmin-h hostname – port = port_number variables; The case of default, the port is 3306, the name of the socket MySQL mysqladmin shutdown; mysqladmin reload; mysqladmin-help; mysqladmin-u root-p shutdown; If you […]

Read more