Im using sql server 2008.
how i insert data to sql server 2008 with combine text and number with together ?
for example add record sequency :
me1
me2
me3
me4
.
.
.
how i write query for this ?
-
If possible I recommend to use some programming language to generate a big insert script for you. If not, It's possible with T-SQLStasel– Stasel2013-07-02 07:06:19 +00:00Commented Jul 2, 2013 at 7:06
-
yes i want t-sql codepencilvania– pencilvania2013-07-02 07:07:57 +00:00Commented Jul 2, 2013 at 7:07
Add a comment
|
1 Answer
Try to create Computed Column. Please refer the links for more details
Computed columnn specification can have column as parameters. Like
('me'+CONVERT([nvarchar](20),[ID],(0))), where me is your text and ID is the an identity column.
For existing data, you can use an update statement.
WITH X AS
(
SELECT
'me'+CONVERT(NVARCHAR(20), row_number() over (order by ExistingColumn)) RNum,
*
FROM YourTable
)
UPDATE X SET NewColumn=x.RNum
