I’m trying to execute a SQL script dump file which have multiple tables. I want to read data from this dump file and make a sqlite(offline) database. I’m using following SMO procedures and code is following string sqlConnectionString = @"Server=localhost\SQLEXPRESS;Database=master;Trusted_Connection=True;"; FileInfo file = new FileInfo("podcat-22-06-2022.sql"); string script = file.OpenText().ReadToEnd(); SqlConnection conn = new SqlConnection(sqlConnectionString); SqlCommand… Read More Trying to Run a SQL script file, Getting Syntax error : Incorrect syntax near '`'

I have a table that has three columns from which I need to retrieve the data. One of the columns OtherNames contain an array of Json Objects. CREATE TABLE Persons ( NameID int, CurrentName varchar(255), OtherNames varchar(max), ); I can query that column just fine, but how can I join it with the table it… Read More Querying Json array column and other current table column