Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


741: The use of stored procedures to be a specified table with other tables of the foreign key relationship between the
- I refer to the table some of my fruit fields [5] to the following table [1] some of the fields [3] the value declare @ id bigint select @ id = id from sysobjects where name = 'd_ database of patients' select a. name N 'by reference ...

742: windows 2003 in SQL Server 2000 Distributed Transaction error solution
Symptoms If the Windows. NET Server installed to run SQL Server 2000 linked server query, may return the following error (even if MSDTC is running on the server): Server: Msg 8501, Level 16, State 3, Line 3 MSDTC on server 'server name' i...

743: --- Practice stored procedure
1, fgw_proc1: CREATE PROCEDURE fgw_proc1 (@ begin int, @ end int) AS SET NOCOUNT ON DECLARE @ userid int, @ handled float, @ total float CREATE TABLE # temp_proc1 ( userid int, handled float, total float ) - get @ total DECLARE cur_cr CU...

744: The use of stored procedures
The use of stored procedure to eliminate redundant data in the database CREATE PROCEDURE sp_mytest AS declare @ pro varchar (50) declare @ mm int declare wu Cursor for select distinct product from mytest open wu fetch next from wu into @ pro ...

745: To guard against SQL injection attacks
Copy someone else's SQL injection attacks is the use of design refers to the use of the loopholes in the target server in order to run Sql and other forms of attack Sql command dynamically generated without user input the data into Sql authenti...

746: SQL injection of new skills
SQL inject new skills Source: Hackers Base Table names and field names of the access to the application: 1) The database is MSSQL 2) to connect the database is just an ordinary user 3) do not know ASP source code Can be carried out attacks 1) ...

747: Windows NT/2000 operating system authentication methods
remote_login_passwordfile: Description: Specifies the operating system or a file to check whether the user has the permissions password. If set to NONE, Oracle will ignore the password file. If set to EXCLUSIVE, will use the database with a passwo...

748: Package cursor stored procedure (Pr_execsql2)
Using a script they can implement their own features, packaging stored procedure cursor operation is as follows: CREATE PROCEDURE Pr_ExecSQL2 @ Asqlstring VARCHAR (8000) - enter the SQL statement AS EXEC ( ' - Launch Services BEGIN TRAN D...

749: Parameters of the implementation with embedded sql - sp_executesql
Sql statement is usually the implementation, we are using exec, exec powerful, but does not support the embedding parameters, sp_executesql to solve the problem. Sqlserver copy for some help: sp_executesql Implementation can be reused many times o...

750: A table of index should pay attention to and a means of improving performance
I. NOTES: First of all, should be taken into account in table space and disk space is adequate. We know that is a kind of index data, when the index is bound to also take up much table space. So a big table in the index when the first consideration...

751: Query Analyzer can not single-step debugging reasons
Concrete steps are as follows: 1, authentication server 【set】 【Properties】 mixed mode (window authentication and sql) 2, in the control panel】 【Open】 【Services】 MSSQLSERVER service will be open 【Properties】 【choose】 【lo...

752: Transact-SQL cursor name in the scope
Microsoft SQL Server 2000 to support the GLOBAL and LOCAL keyword DECLARE CURSOR for cursor name statements in the definition of scope. GLOBAL cursor specified in a connection is the overall situation. LOCAL cursor specified in stored procedures, tr...

753: SQL based on the best
The preparation of the ultimate goal of sql statement has three aspects: 1. Rapid response time 2. At least the use of cpu resources, at least 3 of the I / O operation Sql to promote some of the best tips * In the I / O point of view of the signif...

754: The achievement of 10 million pages of data displayed
This was after I wrote the stored procedure -------------------------------------------------- ------- ALTER PROCEDURE usp_GetRecordFromPage @ tblName varchar (1000), - table name @ SelectFieldName varchar (4000), - to show the field names (do n...

755: SQL log file length too large approach
Running in Query Analyzer Dump Tracsaction library name with No_Log In the Enterprise Manager to shrink the database in database operations. If you would like to refrain from the excessive growth of the log file, you can set up maintenance plan. ...

756: sql server table in the role of each system
Save sysaltfiles main database file database syscharsets master database character set and sort order sysconfigures main database configuration options syscurconfigs the current master database configuration options sysdatabases in master databa...

757: SQL It is worth noting that the two special symbols
In SQL, the strings that have quotation marks strongly recommend the use of single quotes ( '). Although MySQL can also use double quotation marks ( "), but SQL Server and Oracle and unity, these proposals are the use of single quotation ma...

758: SQL Server 2000 to use the cursor
Use the cursor: use db1 declare my_cursor cursor scroll dynamic / * scroll the cursor that can move the pointer (or can only move forward), dynamic cursor that can read and write (or read-only cursor) * / for select the name from the Personal Da...

759: Used in SQL functions convert date query
Have encountered such a situation, the Meeting in the database table PublishTime (DateTime, 8) field, used to store a meeting time, when deposited as a result of a meeting to specify a specific time, so the format yyyy-mm-dd hh : mm: ss, and our inq...

760: View of the creation and management of
13.10.1 create view SQL SERVER provided by the use of SQL SERVER Enterprise Manager and Transac-SQL command to create a view in two ways. In the creation or use of view, when it should be noted the following: • the database can only be creat...


Page 38 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]