Sql

Search

column with prefix in sql

create table  #test
(
Id int identity(1,1),
Pid as 'PRE-'+REPLACE(STR(id, 7), SPACE(1), '0')
)
 
INSERT INTO #test DEFAULT VALUES
INSERT INTO #test DEFAULT VALUES
select *From #test

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql update sum same table
Sql :: sql server concat null
Sql :: google sheets data validation custom formula filter
Sql :: doctors appointment
Sql :: adding column
Sql :: insert to first table if field A equals field B from a second table using sql
Sql :: sql count * vs count 1
Sql :: ranking functions in sql
Sql :: Why mysql is used?
Sql :: sqlite csv
Sql :: decimal to integer sql
Sql :: sql from
Sql :: sql Not like operator
Sql :: order by in sql
Sql :: fuck docker mysql
Sql :: System.Diagnostics.Process is not supported on this platform
Sql :: grant privileges mysql to database 1064
Sql :: mysql create index lost connection
Sql :: 5000/208
Sql :: SQL BETWEEN OPERATOR With Texts
Sql :: change mysql paasword in cmd
Sql :: sql declare variable single line
Sql :: convert db timestamp to date
Sql :: postgresql not in alternative
Sql :: Stack conditions in CASE statement in PL/SQL
Sql :: mysql reset wp_options
Sql :: insert new department and employee record
Sql :: Convert LDAP Epoch to Date
Sql :: T-SQL look for records with a hex value in a text field
Sql :: Join base on multiple or conditions

Search

SQL

column with prefix in sql

ADD CONTENT