All Questions
3 questions
0
votes
2
answers
818
views
SQL Server : generate random numeric string 27 characters long
I need to insert random data in my database for testing, and would need to generate a numeric string (can start with 0) 27 characters long.
I've been looking into NEWID() but it contains also letters, ...
- 4,181
4
votes
3
answers
24k
views
How to insert empty string (' ') to decimal or numeric in SQL Server?
Is there a way to insert an empty string (' ') into a column of type decimal?
This is for the example :
create table #temp_table
(
id varchar(8) NULL,
model varchar(20) NULL,
Plandate ...
- 118
-3
votes
1
answer
1k
views
SQL extract multiple numeric values from string column [closed]
I read and used the function suggested in this article:
http://blog.sqlauthority.com/2008/10/14/sql-server-get-numeric-value-from-alpha-numeric-string-udf-for-get-numeric-numbers-only/
and it works ...
- 1,231