T-SQL Analyzer

Overview Schema Related Servers Score Discussions

SqlServer.Rules
sqlprojects
TSQLSmellsTest

BeginEnd.sql
ConvertDateMultiCond.sql
ConvertDate.sql
ConvertInt2.sql
ConvertInt.sql
CreateProcedureExplicitTransaction2.sql
CreateProcedureExplicitTransaction.sql
CreateProcedureNoSchema.sql
CreateTableClusteredColumnStore.sql
CreateTableNoSchema.sql
CreateTableTemporalHistory.sql
CreateViewOrderBy.sql
CteAlias.sql
DeclareCursor.sql
DeprecatedTypesSP.sql
DeprecatedTypes.sql
Derived.sql
DisabledForeignKey.sql
EqualsNull.sql
err.sql
Exec1PartName.sql
ExecSQL.sql
Exists.sql
ExplicitRangeWindow.sql
ForceScan.sql
FutureKeywords.sql
ImplicitRangeWindow.sql
Inject.sql
InsertMissingColumnSpecifiers.sql
InsertSelectStar.sql
KeywordCapitalize.sql
LAGFunction.sql
MissingSemicolons.sql
MultiCteTest.sql
NoMissingSemicolons.sql
orderbyordinal.sql
RangeWindow.sql
SelectFromTableVar.sql
SelectStarFromViewInProc.sql
SelectStarOutOfCteTest.sql
SelectTopNoParen.sql
SetNoCountON.sql
SETs2.sql
SETs.sql
SetTransactionIsolationLevel.sql
SingleCharAlias.sql
SingleLineComment.sql
TableHints.sql
TempTableWithNamedCheckConstraint.sql
TempTableWithNamedDefConstraint.sql
TempTableWithNamedFK.sql
TempTableWithNamedPK.sql
TestCrossServerJoin.sql
TestOnePartNamedSelect.sql
TestSelectStarBeginEndBlock.sql
TestSelectStarInCteTest.sql
TestSelectStarIninlineTVF.sql
TestSelectStarInMultiStatementTVF.sql
TestSelectStarInScalarUDF.sql
TestSelectStarInWhileLoop.sql
TestSelectStarOutOfCte.sql
test.sql
TestTable.sql
TestTokenize.sql
TestWithExistsAndNestedSelectStarInlineIF.sql
TestWithExistsAndNestedSelectStar.sql
TestWithExists.sql
TestWithNoLockIndexhint.sql
TestWithNoLockInWhiteList.sql
TestWithNoLockNoWith.sql
TestWithNoLock.sql
TokenIseTest.sql
TSQLSmellsTest.csproj
UnionTest.sql
UnnamedPK.sql
UpperFunction.sql
WhiteListTest.sql

RangeWindow.sql•316 B

/* Default is Range UNBOUNDED PRECEDING ( Defining the frame )*/ Create Procedure dbo.RangeWindow as set nocount on select sum(IdCol) over(partition by Col1 order by Col2 Range UNBOUNDED PRECEDING) as RollingBalance from dbo.TestTableSSDT order by Col1,Col2; -- SML025

Loading blob content...

Latest Blog Posts

Redis vs ioredis vs valkey-glide
By punkpeye on January 26, 2026.
benchmark
Redis
valkey
Quickstart: Publish an MCP Server to the MCP Registry
By punkpeye on January 24, 2026.
mcp
official reference mirror
Official MCP Registry Server.json Requirements
By punkpeye on January 24, 2026.
mcp
official reference mirror

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ErikEJ/SqlServer.Rules'

If you have feedback or need assistance with the MCP directory API, please join our Discord server