sql存储过程学习 _java程序员之点点滴滴（SQL stored procedure learning _java programmers dribs and drabs）.doc

sql存储过程学习 2_java程序员之点点滴滴（SQL stored procedure learning 2_java programmers dribs and drabs） SQL storage process of learning 2_JAVA programmers little Baidu space | Baidu home page | login The JAVA bit from the beginning programmers programmers d no return home... | blog album personal file | friends see article SQL 22009-02-20 00:38 SQL stored procedure to learn Server Is the empty string interpreted as a single space or interpreted as a real empty string, set by the compatibility level control?. If the compatibility level is less than or equal to 65, SQL Server The empty string is interpreted as a single space. If the compatibility level is 70, then SQL Server interprets empty strings as empty strings. Get information about stored procedures To display the text used to create the process, execute the sp_helptext in the database where the process is in, and use the procedure name as the parameter. That cannot create procedure using the ENCRYPTION option to use sp_helptext view. To display the object referenced by the relevant process report, please use the sp_depends. If you want to rename the process, please use the sp_rename. Reference object SQL Server Allow the creation of stored procedures referenced objects do not yet exist. When creating, only syntax checks are performed. When executing, if there is no effective plan in the cache, the stored procedure is compiled to generate the execution plan. All object references only analysis in the compilation process in the stored procedure. Therefore, if the syntactically correct stored procedure refers to an object that does not exist, it can still be successfully created, but it will fail at runtime because the referenced object does not exist. Deferred name resolution and compatibility level SQL Server allows Transact-SQL stored procedure referenced table that does not exist at the time of creation. This capability is called deferred name resolution. But, if... The Transact-SQL stored procedure refers to the table de