1875 2
Check if table exists then delete it in SQL Server

I am checking this article, which allow you to drop all tables of SQL Server database, but I just want to delete a specific table of the database, so how can I do it?

to check if table exists then drop it completely from the database, without risking any other DB table in SQL Server.

...
Type
Question
1863 2
How to access the substring from the string in sql?

I need to access substring from a string using SQL, how can i achieve it in SQL server?

Suppose my string in "Hello World in C" and i want "World" from it, how can i do that using SQL query?

...
Type
Question
1549 2
Can i have example of declare table and temp table in sql ? and how the update operation can be used on it ?

Can i have example of declare table and temp table in sql ? and how the update operation can be used on it with real life scenario ?

 

...
Type
Question
1547 0
SQL Comments (Comment in SQL Query)
In this article, I have provided example to add comment in SQL Query for SQL Server, MySQL, SQL Comment in Postgres
Type
Article
1286 1
What is database management system and it's types
In this article, I have explained what is a database management system with its advantages and types of database management system.
Type
Article

1248 0
Free SQL Server Reporting Tools
In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.
Type
Article
1229 1
Query to get all database name in SQL Server?

I am looking at this article Query in Sql server to list all stored procedures in all databases which give all stored procedures name in all database, so I would like to know SQL query to list all databases of an SQL Instance. As I would be allowing users to show list of databases in Front-end, to select and then get all stored procedures of the database.

...
Type
Question
1146 0
Best SQL Server Tools for SQL Developers.
In this article, we have provided list of best SQL Server Tools (paid or free), which you can use with SQL Server with its features.
Type
Article
1053 1
I have deleted my database by accidentially in sql server 2017 is there is any way to recover it?

Hi, I have deleted my database by accidentially in sql server 2017 is there is any way to recover it? Thanks.

...
Type
Question
935 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article

Page 7 of 10