SQL Server database programming

I would like to create a Stored Procedure for breaking up a Text column into a result set of one or more varchar(8000) rows.  E.g., something like this: CREATE PROCEDURE TextToRowset @TextColumnName TEXT AS ... Where the result set would be one or more rows that looked like this: ...

I ran two different tests on instances of SQL Server 2000 and SQL Server 2005 running on the same machine.  The first involved a simple tight loop (while statement) of 50,000 interations in a procedure with no processing. ...

Hi. I'm sorry to bother all of you, but I have spent two days looking at code samples all over the internet, and I can not get a single one of them to work for me. I am simply trying to get a stored procedure ...

hey all, i have a stored procedure i'm working on and it determines an employee's vacation and sick time. is it ok to have both of these in one stored procedure? and depending on the hours available there should be status ...

This is one of those things I can't figure out, but feel like I am missing something very simple.... I have a table where one of the columns contains a number that is 7 or more digits long.  The whole number means one thing, but the right 6 digits are ...

Hi Everybody, How do I programatically set "on delete cascade" to true in SQL Server? I have a Users Table and I have bunch of other tables which has Fkey for Users table, so I need to programatically set the "on delete cascade" to ...

I need to replace the old interface DbLibrary from C++ code (ntwdblib.dll), replacing with ADO (i.e. using #import <msado15.dll>). One handy functionality the DbLibrary had was dberrhandle(my_error_handler) and dbmsghandler(my_msg_handler), that was called from PRINT statements issued ...

Hello, I have an sp1 which calls sp2 which calls sp3. Is it correct that if I only need to surround the code of sp1 with BEGIN / END TRANSACTION to run all the code in a Transaction? Thank You Joachim ...

Hello, I have this table: startdate    enddate       price 11/01/06   11/21/06       45 11/24/06   11/31/06       40 ...