SQL Server

-- 1: obtain all the user tables in the current database. Select name from sysobjects where xtype = 'U' and status> = 0 -- 2: obtain the Select name from syscolumns where id = object_id ('table name') of all fields in a table. -- 3: View views,

Left join: returns all records in the left table and records with the same connection fields in the right table. Right join: Right join. All records in the right table and records with the same connection fields in the left table are returned.

Use a signal to notify Microsoft SQL server of the completion of a batch of transact-SQL statements.Go is not a Transact-SQL statement, but a command recognized by osql and iSQL utilities and SQL Server Query analyzer. If your SQL statement is too

Problem: When backing up an SQL Server database, you can specify a file name. Suppose we need to back up data every day, and we want to back up different file names every day, for example, using the current date as the file name   My answer: Use

Error:   Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> " / "ApplicationProgramServer error. --------------------------------------------------------------------------------

An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: named pipeline providesProgram, Error:

When performing some queries, if the returned result set is large, you may want to display the results by page. That is to say, you can specify the number of records displayed on each page and the page of records to be displayed. Take the "person.

SQL string functions-data type conversion functions In general, SQL Server automatically converts data types, for example, you can directly compare the character data type or expression with the datatime data type or expression. When

System. Data. sqlclient. sqlexception: Network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL server is

From http://www.cnblogs.com/wayne-ivan/archive/2008/01/07/1028759.html Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Select   *   Into Xlimport3 From   OpenDataSource ( '

1. access enables the relationship between tables and automatically deletes sub-table data after the parent table data is deleted: On the tables page, right-click and choose relationships... -> In the displayed relationships window, select the

We often use SQL Server Profiler when tuning SQL statements or sp. however, SQL Server Profiler displays all information connected to the database by default. If you enable it together, it will be messy. in fact, you can use the filter function to

Insert is a common statement in T-SQL. insert into table (field1, field2,...) values (value1, value2 ,...)ProgramDevelopment is indispensable. However, during the development and testing processes, we often encounter situations where table

When locking an SQL Server database, in addition to locking different resources, you can also use different degrees of locking, that is, there are multiple lock modes. The locking modes in SQL Server include: 1. in SQL Server, shared locks are

/* SQL Server 2000 is used. The system cdosys is used to send an HTML-type email. This script uses cdosys to send a mail. no mapi profile required. */use northwindset quoted_identifier on goset ansi_nulls on gocreate procedure [DBO].

The following instances are created on Sunday as the first day of the week. For details, see @ datefirst.Datediff (datepart, startdate, enddate)The datediff function calculates the total number of time intervals between two dates, such as hour, day,

Use for XML, but SQL2000 does not support this well. Use sql2005, for example, the following table: SnO sname ssex08020001 LI Yong male 08020002 Liu Chen female 08020003 Wang Min female 08020004 Zhang Li male SQL statement: Select rtrim (SNO) as "@

Good naming habits are a virtue. Below are the naming rules for databases compiled by individuals:   Database naming rules: 1. Database Name: 1.1) Name the product or project; 1.2) Pascal case, such as adventurework; 1.3) Avoid special

Document directory Syntax triggered by Creation Update trigger example Elete trigger example Original http://www.cnblogs.com/xiongzhuang/archive/2013/05/13/3076943.htmlWhat is a trigger? A trigger is a stored procedure that is automatically

1. "SQL Server does not exist or access is denied" This is the most complex. There are many causes of errors and there are many aspects to check. Generally, there are several possibilities: 1. incorrect spelling of the SQL Server name or IP address2.