|
|
|
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 Temp table problem Posted by jack at 1/6/2007 10:17:26 PM Hi All,
Im creating a temporary table in a procedure in an if condition but it
is giving a error like table already created.
What i want is that depending upon the condition the result in the
table data should be displayed. below is the procedure but gives me
error.
-------------------------...more >>
necessary help-difference Posted by Nassa at 1/6/2007 10:16:24 PM Hello Everyone,
Does it make difference in query costs(query performance),if add all
columns of 2tables or choose just some columns of 2 tables?
which one is the best?Y?
Thanks,
Nassa
...more >>
converting Crystal formula to SQL Posted by childofthe1980s at 1/6/2007 9:09:00 PM Hello:
A few weeks ago, I created a stored procedure in SQL based on a query of my
Crystal 8.5 report. I have had to modify my report considerably this week
and, as a result, will have to recreate my query for my stored procedure.
The report shows sales invoices, as well as the credit mem...more >>
Copy files from one server to another server using a stored procedure Posted by research_stuff at 1/6/2007 8:51:40 PM I would like to copy files from one server to another server using a
stored procedure.
During my research, someone mentioned sp_oa stored procedures. I have
not found any examples.
Is there any examples or is it possible?
I cannot use xp_cmdshell due to security issues.
Thanks in ...more >>
Dynamic SQL in stored procedure (Case something, add "AND statement") Posted by Øyvind Isaksen at 1/6/2007 8:51:17 PM I have a stored procedure that lists companies from a table.
The table has a column named "isProject" (true/false) and a column named
"private" (true/false).
If a record has "isproject" = True AND "private" = True then the emplyeeID
must be @employeeID".
Is "isProject" = False or "private" =...more >>
order by nvarchar Posted by Eric F. at 1/6/2007 3:00:09 PM Do you have to do anything special to sort by a column of NVARCHAR ?
I've seen code written using order by ..then CAST as varchar
required ? better ways ?
...more >>
Getting IDentity back from sp Posted by Tina at 1/6/2007 2:29:10 PM The following insert stored procedure was generated by the 2.0 tableadapter
wizard (I have applied the latest service pack to vs2005)
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'NewInsertCommand' AND
user_name(uid) = 'dbo')
DROP PROCEDURE dbo.NewInsertCommand
GO
CREATE PROCEDURE dbo...more >>
Why does this not work ? Posted by Hassan at 1/6/2007 1:06:51 PM CREATE PROCEDURE proc1 @tname sysname AS
SELECT * FROM @tname
Also can someone explain with an example what does it mean when they say
that you cannot access local variables or parameters in dynamic SQL
I seem to run this and it works
declare @dbname sysname
select @dbname = 'master'...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Questions about XML type in SQL2k5 Posted by brett at 1/6/2007 12:16:13 PM I'm reading 'SQL Server 2005 Implementation and Maintenance' self pace
training kit by MS Press. On p.259, it mentioned this advantage about
storing XML in text columns:
XML provides textual fidelity. All details such as comments and white
space are preserved.
Then on p.261, it has this l...more >>
How to do Select Statement; linked server third party DB Posted by Stephen K. Miyasato at 1/6/2007 9:32:48 AM I get this error
Server: Msg 15427, Level 16, State 1, Procedure sp_addlinkedserver, Line 60
You must specify a provider name for unknown product 'SQL
Server'.
Mdsync3.OfficeMedic
I'm using SQL2000 with enterprise manager. The second set of database is a
third party tool that install MSDE ...more >>
CREATE TRIGGER... Posted by CipherTeKST at 1/6/2007 8:04:00 AM Need help creating a trigger that will update one column in one table after a
column in another table is inserted or updated. Here is the syntax i have so
far
Create trigger triggerone on table2
as
after insert, update
begin
if update(table2.column1)
set (table1.column1) = (table2.column...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |