Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Palmer-Creating Stored Procedures or Triggers Inside Stored Procedures
Sorry, been at meetings all day. My thoughts on this are as follows. The only way I can see of doing this is to make use of the isql command line utility by shelling out within a stored procedure using xp_cmdshell as follows: CREATE PROC palmproc AS EXEC master..xp_cmdshell 'isql /U /P /e /n...- Palmer
- Post #2
- Forum: Microsoft SQL Server: Programming
-
delete query
Does this work delete d from salesdetailretail d join salesheaderretail h on h.storenumber = d.storenumber and h.controller = d.controller and h.register# = d.registernum and h.transaction# = d.transactionnum and h.transactiondate = d.transactiondate...- Palmer
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Create a Stored Procedure Inside Another Store Procedure
The following code although very simplistic shows the general principles of creating a stored procedure within a stored procedure. create procedure pproc as declare @cmd varchar (500) select @cmd = 'create procedure newproc as select * from information_schema.columns' exec (@cmd) go Hope...- Palmer
- Post #2
- Forum: Microsoft SQL Server: Programming
