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.
...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.
...When I am trying to login into my local database server using SQL server management studio, I am getting an error, as shown below
A connection was successfully established with the server, but then an error occurred during the login process.
(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) ...
I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.
So, how can I enable full-text index to remove above error?
...Good day!
Need help to SUM and JOIN 2 columns with different tables but do no want to SUM qty and duplicates row result
here's the sample data tables;
Transfer Shipment table;
TransTO - TransFROM - ItemNo - Desc - Desc2 - VariantCode - Qty
Location1 HO Item01 Active Black Variant01 5 <------ Delivery
Location1 HO Item01 Active Black Variant01 5 <------ Delivery
HO Location1 Item01 Active Black Variant01 2 <------ Pull-out
HO Location1 Item01 Active Black Variant01 1 <------ Pull-out
Sales Entry table;
Loc Code - Item No - Variant Code - Qty
Location1 Item01 Variant01 -1 <------ PSales
Location1 Item01 Variant01 -1 <------ PSales
Item Entry table;
Loc Code - Item No - Desc - Desc2- VariantCode- Qty - EntryType - DocNo
Location1 Item01 Active Black Variant01 4 2 ItemAdj0001 <------ PAdj
Location1 Item01 Active Black Variant01 1 2 StrAdj0001 <------ PAdj
Location1 Item01 Active Black Variant01 -1 1 MSales0001 <------ MSales
Location1 Item01 Active Black Variant01 -1 1 MSales0002 <------ MSales
Location1 Item01 Active Black Variant01 -1 3 LocAdj0005 <------ NAdj
Location1 Item01 Active Black Variant01 -1 3 BtqAdj0008 <------ NAdj
SUM and JOIN (the sql query result should be like this)
Loc Code - Item No - Desc - Desc2 -VarCode- Delivery -PAdj- Pull-out - PSales - MSales - NAdj - Total
Location1 Item01 Active Black Variant01 10 5 3 -2 -2 -2 6
here's my sql query code;
...I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with message
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace...
Trying to SUM and JOIN 2 columns with different tables but it duplicates results, here is my query
...Hello, I can across a question earlier today while working at the office and would like to know if sql server management studio is free to use or we need to pay for it?
...Getting error in SQL server stored procedure when executing it:
...