2026年1月8日

SQL Server Management Studio - Invalid Object

摘要： The "Ghost" Error (IntelliSense) SSMS has a background process called IntelliSense that parses your code as you type to provide those red squiggly und 阅读全文

posted @ 2026-01-08 17:09 ZhangZhihuiAAA 阅读(14) 评论(0) 推荐(0)

SQL Server - Procedure permissions

摘要： CREATE PROCEDURE Purchasing.uspVendorALLInfo WITH EXECUTE AS CALLER AS SET NOCOUNT ON; SELECT v.Name AS Vendor, p.Name AS 'Product Name', v.CreditRati 阅读全文

posted @ 2026-01-08 16:14 ZhangZhihuiAAA 阅读(14) 评论(0) 推荐(0)

SQL Server - Load the AdventureWorks sample databases

摘要： https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms Download the bak files from https://lea 阅读全文

posted @ 2026-01-08 12:38 ZhangZhihuiAAA 阅读(3) 评论(0) 推荐(0)

SQL Server - varchar and nvarchar

摘要： In SQL Server, the fundamental difference between varchar and nvarchar is how they store data and which characters they can handle. The "n" in nvarcha 阅读全文

posted @ 2026-01-08 11:47 ZhangZhihuiAAA 阅读(7) 评论(0) 推荐(0)


博客园 © 2004-2026 浙公网安备 33010602011771号浙ICP备2021040463号-3

导航

2026年1月8日