T_SQL Question
Aug 8, 2000Hello, can anyone give me the T_SQL statement for finding the 2nd largest number in a list of numbers??
thx
ADVERTISEMENT
SQL And T_SQL?
Jan 18, 2008What is the difference between SQL and TSQL? Does SQL have an if-elseif-elseif statement?
View 2 Replies View RelatedT_sql
Oct 26, 2005How do i use T-SQL to switch the lastname CASEY to Casey ?
View 4 Replies View RelatedT_SQL
Aug 6, 2007Hello,
I am a beginner of sorts to SQL 2000/5, and wanted to know if anyone could point me in the right direction in getting a book that explains, and instructs you on writing queries? (I would also want the book to have some examples and practices).
thx
Where Do I Find The T_SQL Debugger
Dec 5, 2007I am trying to debug a t-SQL function. I am supposed to have both Enterprise Manager for SQL 2000, and Management Studio for SQL 2005, on my computer. In the books-online for SQL 2000 there is a reference to a T-SQL debugger which does all the things that you'd expect: checkpoints, ablility to stop and examine data, etc. I don't seem to have books-online for SQL 2005 - I merely get "help on Help" which is rather useless.Anyway, how do I get this debugger to work? I can't find anything in either Enterprise Manager or Management Studip.Thanks, Robert Barnes
View 4 Replies View RelatedUsing Variables With Drop In T_SQL
Oct 17, 2000This procedure will work if @Tablename is replaced by a literal.
It all works except the last line when the variable @TableName is passed
How can I pass a variable @Tablename and get the last line to work?
CREATE PROCEDURE spDropTable
@TableName char(50)
as
if exists( select * from sysobjects where id = object_id(@TableName))
select "Table Exists "= @TableName
drop table @TableName
T_SQL, Lists And Arrays
Dec 30, 1999I want to pass my stored proc a list, and either loop through it as a list or (better) turn it into an array and loop through it that way to insert it. Psuedocode would be...
Loop from 0 to ListLength
begin
INSERT Transaction_Data
end
Thanks from an SQLS7 newbie,
jE
Executing A DTS Package From T_SQL
Aug 21, 2000Can some one point me in the right direction? I need to execute a DTS package after a set of T-SQL statements run in a stored procedure. The starting of the DTS package needs to be the last thing executed/called from the stored procedure.
Thanks