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!
-
What replaces the single quote ' in SQL?
Super tip. Thanks! ssmat- ssmat
- Post #4
- Forum: Microsoft SQL Server: Programming
-
xp_cmdshell move not working when dynamic
Super, thanks! ssmat- ssmat
- Post #3
- Forum: Microsoft SQL Server: Programming
-
xp_cmdshell move not working when dynamic
Hi all, This seems like it should be easy, but it has me stumped. From the query analyzer I run this command: exec master..xp_cmdshell 'move "\\servername\frompack\WT010101.txt.txt" "C:\PTArchive\"', no_output It works great. I want to move this command to a stored...- ssmat
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Check if text file exists in stored procedure
Works great! Thanks!- ssmat
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Check if text file exists in stored procedure
Hello All, I have a stored procedure that uses a bulk insert to insert records into a table from a dynamically produced text file name. SET @FileName = "\\server\frompack\WT" + @MachineCounter + @MonthCounter + @DayCounter + ".txt" Select @SQL = 'Bulk Insert #Temp ' Select...- ssmat
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
