So I have a DataGridView called MyMovieDataDrid which is connected to a sql server, and I already have my IsDeleted property, and a delete repository which is s
I have a WinForm application developed on one laptop connected to an SQL server on the same laptop. I have a new laptop and have created a docker setup for an S
I want to save new record in SQL table. one of this table field is "username" that I want to add record by using session and other fields are
Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance?
The purpose of my application is when a user types in a customer, their username and a message into the respective textboxes, it's supposed to be recorded into
My audit trigger,shown below, works great except that I am required to record who exactly made the change. As written the system user field was supposed to do t
I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2
I have the following data set: which is daily sum. Based on this, how do i get last 7 days sum, 14 days sum and 21 days for each row in new columns. I have trie
say I have 3 values, Bill, Steve, Jack. and I want to randomly update a table with those values, eg Update contacts set firstname = ('Bill','Steve','Jack') whe
I have some WKT/WKB data in the MSSQL server like this and would like to show them on the map with the help of leaflet, Openlayer, OpenStreetMaps, or GoogleAPI.
I have a task to remove a JSON property saved in a SQL Server database table's column. Here is the structure of my table OrderId Name JSON In the JSON c
I am using SQL Server 2008. I would like to give users possibility to copy files. Is it possible without using XP_CMDSHELL procedure? Cause i should not change
When attempted to run a scaffold command I am now receieving the exception noted below. It may be important to note that this stopped working all of a sudden. C
I have a to check the current month and current year value for a measure in ssas tabular model but due to type mismatch i am not able to do this. For this, i ha
I am a newbie and I have recently started working developing a web application, I do not have much experience so if you are able to solve the problem and explai
I have a small question to ask. How to round a numeric field upto 2 decimal places, and also show it with 2 decimal places only For example th
I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to conn
I have: Collisions{PK_id, cashLoss, deaths, city, state, county} I want: Collisions{PK_id, cashLoss, deaths, #IdLocalization} Localization{#LocalizationID(a
I installed SQL Server Management Studio and it worked fine. After that I updated my Visual Studio from 2010 to 2013 Express edition, now it is not working with
Here is my query: IF EXISTS(%some query%) BEGIN BEGIN TRY ALTER DATABASE [MyDatabase] SET single_user WITH ROLLBACK IMMEDIATE; --d