Programming Questions and Answers for Developers
Developer Q&A Community
Welcome to the NiceOneCode Questions and Answers community, where developers, students, and technology professionals can ask programming questions, share knowledge, and find practical solutions to real-world coding challenges.
Explore hundreds of technical questions covering .NET, ASP.NET Core, C#, SQL Server, JavaScript, Java, PHP, HTML, cloud development, APIs, Entity Framework Core, Blazor, Azure, Docker, debugging, performance optimization, and software architecture.
Whether you are troubleshooting an application error, learning a new technology, preparing for interviews, or looking for best practices, our community-driven Q&A platform helps developers find accurate answers and practical implementation guidance.
db-error
2
Points
1
Posts
|
I'm trying to export db as bacpac file but getting following error:
The reverse engineering operation cannot continue because you do not have View Definition permission on the 'mydbname' database. (Microsoft.Data.Tools.Schema.Sql)
Views:
1344
Total Answered:
1
Total Marked As Answer:
0
Posted On:
04-Oct-2024 22:50
|
sw
170
Points
7
Posts
|
I'm try to delete following constraint but not to drop it:
CREATE UNIQUE NONCLUSTERED INDEX UQ_MyTable_TypeKey ON [dbo].[MyTable]([TypeKey] ASC)
WHERE [TypeKey] <> 55555 AND [TypeKey] <> 75555)
Here is drop command:
ALTER TABLE [dbo].[MyTable] DROP CONSTRAINT UQ_MyTable_TypeKey
...
Views:
1185
Total Answered:
3
Total Marked As Answer:
1
Posted On:
21-Apr-2024 22:19
|
beginer
1576
Points
53
Posts
|
I'm trying following update command:
UPDATE tbl_tech set priceunit=N'₹' where id=2
But its not setting correct symbol and inserting '?' in the priceunit field.
How to set Unicode text (Hindi) in SQL update command in SQL Studio Editor?
Views:
1267
Total Answered:
1
Total Marked As Answer:
1
Posted On:
11-Aug-2023 22:07
|
SQL Buddy
2
Points
1
Posts
|
How to concatenate a field from multiple rows into a single text string in SQL Server?
Consider a database table 'User' holding names, with three rows as:
Peter
Paul
Mary
I want query result as comma separated string as
Peter,Paul,Mary
Views:
1284
Total Answered:
2
Total Marked As Answer:
0
Posted On:
23-Jan-2023 22:57
|
|
beginer
1576
Points
53
Posts
|
I want to reduce db size. As we using more and more transaction db log file getting big. Can we reduce log file size and so that db size will be reduced.
Views:
2083
Total Answered:
2
Total Marked As Answer:
0
Posted On:
10-Feb-2022 21:49
|
edx
506
Points
24
Posts
|
How can I put a dynamic variable for getting number of rows to return in SQL Server? Below is not valid syntax in SQL Server :
DECLARE @TopCount int
SET @TopCount = 20
SELECT TOP @TopCount * FROM SomeTable
Views:
2311
Total Answered:
1
Total Marked As Answer:
0
Posted On:
29-May-2021 05:31
|
|
edx
506
Points
24
Posts
|
In a table 'Customer', I have an Id column, which is an Identity int.
How can I make it so that the next row inserted will get identity 1000(I think, this is called the identity seed) without dropping and recreating the 'Customer' table?
I want to do this because of some uniqueness issue with an ext ...
Views:
4353
Total Answered:
2
Total Marked As Answer:
1
Posted On:
09-May-2019 05:47
|
Ankit t...
112
Points
11
Posts
|
how can Send SMS using stored procedures from SQL Server 2008
Views:
10827
Total Answered:
2
Total Marked As Answer:
0
Posted On:
30-Jan-2018 10:35
|
|
Liam
2
Points
1
Posts
|
I have following select command (round/truncate):
--Round
SELECT ROUND(100.55555552, 2)
--Truncate
SELECT ROUND(100.55555552, 2, 1)
Both giving trailing zeros
How we can remove trailing zeros?
Views:
28040
Total Answered:
2
Total Marked As Answer:
1
Posted On:
23-Jan-2018 04:35
|
|
edx
506
Points
24
Posts
|
Is it possible to add a column to a table at a specific ordinal position in SQL Server?
For instance, our tables always have CreatedDate, CreatedBy, LastModifiedDate, LastModifiedBy columns at the "end" of each table definition? I'd like the new column to show up in SSMS above these columns.
Views:
19630
Total Answered:
2
Total Marked As Answer:
1
Posted On:
11-Jun-2017 21:50
|
Developer Q&A Community
Welcome to the NiceOneCode Questions and Answers community, where developers, students, and technology professionals can ask programming questions, share knowledge, and find practical solutions to real-world coding challenges.
Explore hundreds of technical questions covering .NET, ASP.NET Core, C#, SQL Server, JavaScript, Java, PHP, HTML, cloud development, APIs, Entity Framework Core, Blazor, Azure, Docker, debugging, performance optimization, and software architecture.
Whether you are troubleshooting an application error, learning a new technology, preparing for interviews, or looking for best practices, our community-driven Q&A platform helps developers find accurate answers and practical implementation guidance.
Frequently Asked Questions
What topics can I ask questions about?
You can ask questions related to .NET, ASP.NET Core, C#, SQL Server, JavaScript, Java, PHP, HTML, cloud technologies, APIs, databases, software architecture, and other programming topics.
Can I answer questions posted by other developers?
Yes. Registered members can contribute answers, share solutions, and help other developers solve technical problems.
Is NiceOneCode suitable for beginner developers?
Yes. The platform includes beginner-friendly questions as well as advanced discussions covering enterprise application development, cloud technologies, and software architecture.
How do I ask a programming question?
Create an account, choose the appropriate category, provide a clear problem description, include relevant code examples, and submit your question to the community.