Step 1:
Select the folder where your files exists.
In my existing files, I want to remove "dbo."
Step 2:
Create one batch file (.bat) in same folder(For my situation .bat file named as "Rename").
hear is the script for .bat file@echo off
setlocal enabledelayedexpansion
set deletestring=dbo.
echo Ready to start
echo.
pause
echo.
for /f "delims==" %%F in ('dir /b ^| find "%deletestring%"') do (
set oldfilename=%%F
set newfilename=!oldfilename:%deletestring%=!
Ren "!oldfilename!" "!newfilename!"
)
echo.
echo All done
pause
Step 3:
Now run the .bat file.
Once done, you can able to see the result.
nice explanation
ReplyDeletecan u tell me difference between temp table and table variable
ReplyDeletehttp://sqlvagalla.blogspot.in/2016/03/difference-between-temp-table-and-table.html
DeleteHi Shaik,
ReplyDeletePlease click on it.
http://sqlvagalla.blogspot.in/2016/03/difference-between-temp-table-and-table.html