Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
chi8708
/
SqlserverUtil
Public
Notifications
You must be signed in to change notification settings
Fork
8
Star
8
Code
Issues
0
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
master
Branches
Tags
Go to file
Code
Open more actions menu
Latest commit
History
47 Commits
47 Commits
Folders and files
Name
Name
Last commit message
Last commit date
常用sql
常用sql
1.数据迁移.txt
1.数据迁移.txt
10.索引重建.sql
10.索引重建.sql
11.统计信息更新.sql
11.统计信息更新.sql
12.数据库表、字段、备注信息.sql
12.数据库表、字段、备注信息.sql
13.存储过程、函数、视图内容模糊查询.sql
13.存储过程、函数、视图内容模糊查询.sql
14.表分区.sql
14.表分区.sql
15.抽奖.sql
15.抽奖.sql
16.收缩数据库.sql
16.收缩数据库.sql
17.用户权限.sql
17.用户权限.sql
18.一行多列取最大值.sql
18.一行多列取最大值.sql
19.查询存储过程包含.sql
19.查询存储过程包含.sql
2.日志清理.sql
2.日志清理.sql
20.行转列.sql
20.行转列.sql
21.查询执行日志.sql
21.查询执行日志.sql
22.数据字典.sql
22.数据字典.sql
23.循环清空数据.sql
23.循环清空数据.sql
24.自增Id表中插入数据.sql
24.自增Id表中插入数据.sql
25.查询数据表行数.sql
25.查询数据表行数.sql
26循环truncate table.sql
26循环truncate table.sql
27.生成10位含字母随机数.sql
27.生成10位含字母随机数.sql
28.是否后回车换行空格.sql
28.是否后回车换行空格.sql
3.update from.sql
3.update from.sql
4.查询正在运行sql.sql
4.查询正在运行sql.sql
5.传入逗号分隔明细.sql
5.传入逗号分隔明细.sql
6.字符串逗号分隔返回table.sql
6.字符串逗号分隔返回table.sql
7.自动编号.sql
7.自动编号.sql
8.CTE递归 查询多级所有子项.sql
8.CTE递归 查询多级所有子项.sql
9.数据库信息比对.sql
9.数据库信息比对.sql
README.md
README.md
sqlserver发布订阅BUG处理.docx
sqlserver发布订阅BUG处理.docx
发布脚本创建.sql
发布脚本创建.sql
数据类型转换.sql
数据类型转换.sql
磁盘映射.sql
磁盘映射.sql
View all files
Repository files navigation
README
More
items
SqlserverUtil
sqlserver运维、常用语句
About
sqlserver运维、常用语句
Topics
sql
sqlserver
tsql
Resources
Readme
Activity
Stars
8
stars
Watchers
1
watching
Forks
8
forks
Report repository
Releases
Packages
Used by
Contributors
Languages
You can’t perform that action at this time.