what is the equivalent of EXPLAIN form SQLite in SQL Server?

sql-server sqlite explain
Gabriel Diaconescu picture Gabriel Diaconescu · Feb 2, 2011 · Viewed 8.8k times · Source

I used an SQLite database and run an EXPLAIN statement before executing the actual query to verify if there was any attempt to write on the database.

Now, we have migrated to SQL Server and I need to know if a query tries to write on the database or is just a simple SELECT statement. I basically try to avoid any malicious statement.

Answer

Oded picture Oded · Feb 2, 2011

You can see the estimated query plan of any query in SSMS by clicking the estimated query plan button.

See MSDN.

However, if the user shouldn't be writing to the database, is shouldn't have the permissions to do so. Ensure it belongs to a role that has restricted permissions.

Related questions

Exporting from SQLite to SQL Server

Is there a tool to migrate an SQLite database to SQL Server (both the structure and data)?

Read More
ModuleNotFoundError: No module named 'pyodbc' when importing pyodbc into py script

I've written a short python script which tries to import the pyodbc extension package so I can access my SQL table. import pyodbc as pyodbc cnxn = pyodbc.connect('Driver={SQL Server};' 'Server=DESKTOP-UO8KJOP;' 'Database=ExamplePFData' 'Trusted_Connection=…

Read More
SQL Server CE 4.0 performance comparison

SQL Server CE 4 (SQL Server Compact Edition 4.0) is not news already (If it is, you could read this article) But it is very interesting to see SQL Server CE 4 performance comparison to other databases. Especially with: SQLite SQL Server (1) SQL …

Read More