SQL Server

As you normally know, SQL Server is well integrated with Microsoft Exchange Server, and there are detailed instructions for configuring this in SQL Server online Help, no longer repeating. However, the question we are more concerned with is: How do

From CodeRED to Nimda and so on, a lot of worms to the original need to manually use the vulnerability has become the application of automatic use, do you want to manually operate these IIS vulnerabilities? Let's adjust our focus to see the database

SQL Server recommends assigning a variable using SET instead of SELECT.The SET method is recommended when an expression returns a value and assigns a variable.The following table lists the differences between SET and SELECT. Please pay special

FileName: date.inc.php3 Before you use these two functions, you must first convert the date or datetime to the timestamp type. Such as: $today =mktime (0,0,0,date ("M"), Date ("D"), Date ("Y")); /**** simulate the DATEADD function in SQL Server ****

The application of IsNull in database query, especially when the statement is connected For example, when the connection, a field does not have a value, but also left join to other tables will show empty, IsNull can determine whether it is null,

Display SQL Server Version Information Description Display SQL Server Version information. Supported platforms SQL Server 2000 Yes Script Code Strdbservername = "." Set Objsqlserver = CreateObject ("SQLDMO. SQL Server ") Objsqlserver.

Copy Code code as follows: Using System; Using System.Data; Using System.Configuration; Using System.Web; Using System.Web.Security; Using System.Web.UI; Using System.Web.UI.WebControls; Using System.Web.UI.WebControls.WebParts; Using

Copy Code code as follows: --pk SELECT * from sys.key_constraints where object_id = object_id (' TB ') --fk SELECT * from Sys.foreign_keys where parent_object_id =object_id (' TB ') --Create a linked server exec sp_addlinkedserver ' itsv ',

DECLARE @OutputType varchar (20)DECLARE @debug char (1)Declare @ForceRefresh char (1)Declare @xp_cmdshell_available char (1) Set @OutputType = ' LIST 'Set @Debug = ' Y 'Set @ForceRefresh = ' Y 'Set @xp_cmdshell_available = ' Y ' BeginSET NOCOUNT

----Fault 1:master has backup 1.backup Database for Master Backup Database Master to disk= ' e:\master.bkf ' with format Go 2.stop MSSQLServer Service net stop MSSQLServer 3.start SQL Server with single user mode C:\>CD C:\Program

Friend consultation question, here is a reference step: Recovery move files /* If the database cannot be started, either in suspect mode or in an unrecoverable state, only members of the sysadmin fixed role can move the file. */ 1. If the

The case of each physical file (data file) corresponding to a filegroup (one-to-one) What if I move the data to another filegroup and don't want the empty filegroup? The script is similar to the previous article. Use master go IF EXISTS (SELECT *

The issue DB structure is published, SQL Server Manager can generate scripts, and how is the data released? "Train of thought" generate INSERT INTO ... VALUES ... Statement /*--=============================================--Author:yew--Create

The garden has a very good article about SQL Server transaction isolation, feeling a lot of the introduction from the concept, for those beginners, see the touch of understanding is profound, so no longer repeat, the emphasis is on the example

1. Preamble At present, with the rapid increase in information, for the storage and management of data, enterprises are gradually getting rid of the previous reliance on file systems (text files or Excel) or some desktop small database systems

In this article, let's talk about five common questions about this new method of writing stored procedures. They deserve your first reading ... In SQL Server 2000, there is only one way to write stored procedures: using T-SQL statements. Learning

Questions raised In my new job, I faced the problem of archiving the tables that were created in the product database, because as the database grows, it needs to be moved now. At the same time, these archived tables are used for several tasks and

1. The use of testing tools to simulate multiple end users concurrent testing; The disadvantage of this test approach is that end users are often not directly connected to the database, but rather pass through one or more intermediary services, so

XML is the latest solution for data storage. XML gives web developers greater programming flexibility than HTML. This technology-driven development organization tries to integrate XML with its own products. Microsoft is the pioneer of such a move.

Problem Previously, we learned how to grant permissions using the EXECUTE AS command in SQL Server 2005, and you've seen how to grant granularity permissions with the EXECUTE AS clause. It is important to switch contexts within a programmable