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
tri_inn
NA
1.2k
233.9k
Regarding QUEUE in sql server and its real usage
Mar 27 2015 4:44 AM
i have many doubts for queue in sql server. i searched google for queque for beginner like article but got nothing still. so i like to post few question regarding queue.
1) what is queue in sql server and what for people use queue ?
2) i guess people would store data in queue but why because we can store data in table then why people would use queue ?
3) how to create a queue
CREATE QUEUE ExpenseQueue
WITH STATUS=ON, ACTIVATION ( PROCEDURE_NAME = expense_procedure, MAX_QUEUE_READERS = 5, EXECUTE AS 'ExpenseUser' ) ;
the above statement and their option is not clear to me.
4) how to store data in queue ?
5) can queue has many field like table ?
6) can we store a customer details in queue like (custid, Name, phoneno etc) ?
7) when queue data is removed or dequeue ?
8) suppose 10 data is stored in queue then how could i read a data from queue whose custid=5 ?
9) can we explicitly remove one or two data from queue ?
10) discuss the best situation when people would use queue to store/read data from queue instead of table?
11) what is the difference between queue and table ?
please answer point wise in details.
Reply
Answers (
0
)
Looking for SQL Server DBA Tuition Classes
import data from excel with more than 255 columns