Fetch Filenames from Filepath stored in column SQL

SELECT REVERSE(SUBSTRING(REVERSE(filepath), 0, CHARINDEX('\', REVERSE(filepath), 1))) from xpatientnotes

Rename column name of a table

sp_rename 'xSamplePatients_15.OldColumnName' ,'NewColumnName', 'Column'

Delete all stored procedures at once

declare @procName varchar(500)declare cur cursor 

for select [name] from sys.objects where type = 'p'open cur
fetch next from cur into @procName
while @@fetch_status = 0begin
    exec('drop procedure ' + @procName)
    fetch next from cur into @procName
endclose cur
deallocate cur

To convert Height into Feet and Inches

Create function InchesToFeet(@in float)

returns varchar(20)

as

Begin

declare @feet varchar(20)

set @feet  = ''

            select

                          @feet = cast(floor(V) as varchar) + ' ft' +

                          case

                                                when (@in - floor(floor(V) * 1/(2.54 / 30.48))) = 0 then

                                                            ''

                                                else

                                                            ' and '

                                                            + cast((@in - floor(floor(V) * 1/(2.54 / 30.48))) as varchar)

                                                            + ' Inches' end

            from

            (

                  select 
cast(@in * (2.54 / 30.48) as varchar) as V

            ) as d;

           return @feet;
End

 
Go

 

select dbo.InchesToFeet(68.5)

Bulk Insert in Database
Dump your bulk data files into Tables. Values of Row Terminator and Field Terminator changes according the requirement.

BULK INSERT DatabaseName.DBO .TableName
FROM 'Filepath'
WITH ( ROWTERMINATOR='END ROW' ,FIELDTERMINATOR= '^')