SQL Server

In SQL Server, if the default value is set for a field in the table, a default constraint is generated in the system table sysobjects.If you want to perform operations on the field with the default value, such as changing the column type and

Principle: The dynamic memory allocation mechanism introduced by SQL Server 2000 is generally unable to recycle the memory well. If the computer is never shut down, the memory will be exhausted. You can choose to shut down once a week to avoid it,

We all know that from winforms applications ProgramTo access the database server, use the connection string. If you are using a user name/password for connection, we usually encrypt the connection string to enhance security. This is far from enough.

The following are three methods to get the job scheduling time: First: 1 Declare 2 @ Jobid Varchar ( 50 ), 3 @ Newjobid Varchar ( 50 ) 4 Select @ Jobid = Replace (Job_id, ' - ' , '' ) 5 From MSDB. DBO. sysjobs

Basically, database snapshots allow you to create a static read-only copy of your database for other purposes, such as reporting, auditing, or data recovery. How does it work? A database snapshot creates a database shell for your existing

What is an index? Take the directory pages (indexes) of the Chinese dictionary for example: just as the Chinese characters in the Chinese Dictionary are stored by page, the data records in SQL Server are also stored by PAGE, and the size of each

-- Calculate the number of Sundays in a month of a year (excluding Saturday) Create Function f_getnums (@ year_month varchar (8) returns INTAS begin declare @ BDT datetime, @ EDT datetime, @ I int set @ I = 0 set @ BDT = cast (@ year_month + '-01'

This service is newly added to SQL Server 2005. Every time I give a lecture, I have to ask questions and explain them in detail. To put it simply,If a physical server has multiple SQL Server instances, SQL Server 2005 provides a new browser service

This article from: http://aspxboy.com/private/5280/default.aspx It is convenient to deploy Web solutions on the. NET platform. We can use Visual Studio. NET 2003 adds a web installation project, and adds the project's main output and content files

Some Opinions on SQL Server 2000's XML supportThis article mainly discusses similar statements of "select Field 1, Field 2,..., field N from table or multi-table joint query where condition for XML auto ". When I used the preceding statements to

-- 1. Use OpenRowSet directly Create view name As Select * From OpenRowSet ('sqlodb', 'Another server name'; 'sa '; 'Password', database name. DBO, table name)   -- 2. Use the linked server-- Create a connection server to access another server in

 SQL Server String splitting (split) method summary -- Method 0: dynamic SQLDeclare @ s varchar (100), @ SQL varchar (1000)Set @ s = '1, 2, 3, 4, 5, 6, 7, 8, 9, 10'Set @ SQL = 'select Col = ''' + Replace (@ s, ',', ''' Union all select ''') +

There is a time column in the Excel file, and the text and time are mixed. For example, there are many hh: Mm columns in the file at a.m.. It is convenient to use dtswizard to import data, but hh: Mm changes to null, setting the import data type in

If exists (select * From sysobjects where type = 'p' and name = 'uspoutputdata ')Drop proc uspoutputdataGoCreate procedure DBO. uspoutputdata@ Tablename sysnameAsDeclare @ column varchar (2000)Declare @ columndata varchar (2000)Declare @ SQL varchar

Quasi-real-time SQL Server Database Synchronization Solution 1. Requirements1) How to synchronize online SQL Server database data to another SQL Server database in a timely manner.2) data extraction from the data warehouse system puts a great deal

Support Complex CTE statement calls: Original SQL statement called: With T (Select ma_id from sa_affair_info where ad_id = 2203 and ai_affair_status = 2 and ai_is_pass = 'true'),Q(Select M. * From sa_main_affair M Join t on T. ma_id = M. ma_index_no)

Today I encountered a depressing problem about the database table name. The table name of the SQL Server database can start with a number, but the table name cannot be directly written during query, as shown below: Select * Form into tablename

Connect to the default instance of SQL server: exec sp_addlinkedserver @ServerName, N'SQL Server'   Used to connect to a specified instance: EXEC sp_addlinkedserver @server='SQL2005', @srvproduct='', @provider='SQLNCLI', @datasrc='DBhere'   @

If you need to regularly execute a stored procedure or SQL statements of less than 3200 characters in SQL server, you can use management> SQL Server proxy> job. ◆ 1. Choose manage> SQL Server proxy> job (right-click)> create job> ◆ 2. Create a job

Even if xp_mongoshell is unavailable, it is still possible to run CMD on the server and get the echo result. here we need to use several other system stored procedures on the SQL SERVER: sp_OACreate, sp_OAGetProperty and sp_OAMethod. The premise is