71 Stored procedure in SQL Server

stored procedure in sql
Download the scripts used in the video from here: drive.google.c...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • Sql server developer i...
stored procedure in sql
What is a stored procedure in SQL?
Where are SQL procedures stored?
Create a Stored Procedure - SQL Server
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@mohdgafoor2716]

Dear Aqil, please let us know how to split 234?4535?67?8978?99 means special character contains rows into columns.

[@user-my8zf8ww2i]

Hi... How to read Excel files from SharePoint folder using ssis

[@learnssis]

Hi, you would need to write code in C# to download the files from Sharepoint to your local folder on the server. There is no inbuilt code to read the files directly from sharepoint.
stackoverflow.com/questions/58034425/download-file-from-sharepoint-online-using-c-net

[@mohdgafoor2716]

One of my column contains 398?6666?76?889?9874 this kind of data and my requirement is will have to split it into separated columns. Kindly help ASAP😊

[@learnssis]

If your column should contain only numeric values and there are special character present in the data that you want to identify and move the column value into another column then you can use the IsNumeric function like
select isnumeric(column) from tablename
and you can update data to another column like
update a
set secondcolumn = case isnumeric(column) when 1 then column else 0 end
from tablename a