SQL Server

/** = ** 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

Today, I helped install an SQL Server. My computer is a new server. I only installed Windows, system patches, and basic drivers.Program, Anti-virus software, gold disc K3. As a result, SQL Server has not been installed for half a day and the

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,

It is very easy to get connection information Sp_who   Disconnected: Kill PID PID is the ID in the connection information     The following is a process of disconnecting all users in the specified database (in the master database)Use masterGoIf

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

1.1 cursor ConceptCursor allows you to access the result set returned by SQL Server row by row. A major reason for using cursor is to convert the set operation into a single record processing method. After retrieving data from a database using SQL,

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

Exception in thread "Main" com. microsoft. sqlserver. JDBC. sqlserverexception: The TCP/IP connection to the host xx.111.134.54, port 1433 has failed. error: Connection timed out: connect. please verify the Connection Properties and check that a SQL

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