insert from two table to another table in sql server
i have two table tbl_student it have studentId,studentName-
Grandparent, parent and child hierarchy SQL server or Bread Crumb
enter image description here
Sqlplan xml file convert to sql table
How to convert the sql server execution plan of xml file to sql table .
I can able to see the execution xml plan I don’t have provision in other ways using like Showplan text etc.,
Just want to convert the xml to output to the table .
Pls share if anyone has similar query and want to automate
SQL Server permissions for Application Integration
I have created a small application and want to post data to only one table in the database through that app. For that i have created a user with sql server authentication.what permissions should I assign to that user?