|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 IF ELSE not compiling Posted by bic at 5/15/2005 11:03:01 PM I can't seem to figure out why this SP would not compile. Your assistance is
much appreciated.
CREATE PROCEDURE sp_getPubId
@name varchar, @pubCode varchar, @pubId smallint Output
AS
DECLARE maxPubId smallint
if (exists
(select publication_id from publication where code =@pubCode))
beg...more >>
User - Defined string Functions Transact-SQL Posted by Igor2004 at 5/15/2005 10:44:02 PM Ladies and Gentlemen,
I would like to offer you the following string functions Transact-SQL
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a
character expression ...more >>
Dynamic ALTER TABLE and CURSOR Posted by Jean Dupont at 5/15/2005 2:32:01 PM I'd like to create a dynamic ALTER TABLE and CURSOR based on a variable. Is
it possible ? ...more >>
Column constraint Posted by larzeb at 5/15/2005 11:39:50 AM Is it possible to limit a column's value to 0 or 1 and to allow zero or one row to contain a value
of 1 for that column?
TIA, Lars...more >>
SQL Freezes Posted by MoeJoe at 5/15/2005 11:31:04 AM Hello All,
I have the following trigger that uses Northwind database (customers table)
on SQL 2000 (SP4), that execute a Local Package :
CREATE TRIGGER NewTrigger ON [dbo].[Customers]
FOR INSERT, UPDATE
AS
DECLARE @cmd varchar(4000) ,@CustID nchar (5)
SET @CustID = (SELECT CustomerID FRO...more >>
Finding SQL Server data directory Posted by Edward Diener at 5/15/2005 8:01:30 AM How do I programatically get the SQL Server data directory path ?...more >>
Why not change automatically? Posted by Bpk. Adi Wira Kusuma at 5/15/2005 12:00:00 AM I make a function like it
CREATE FUNCTION SP_LISTKAR_USER(@USERNAME VARCHAR(8))
RETURNS TABLE AS
RETURN(SELECT * FROM TDAV
WHERE BAGIAN IN (SELECT BAGIAN FROM THAK_UNIT
WHERE USERNAME=@USERNAME))
But when I change the structure field on table TDAV. then i execute its
function, why do the ...more >>
converting from nvarchar to money datatype Posted by buran at 5/15/2005 12:00:00 AM Hi there,
I have a table named Action. This table has a column InPrice with datatype
nvarchar(12). I want to change its datatype from nvarchar(12) to money. I
browsed through the values and removed any dots. Th column now has only
numeric values (and commas for decimal values such as 105,8). W...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
remove tab/line feed/carriage return Posted by Kriste L at 5/15/2005 12:00:00 AM Hi Everyone,
In this string "ABC ", there is trailing "tab","line feed" and "carriage
return".
Can I know how can I remove them?
Thank in advance
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |