Others

Copy Code code as follows: --******************************************************* --* clear all data in the table * --* the Great Forest of Sahara --* 2010-6-28 * --******************************************************* if exists

Use select in SQL Server ... INTO statement According to the use of the situation can be divided into the following categories: 1. To implement a full table backup: For example: SELECT * Inot T1 from titles 2. Part of a backup table (write a

Copy Code code as follows: TRUNCATE TABLE TestTable EXEC sp_configure ' show advanced options ', 1; --Open Advanced Configuration Reconfigure EXEC sp_configure ' Ad Hoc distributed Queries ', 1;--open distributed query Reconfigure

Copy Code code as follows: Use [daf_db] Go /****** object:storedprocedure [dbo]. [Prog_worktask_list] Script date:06/14/2010 21:14:43 ******/ SET ANSI_NULLS on Go SET QUOTED_IDENTIFIER ON Go --[prog_worktask_list] 62, 0, ', ', 0, 0, ',

Set up the following stored procedures, to be paged later, directly call the change stored procedures can be. Note: Large data, high performance requirements, please personalized processing. Copy Code code as follows: ALTER PROCEDURE

Copy Code code as follows: SELECT TableName = object_name (c.object_id), Columnsname = C.name, Description = Ex.value, Columntype=t.name, Length=c.max_length From Sys.columns C Left OUTER JOIN Sys.extended_properties EX On

1. Search out all the table names and construct them into a single SQL statement Copy Code code as follows: DECLARE @trun_name varchar (8000) Set @trun_name = ' Select @trun_name = @trun_name + ' TRUNCATE table ' + [name] + '

Recent projects, using the jquery1.6.2 library, when dynamically adding div and select, the event does not work. Found the bind event: Attach one or more event handlers to the matching element. Live event: Adds one or more event handlers for

As shown below: Add a row to the second row of the table: var Tbl_elm = $ ("#dgList"); $ (' xxxxxx '). InsertBefore ($ ("tr", Tbl_elm). EQ (1)) /// /table the specified row N column merge cells (one more column after merging, delete n+1

It's been a long time trying to succeed. The test on the internet is not good, so I saw the results on the official document and finally succeeded. $ ("#overTime"). Dialog ({ autoopen:false, width:400, modal:true, Title: "Dialog

SELECT * from "A where ID in" (SELECT ID from B); SELECT * from A where exists (select 1 from B where a.id=b.id); For the above two cases, in is in the memory traversal comparison, and exists need to query the database, so when the B table data

1. To optimize the query, you should try to avoid full table scan, first consider the where and the order by the columns involved in the establishment of the index. 2. The null value of the field in the WHERE clause should be avoided as far as

But pros and cons, it requires that the sort field must form a unique record, and that fields that have the same name as the sorted field are not allowed in the list of fields after the select.Although Sql2k5 and above have provided rownum () for

Requirements Description:A table myimage, column has: Number ID, paths pathSuch as:ID PATH1 c:/1 c:/1 d:/2 c:/2 c:/3 a:/3 c:/4 d:/Write an SQL statement that returns the ID number of such a record: The same ID has a different path. As an example,

Copy Code code as follows: Database Backup Instance/** * * Database Backup instance * * Zhu Yi May 2004 * * Backup strategy: * * Database name: Test * * The path to the backup file E:\backup * * Make a full backup every Sunday 1 o'clock

SQL Server Automatic Job backup 1. Open SQL Server Management Studio 2. Start SQL Server Agent 3. Click Job-> New Job 4, "General" Enter the name of the job 5. New step, type T-SQL, enter the following statement in the command below

Use replicate (repeat character expression at a specified number of times) function The replicate function repeats a character expression at a specified number of times. Grammar: REPLICATE (character_expression,integer_expression) Parameter

Today, write software engineering big job, tuned a half-day bug, the original is the Memset function is not known in place. int Max[teachrelationnum]; memset (max,0,sizeof (max)); Note that you can use sizeof (max), or you can use the sizeof (int) *

Function prototype:extern char *strcat (char *dest,char *src)Parameter description: Dest is a pointer to a destination string, which is the concatenated string (in front), and SRC is a pointer to a source string (after). Library name : #include

Two-point hardening--Full QueryTimelimit:2000ms MEMORYLIMIT:128MB64-bit integer IO format:%i64dGives a sequence of positive integers from an increment a0,a1......an-1Corresponding results for different query outputsIntputOnly one set of dataThe