I need to create few txt files from an existing MSS db using some scripts. In the txt file, I need to create a new id column for each row. I like to use some function in my SQL scripts so it will create a unique id for each row. Any ideas?
Id column needs to be less that 18 characters.(I cannot use NEWID() function)
THNNKS