I want to be able to select the top n results from a results table in a stored procedure but depending on the event I want to vary how many 'n' is. I thought that this would do the trick: CREATE PROCEDURE sp_best ( @NumBest [int], @Entry [int]) AS select top @NumBest Results.RunNo, Results.Points FROM […]
2001-11-15
2001-10-20
4 reads
Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman
2001-09-05
2 reads
We are using Win NT and SQL server 2000 When I run a stored procedure, I get Server: Msg 137, Level 15, State 2, Procedure pr_delopp, Line 29 Must declare the variable '@oppid'. This is because variable @oppid is declared as @OppID (different case). The SQL server 2000 installation which is on my own machine […]
2001-07-19
2 reads
This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.
2001-06-06
1,416 reads
In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.
2001-05-09
7,115 reads
In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.
2001-05-07
3,406 reads
So, you've added a linked server and need information about it. There must be an easier way to fine information about your linked server and keep from walking to the server room.
2001-05-07
9,070 reads
A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.
2001-05-06
21,280 reads
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
Ask SSC