-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm somewhat new to SQL and need help with query syntax.
My issue involves 2 tables within a larger multi-table join under Transact-SQL (MS SQL Server 2000 Query Analyzer)
I have ACCOUNTS and LOGINS, which are joined on 2 fields: Site & Subset.
Both tables may have multiple rows for each Site/Subset…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is there an IDENTITY column type that generates alphanumeric values?
Like 023904F?
>>> More
-
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000 rows in it the accumulated over the past 2 years. Say you want to delete all but [...]...Did you know that…
>>> More
-
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000...
This site is a resource for asp.net web programming. It has examples by Peter Kellner of techniques…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have an issue where I am trying to order a result set by what I believe to be a numberic column in my database. However when I get the result set, It has sorted the column as if it was a string (So alphabetically), instead of sorting it as an int.
As an example. I have these numbers,
1 , 2,…
>>> More
