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.