Category: tsql

Validate MSSQL identifier (parameter) in .NET or regular expression

Post author By user user
Post date February 19, 2022
Categories In .net, regex, sql-server, tsql
3 Comments on Validate MSSQL identifier (parameter) in .NET or regular expression

In a .NET project I need to verify if a string is a valid Microsoft SQL Server 2005 parameter identifier. Example: SELECT * FROM table WHERE column = @parameter Is there a runtime class method to validate a string for being a parameter, or is there a regular expression that verifies the rules? (see below) […]

TSQL query that would return me the earliest date and the latest date in a table

Post author By user user
Post date February 19, 2022
Categories In sql, sql-server, sql-server-2008, tsql
3 Comments on TSQL query that would return me the earliest date and the latest date in a table

I have a table in a sql server 2008 database that contains bunch of records as well as a date column. The date is inserted automatically when a new entry to the table occurs. So, it contains the date of the record that has been created. I am trying to run a query that would […]