Search Results

One final question - about locking

Thread by: jdx, Feb 5, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

I'm just wrapping up my fist piece of TSQL-related work, and this forum has saved me a great deal of time - thankyou to all. I have one final...

Registering error codes with sp_addmessage

Thread by: jdx, Feb 5, 2007, 1 replies, in forum: SQL Server 2005 General Developer Questions

A couple of quick questions: 1)If I have a SQL script defining several procedures, may sp_addmessage be called in this script outside any procedure,...

Private procedures

Thread by: jdx, Feb 2, 2007, 1 replies, in forum: SQL Server 2005 General Developer Questions

In PL/SQL you can have package-private procedures which can only be run from within the package. I want to expose an API of one or two procedures to...

A date question

Thread by: jdx, Feb 2, 2007, 8 replies, in forum: SQL Server 2005 General Developer Questions

Given two timestamps, how would you find the datetime of the start (i.e. midnight) of each Sunday within this interval? I'm not sure yet if I want...

Variable and exception declarations

Thread by: jdx, Feb 2, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

1)I read somewhere that only local variables are supported - I can declare them in a procedure but not anywhere else. Is this correct? 2)Is there...

Returing a recordset

Thread by: jdx, Feb 1, 2007, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I'm new to T-SQL (my experience is with PL/SQL) and I'm a little confused about writing a procedure/function to return a recordset. I'm not sure...