在SQL Server列中设置类似*的掩码 [英] set a mask like * into the sql server column

问题描述

我使用sql server2005.

如何将掩码字符设置为输入字符?可以像MS Access一样提供任何数据类型属性吗?

I use sql server 2005.

How can I set a mask character to a input character? Can there is any datatype properties available like MS Access has?

Can any one give my any kind of suggestions?

推荐答案

您所指的是通配符字符.

此 [

What you are referring to are known as wildcard characters.

This[^] is just one of the thousands of hits from searching on sqlserver wildcard characters.

If the link above is not what you want then search for yourself and pick another.

如果您不希望人们能够阅读它，请不要按原样存储它.相反，您应该存储它的加密或散列版本.

If you dont want people to be able to read it, dont store it as-is. Instead you should store an encrypted or hashed version of it.

这篇关于在SQL Server列中设置类似*的掩码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！