smithmartin
|
Registered User
|
- SELECT TOP 10 * FROM Posts WHERE Tags LIKE '%sql-server%'
- SELECT TOP 10 * FROM Posts
- Comments to Answers to my Questions by specific user
- WITH YourQuestions AS ( SELECT Id FROM Posts WHERE OwnerU...
- WITH YourQuestions AS ( SELECT Id FROM Posts WHERE OwnerU...
- WITH YourQuestions AS ( SELECT Id FROM Posts WHERE OwnerU...
- WITH MyQuestions AS ( SELECT Id FROM Posts WHERE OwnerUse...
- SELECT * FROM Posts WHERE OwnerUserId = 73226 AND PostTyp...
- SELECT * FROM Users WHERE Id LIKE '122902%'
- SELECT * FROM Users WHERE Id LIKE '229023'
- SELECT * FROM Users WHERE Id LIKE '%229023%'
- SELECT * FROM Users WHERE Id LIKE '1229023%'
- select top 1 *,len(Body) from Posts Order by len(Body) desc
- select top 1 *,len(AboutMe) from Users Order by len(About...
- SELECT TOP 1 * FROM Users ORDER BY floor(len(AboutMe)/100...