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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
stored procedure debug
In Query Analyzer's Object browser, expand the database, stored procedures, and right click on the stored procedure you wish to debug. select "debug..." from the pop-up menu. sbphelps- sbphelps
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Query in SQL Server 2000 that can rename a file in a directory?
set @command = 'rename ' + @rpt_path_name + ' ' + @new_name exec master..xp_cmdshell @command, no_output /* where @rpt_path_name is the path (drive and directories) and @new_name is... well, the new file name. sbphelps- sbphelps
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Tricky T-SQL Request
Here you go... declare @date datetime, @num int, @result int, @txt2 varchar(9), @day_num tinyint, @txt1 char(3), @txt3 varchar(80) set @date = '2003-08-25' select @num = datepart(dd, @date) set @result = (@num / 7) + 1 select @txt1 = case when @result = 1 then '1st'...- sbphelps
- Post #4
- Forum: Microsoft SQL Server: Programming
-
SQLSTATE tacked onto output
I have been working on some stored procedures which create SQL scripts. I build the statement, then print it, creating a report which holds the script. My problem is that on each printed line, SQL adds a "SQLSTATE". For example, exec sp_configure 'show advanced options', '1'...- sbphelps
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
