The data type is varchar(20).How can I put the IP into this.Please teach me.Thanks for any suggestions.
The data type is varchar(20).How can I put the IP into this.Please teach me.Thanks for any suggestions.
Change it to [update tb_User set IP='8.8.8.8' where ID=10000;].Is work.hahahaha
Hi @13332011, welcome to Microsoft Q&A forum.
Yes you are right as we need to add single quotes to the text when working with varchar/string fields.
Also you could go through the below link for some widely used queries. At the end of article we have other helpful links as well.
If answer helps, please mark it 'Accept Answer'
9 people are following this question.