beginer
378
Points
99
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:
130
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:
303
Total Answered:
2
Total Marked As Answer:
0
Posted On:
23-Jan-2023 22:57
|
beginer
378
Points
99
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:
790
Total Answered:
2
Total Marked As Answer:
0
Posted On:
10-Feb-2022 21:49
|
edx
164
Points
42
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:
997
Total Answered:
1
Total Marked As Answer:
0
Posted On:
29-May-2021 05:31
|
edx
164
Points
42
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:
3089
Total Answered:
2
Total Marked As Answer:
1
Posted On:
09-May-2019 05:47
|
Ankit t...
40
Points
20
Posts
|
how can Send SMS using stored procedures from SQL Server 2008
Views:
9558
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:
24615
Total Answered:
2
Total Marked As Answer:
1
Posted On:
23-Jan-2018 04:35
|
edx
164
Points
42
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:
17738
Total Answered:
2
Total Marked As Answer:
1
Posted On:
11-Jun-2017 21:50
|
Kailash...
66
Points
28
Posts
|
Hi Sir, How to Access SQL server using Static IP ?
Views:
9526
Total Answered:
1
Total Marked As Answer:
0
Posted On:
06-May-2017 03:26
|
indrada...
54
Points
17
Posts
|
1
A
1
B
1
C
2
A
1
D
2
B
2
c
Select this table so we get below result
1
A
1
1
B
2
1
C
3
2
A
1
1
D
4
2
B
2
2
C
3
Please give me res ...
Views:
9561
Total Answered:
3
Total Marked As Answer:
0
Posted On:
07-Mar-2017 05:53
|