home
I am trying to parse xml data for any leaf nodes It is structured like this: <rootNode> ...
Windows Form applications have an out-the-box tab control but it looks basic. Are there any other...
I have created a scheduled job in SQL Server Management Studio which executes a stored procedure at...
I have looked around for examples that are specifically like what I have but I just can't find...
I need some help mimicking a TFS query. I have tried writing the following SQL query to do so but I...
My team is moving from our current source control option to Team Foundation Server. I've been...
I don't know if this is common, but in my company, we have certain "standard" columns that we need...
I have a flat file containing some data which I'm inserting into a table in SQL Server...
So i have Row Level Security Policy in place, and am using session context to define Tenant...
I have been building a SSRS report which will allow a user to update a single field of a column in...
(select DISTINCT le.[NAME] as lessor...
I have a problem with internal conversion of SSMS. I have a column type varchar(50). In this...
after installing visual studio 2017 on my system, i get this error when run my ssms 2017 ver 17.4...
The goal is to add 50 to the Inactivity int if a person does not have a row in table PlayerToWar...
select ci.client_code, ci.cardid,cs.CLIENT_SUIT_ID, cs.EXPIRE_DATE from client_info ci inner join...
I've installed SSMS on my desktop and for some reason it's rendering fonts in the Connect to Server...
I have a query that prints records of clients all in one result sheet. I would love that to be on...
I'm new to SQL Server. There are a couple of tables that in my team's database that we need to...
Folks, I am a novice, really a business user (not techie), in SSMS v 17. I used to update a MS Sql...
In an SSIS Data Flow Task I seek to import data using an Excel Source Task connected to an xlsx...
DROP TABLE #bbb SELECT DISTINCT Mrn.PrefixMedicalRecordNumber AS 'Key', ...
I found a legacy sproc in our system that includes a redundant second join for "performance...
I want to take a Database from a SQLServer 2016 and set it up on a 2014 server on a clients'...
I do a lot of copy/pasting between xml files in java and sql in SSMS. SSMS needs "less than" to be...
I'm looking at some incredibly complex views in a Sql Database. I've found several columns that are...
I have update and delete permissions (not ALTER) for a Azure db table and am trying to import a CSV...
i create the query SELECT Dt, CustomerName, ItemRelation, SaleCount, DocumentNum,...
Analysis server model was created using the Power BI. Uploaded the model to the Azure Analysis...
How to sum values into categories in...
I'm trying to execute a query sp_who2 'active' using java in Microsoft SQL server management...