select stored procedure into temp table

Mode 1:Declare @SQL NVarChar (max)Set @SQL = ' Select *from loanee as a applicationid in (' [email protected]+ ') 'Create table #t2 (ID int,Outcashaccountno nvarchar (50),Outname nvarchar (50),Incashaccountno nvarchar (50),Inname nvarchar (50),Amount Decimal (18,2),Cashtype int,Outinvestorapplyid int,Ininvestorapplyid int,Operatetype int,Addtime datetime);Insert into #t2Exec (@SQL)

SQL Statement implementation:SELECT COUNT (*) from INFORMATION_SCHEMA. ' TABLES ' WHERE table_name= ' youtablename ';In the WHERE clause, the table name is a string type, and the single quotation mark is added.In the MySQL stored procedureFunction implementation:CREATE definer = ' root ' @ ' localhost ' FUNCTION ' tableexists ' (' tname ' varchar ()) RETURNS tinyint (4) Begindeclare Tableexists TINYINT DEFA

Tags: style blog color OS IO data for problem1. Permissions issues2. Some commands related to stored proceduresShow procedure status\g see what stored procedures are in the database Show procedure statuswheredb ='db_name'\g view which stored procedures are in the specified d

/mydefault.aspx "," Ismenu ":" 0 "},{ "MenuID": "MenuName": "System Template", "Menucode": "Cf_md", "Menuurl": "Manage/model/mymodel.aspx", "Ismenu": "0"},{"MenuID" : "MenuName": "StaffManagement "," Menucode ":" Cf_users "," Menuurl ":" Manage/users/myuser.aspx "," Ismenu ":" 1 "},{" MenuID ": +," MenuName ":" I want to recharge "," Menucode ":" Cf_pay "," Menuurl ":" Manage/pay/pay.aspx "," Ismenu ":" 0 "},{" MenuID ":" MenuName ":" 4s information management "," Menucode ":" Cf_xxgl "," Menuur

Tags: add case from ALTER TABLE name use ORA function name kill1. If the function is locked, then there must be a process using the functionSelect b.sid,b.serial# from Dba_ddl_locks A, v$session b Where a.session_id = b.sid and A.name = ' function name or table name ';2. Kill processes using commands in OracleAlter system kill session ' sid,serial# ';3. If you encounter a situation that cannot be killed in

Copy Code code as follows: ALTER PROCEDURE [dbo]. [Sp_add_jurisdiction] @CTableName varchar (20),--current table to be deleted, new @filedkeyValue varchar (20),--value of the field to be deleted @filedName varchar (20),--Name of the field to be deleted @filedNameAdd1 varchar (20),--New field name 1 @filedNameAdd2 varchar (20),--New field name 2 @sql varchar (6000)--new value-added strings, such a