Using SQL query removes all tables data with schema | stored procedures | views | indexes

Rather then delete one by one remove all data and schema from database using single SQL query. Mostly on shared hosting where we are not able to check SQL server database and table views because of SQL server version, sometimes our SQL version is low or some time they version is high. So we are … Read more

SQL Server recursive query, Which returns all ancestors of an item

We will create a recursive query when getting data as per parent and its level. Mostly we use this query in MLM software (Multilevel marketing software). Using this you can easy to get who is my parent till the level we wanted to find. for more info follow this URL: https://stackoverflow.com/questions/16749095/sql-recursive-query-that-gets-all-ancestors-of-an-item Create new stored procedure … Read more

What are sub query and its properties?

A sub-query is a query that can be nested inside the main query like Select, Update, Insert, or Delete statements. This can be used when the expression is allowed. Properties of sub query you can follow points sub query should be placed on the right-hand side of the comparison operator of the main query sub … Read more

What Is SQL Profiler?

SQL Profiler is a tool that allows the system administrator to monitor events in the SQL server. This is mainly used to capture and save data about each event of a file or a table for analysis. Using this we can easy to capture in realtime which queries are executing. We have no need to … Read more