Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
ALTER PROCEDURE "dbo"."ps_StudentList_Import" @PathFileName varchar(100), @OrderID integer, @FileType tinyint AS DECLARE @SQL varchar(2000) IF @FileType = 1 BEGIN SET @SQL = "BULK INSERT TmpStList FROM '"+@PathFileName+"' WITH (FIELDTERMINATOR = '"",""') " END ELSE BEGIN SET @SQL = "BULK INSERT TmpStList FROM '"+@PathFileName+"' WITH (FIELDTERMINATOR = ',') " END EXEC (@SQL) INSERT StudentList (StFName,StLName,StEmail,OrderID) SELECT CASE WHEN @FileType = 1 THEN SUBSTRING(StFName,2,DATALENGTH(StFName)-1) ELSE StFName END, SUBSTRING(StLName,1,DATALENGTH(StLName)-0), CASE WHEN @FileType = 1 THEN SUBSTRING(StEmail,1,DATALENGTH(StEmail)-1) ELSE StEmail END, @OrderID FROM tmpStList TRUNCATE TABLE TmpStList
Add your voice to the tech community where 5M+ people just like you are talking about what matters.