SQL Server

  In the previous chapter, we have introduced how to create an SQL azure database. This chapter describes how to use SQL Server Management Studio (SSMs) to connect to and manage SQL azure databases. Install SQL Server manage studio to prepare the

/** = ** 1. An error occurred while using the custom function for group by. ** = **/-- A simple functionCreate Function f_str (@ STR sysname, @ I INT)Returns char (1)As beginReturn (substring (@ STR, @ I, 1 ))EndGo -- Below is the test -- Define

Those who have installed SQL Server are deeply touched by the installation process. In fact, the installation error can be checked by checking the log file. The following describes how to view the installation error. If you want to check the log

Example: Select * From OpenDataSource ('Microsoft. jet. oledb.4.0 ', 'Data source = "D:/yux/vbprj/data/test.xls"; user id = admin; Password =; extended properties = Excel 5.0 ')... sheet1 $The following... is required. sheet1 $ is the worksheet name,

1. First, you must change the database to the single-user mode. Otherwise, an "exclusive lock error" will be reported" In the object Resource Manager, connect to the SQL Server database engine instance and expand the instance. Right-click the

Use C ++ to access SQL Server 2000 instancesI. Introduction to ADO ADO (ActiveX Data Object) is a new interface for Microsoft database application development. It is a high-level database access technology built on top of ole db. It is not only easy

Yesterday, my SQL (Microsoft SQL Server 2005) failed to log on. It turned out to be a few small issues. Now I want to record my solutions to these problems. (There are many solutions. These are just my solutions for your reference) Troubleshooting

After the application software development supported by SQL Server is completed on the local machine, the software should be deployed on the customer's computer, or the database should be transplanted to the server, and the application software

SQL Server Connect basic knowledge (notes) The SQL Server Query analyzer is connected to the Enterprise Manager through ODBC. Client net-LibraryNet-Library: provides a channel between the API or object library (the application uses it to

4. What performance problems are confusing to you during your SQL server usage? Discussion Summary-Comprehensive L tempdb Problems A) Row-level and transaction-level snapshots are stored in tempdb (I don't know why the architecture is designed like

1.6 SQL Server 2000 trigger ManagementIn database management and maintenance, it is essential to ensure the integrity of the database in the database. A trigger is a special stored procedure that implements complex integrity constraints. When the

I believe many of my friends, whether engaged in development, architecture, or dBA, often hear the word "tuning. Speaking of "tuning", it may make many technical staff feel excited, or it may make many people feel distressed. Of course, there are

If you encounter a problem, the problem may be different. You can try the following solutions. Maybe you may have set it wrong. If you configure it a little bit, it will be OK, and there is nothing complicated. My efficiency is very low, so I am not

Chapter 4: Transact-SQL P80Cast and convertDirectly input in the query AnalyzerSelect cast (12345 as char), convert (INT, 3.14), convert (bit, 12.33)Select cast (100 + 88 as char), convert (varchar (10), getdate ())Select getdate (),Convert (char (12

1. Get exception message Select description from Master .. sysmessages where error = @ Error 2. query the table column names based on the primary key. Select name from syscolumns where id = object_id ('table name') and colid in (Select colid from

The specific usage of the three methods has been unclear. Differences between the executenonquery method and the executescalar method and the executereader Method  (1) executenonquery (): Execute the SQL statement of the command object and return an

-- Query table description Select a. ID, A. Name, B. value from sysobjects Left join sysproperties B on A. ID = B. ID Where a. Name = 'userinfo' Select -- Table name = case when a. colorder = 1 then D. Name else ''end, -- Table

1. When using the data in one table to update the data in another table, the T-SQL provides a variety of writing methods (two listed below), but it is recommended to use the first method, although the traditional, but the structure is clear. Note

I have been engaged in Oracle development before and found that some SQL server operations are still different from those of Oracle. Create a table based on an existing table: Oraclec creation method: Create Table temp_org_employeeSelect * From

Microsoft provides powerful com interfaces for access to the ms SQL Server Service of external programs. Through these interfaces, you can easily access the SQL service without any effort. Step 1: Find the sqldmo. rll file in the installation