54 Questions

sw
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: 299
Total Answered: 3
Total Marked As Answer: 1
Posted On: 21-Apr-2024 22:19 
 
beginer
beginer
1492 Points
51 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: 403
Total Answered: 1
Total Marked As Answer: 1
Posted On: 11-Aug-2023 22:07 
 
SQL Buddy
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: 479
Total Answered: 2
Total Marked As Answer: 0
Posted On: 23-Jan-2023 22:57 
 
beginer
beginer
1492 Points
51 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: 998
Total Answered: 2
Total Marked As Answer: 0
Posted On: 10-Feb-2022 21:49 
 
edx
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: 1279
Total Answered: 1
Total Marked As Answer: 0
Posted On: 29-May-2021 05:31 
 
edx
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: 3329
Total Answered: 2
Total Marked As Answer: 1
Posted On: 09-May-2019 05:47 
 
Ankit tewari
Ankit t...
112 Points
11 Posts
how can Send SMS using  stored procedures from SQL Server 2008 
Views: 9853
Total Answered: 2
Total Marked As Answer: 0
Posted On: 30-Jan-2018 10:35 
 
Liam
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: 25500
Total Answered: 2
Total Marked As Answer: 1
Posted On: 23-Jan-2018 04:35 
 
edx
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: 18228
Total Answered: 2
Total Marked As Answer: 1
Posted On: 11-Jun-2017 21:50 
 
Kailash Singh
Kailash...
206 Points
23 Posts
Hi Sir, How to Access SQL server using Static IP ?
Views: 9731
Total Answered: 1
Total Marked As Answer: 0
Posted On: 06-May-2017 03:26 
 
 Log In to Chat