sql search stored procedures for table name

Today, we will introduce the SYS. all_ SQL _modules view in SQL Server, which stores definition statements such as functions, tables, stored procedures, and views. SYS. all_objects view, which contains the names of all objects (function name,

for the Where condition, you must note that you must write it to the beginning of the Where condition. 3. Indexing A table with a small number of records can be retained with a primary key index. Do not create other indexes. The full table scan is fast. It is best to create a tablespace for the index separately and re-build the index if necessary. Function indexes can be used if necessary, but are not

How do I execute a stored procedure when I start SQL Server? Create the stored procedure in the master database, and then locate the stored procedure in Enterprise Manager-right--Properties--check "execute whenever SQL Server starts". -or after the

1. Parameter problem of stored procedure in SQL database How do you use parameters in a stored procedure in an SQL database as both an output variable and an output variable? [SQL] View plaincopy--drop proc Proc_test --go Create proc Dbo.proc_test @in int, @out int out

Tags: style blog http io ar os using SP dataOriginal: sql--Stored procedure1. Why use stored ProceduresThe process of using T-SQL statements to the server by an application is unsafe.1) Data not secure2) Each commit SQL code will be executed after syntax compilation, affecti

The execution efficiency of stored procedures is higher than that of separate SQL statements. How to Write a stored procedure? The stored procedure is stored in the programmable directory of the database corresponding to

SQL Server quickly searches for stored procedures (SQL statements) of a field. The Code is as follows: SELECT obj. name: Name of the stored procedure, SC. TEXT

Tags: --Creating a stored procedure for adding a local database create or replace procedure Pro_electric_record as begin INSERT into Electric_meter_record (id,bases Tation_id,name,meter_number,createtime) Select Sys_guid (), substr (s.sname,0,36), s.sname,s.svalue,sysdate from Rtdbvs s where s.sname like '%power_dqdl% '; Commit End --splicing values from another

stored proceduresCreate PROCEDURE Sp_addrowtologin@TeaNo nvarchar (100),--comparing fields@TeaName nvarchar (100)--comparing fieldsAsINSERT into Tbl_userlogin values (@TeaNo, @TeaName, @TeaNo, 0)Stored procedures that are returned except for the specified columnCREATE PROCEDURE Sp_alter@TblName nvarchar (30)--table na

if the name of the view you want to create existsif exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ View name] ') and OBJECTPROPERTY (ID, N ' isview ') = 1)--Delete ViewDrop view [dbo]. [View name]GO-----------------Determine if the name of the function to be created existsif exists (SELECT * fr

Summary of writing transaction processing methods in SQL Server Stored Procedures, and storing process transactions This article describes how to write transactions in the SQL Server stored procedure. We will share this with you for your reference. The details are as follows