当前位置：网站首页>How does sqlserver insert or update the number of weeks of the day instead of text
How does sqlserver insert or update the number of weeks of the day instead of text
2022-04-23 12:16:00 【CSDN Q & A】
SQLserver How to insert or update the number of weeks of the day ,bit Not the text .
Please grant me your advice
Take the answer ：
Your problem can't be realized SQLServer bit type Can only store 0 1 null Unable to store the number of weeks . If you want to get the day of the week, you can use the following statement
-- Set the language of the database to Chinese
SET LANGUAGE N'Simplified Chinese'
-- Get the day of the week
SELECT DATENAME(weekday,GETDATE())
版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204162106055566.html
边栏推荐
- Array---
- Next. JS static data generation and server-side rendering
- AI video cloud vs narrowband HD, who is the darling of the video era
- 5-minute NLP: text to text transfer transformer (T5) unified text to text task model
- Chapter 4 specifies the attribute of the inmemory column on the no inmemory table for im enabled filling objects: examples (Part IV of im-4.4)
- Idea code quality specification plug-in sonarlint
- SQL exercise (I)
- Pagoda panel command line help tutorial (including resetting password)
- What is a gateway
- PSCP basic usage
猜你喜欢
随机推荐
第四章 为IM 启用填充对象之启用和禁用列（IM-4.3 第三部分）
The database navigator uses the default MySQL connection prompt: the server time zone value 'Ö Ð¹ ú±ê ×¼ ʱ ¼ ä’ is unrecognized or repres
User interface and im expression (IM 5.6)
万事有你 未来可期 | ONES 2022校园招聘正式开启
Idea code quality specification plug-in sonarlint
Pagoda panel command line help tutorial (including resetting password)
Why is there a wrapper class? By the way, how to convert basic data types, wrapper classes and string classes?
激活函数之relu函数
Relu function of activation function
力扣-70.爬楼梯
软件测试基础DAY2-用例执行
欣旺达宣布电池产品涨价 此前获“蔚小理”投资超10亿
31岁才转行程序员，目前34了，我来说说我的经历和一些感受吧...
Nativeformysql connects to MySQL 8 prompt: 1251 - client does not support authentication protocol
Windows11 安装MySQL服务 提示：Install/Remove of the Service Denied
Windows2008系统如何切换PHP版本
第四章 为IM 启用填充对象之为IM列存储启用ADO（IM 4.8）
运行报错:找不到或无法加载主类 com.xxx.Application
Fabric 1.0源代码分析(33) Peer ＃peer channel命令及子命令实现
What is a gateway