TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jes Sie
737
1.2k
284.4k
What is the best way of counting rows in sql server?
Apr 26 2021 1:37 AM
Hello everyone, I have a query that counts the total inserted rows in the SQL server. I added 1 to get the new row that should be inserted. See my query below:
SELECT
COUNT
(CustomerID) + 1
FROM
fmCustomer
WHERE
year
(getLogs) =
YEAR
(GETDATE())
But, here is the weird thing that always happens:
As you can see, it jumps from 21-00251 to 21-00253. Any suggestions on how can I count total rows + 1? Thanks in advance.
Reply
Answers (
0
)
I need to know how to extract the Nouns text file from the paragraphs
How to Logout from Google Account using Web Application Logout..?