Case Study 1 |

Case Study 1

Inserting bulk data from text files into SQL Server and creating database objects such as tables and its data, dynamically.
All the folders in text files are looped and represented in the form of tables.
Use of Command Shell and Format Files in SQL
Creating UDFs for data integrity.
Implementing CHARINDEX(), SUBSTRING() and PATINDEX() and other System Functions.