Question:- Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it...
2013-12-28
774 reads
This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-28
24 reads
This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-28
724 reads
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...
2013-12-28
532 reads
In my IT career, one of the things I have found that sets me apart is my ability to write....
2013-12-27 (first published: 2013-12-23)
16,500 reads
This is the third installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-27
7 reads
This is the third installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-27
1,006 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-27
557 reads
Reader Query
My publisher recently forwarded me a question from a reader about the “Using the PROPERTIES() function to retrieve data...
2013-12-27
1,517 reads
I had a request this morning for something I though was actually very simple:
Client: “Can you extract all data for...
2013-12-27 (first published: 2013-12-20)
6,339 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers