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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sbphelps

    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
  2. sbphelps

    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
  3. sbphelps

    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'...
  4. sbphelps

    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'...

Part and Inventory Search

Back
Top