|
|
|
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 August 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 Can I add a reference to an external DLL in a managed CLR C# stored procedure? Posted by sacha.stanton NO[at]SPAM gmail.com at 8/3/2007 8:42:49 PM Hi,
my managed CLR stored procedures are working fine, but I need to
import a .NET C# DLL that contains specialized functions I need to
call.
Is this possible? I can't seem to find any way to add the reference.
Thank you.
...more >>
Creating xml file from query Posted by Derekman at 8/3/2007 7:06:01 PM Is it possible to use SSIS or a query that queries an xml column or uses a
FOR XML clause to output the results directly to am xml file to a path?
Any help would be greatly appreciated....more >>
Calculate # seconds from now until :30 past the hour Posted by Karch at 8/3/2007 6:23:00 PM How best to calculate the number of seconds from now until 30 minutes past
the hour?
...more >>
Exception has been thrown by the target of an invocation Error in SQL SERVER 2005 Posted by at 8/3/2007 3:31:28 PM I have a view in SQL Server 2005 Management Studio in which I am
trying to left join 4 tables. Each table has 210 columns in it and I
need to carry over all columns. I am able to carry over 655 columns
without getting an error. When I add one additional column to make it
656 I get this pop-up ...more >>
Implementing AD Role Based Security Within Query Posted by VC at 8/3/2007 1:24:00 PM Good Afternoon,
--SUMMARY--
There was an interesting article posted at
http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx. This
article spoke about methods used to implement row based security. Based on
this article, I have determined a new approach to this method which w...more >>
is this so wrong... Posted by rodchar at 8/3/2007 1:12:03 PM hey all,
Insert into @TblGenderStats
(gender,empPct,empAvgSal) values('female', @FemalePercent,
NULLIF((@AvgFemaleSD_Salary/1000.00),0)
sql doesn't like my NULLIF, am i using this function in the wrong context.
all i want to do is if the value is NULL make it 0.
thanks,
rodchar
...more >>
uniqueidentifier Posted by glbdev NO[at]SPAM gmail.com at 8/3/2007 11:18:45 AM Hi,
I am having a problem taking a uniqueidentifier from a table and
setting it to a variable. Once I have this variable I will use it to
insert into another table (that field is also a uniqueidentifier).
Here is my current code:
DECLARE @GUIDNo uniqueidentifier
SET @GUIDNo = 'SELECT ol...more >>
SQL Server Express and ASP.net Posted by Alex at 8/3/2007 10:40:17 AM Hello,
OK, my boss came to me with this question today in hopes that I had an
answer, which I don't. He is writing a program using ASP.net and SQL
Server Express. When a record is written it goes in fine. No errors,
moves on to the next record, it can be queried... it's there. When he
clo...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Query with Left and Right Join Posted by Gunady at 8/3/2007 9:56:29 AM Does anyone have idea how to join table that can reflect both left and
right join?
For example:
==========
Table A Table B
Column1 Column2 Column3 Column4 Column1 Column2 Column 3
Column5
A Jan 5 xxx ...more >>
BULK INSERT with Spanish Text Posted by Michael Cook at 8/3/2007 9:38:06 AM I am trying to use BULK INSERT to import a file with Spanish text. I can
manually insert the rows into my table and they look good so I know that my
table is setup correctly. But using the BULK INSERT Commands, I have
truncation errors and the data that ends up in the table is missing some of ...more >>
Scheduling SSIS package in SQL job Posted by Derekman at 8/3/2007 9:28:12 AM I have created an SSIS job, using the Import/Export wizrd, and stored it in
SQL. How can I call this in a scheduled job from the same server?...more >>
how to evaluate a variable in dynamic sql? Posted by light_wt at 8/3/2007 9:24:02 AM basically, i have this statement needed to be evaluated at run-time...
insert into my_table_totals (table_name, totalrecs)
( select @table ,(select count(*) from @table ))
so far, i can't get the first @table to be evaluated.
declare @table varchar(50) ,@line varchar(500)
open cr_tabl...more >>
is there a way to get the count this way Posted by rodchar at 8/3/2007 8:20:02 AM hey all,
given:
in a stored procedure
sql server 2005
select name from employees
question:
i know i can do a select count(*) but i was wondering if there was a way to
get the count immediately after the select statement above?
I'm guessing something along the lines of SELECT @@Identity....more >>
Logical operators and their order of execution Posted by beginner16 at 8/3/2007 7:45:30 AM hello
Say we have tables:
WORKER ( W_name, W_code#, type_job) =EF=83=A0
PRODUCT ( P_name, P_code#)
WORKED_ON (W_code#,P_code# )
Say I want to find out on which products do workers with job title
type_job=3D=E2=80=99uh=E2=80=99 or type_job =3D =E2=80=98uh1=E2=80=99 work =
...more >>
problem using count and top Posted by Mike P at 8/3/2007 6:47:25 AM Can somebody please tell me what is wrong with my code below? The first
SQL statement is checking if a record exists in the table where certain
fields have certain values. If there is no record that meets this
criteria, then I the second SQL statement is meant to get a value from
the table and...more >>
Stored procedure with IN clause Posted by David C at 8/3/2007 12:00:00 AM I have a stored procedure that I want to send a zero or an array of integers
to get records back. If I send it 0 then I want all records (no WHERE
clause). if I send an array, then I want to use it in an IN(x,x,x) clause.
Below is my stored proc that is giving me errors when I send it an arr...more >>
How to measure db load with SQL Profiler Posted by at 8/3/2007 12:00:00 AM Can anyone tell me what I need values I need to add in SQL Profiler to
be able to see how much load a bunch of queries cause the sql 2000
server.
...more >>
Establishing Column from Variable Posted by Nirmal Singh at 8/3/2007 12:00:00 AM I have a table with the following structure:
Empno VarChar(10) NOT NULL
StartDate DateTime NOT NULL
EndDate DateTime NOT NULL
Jan SmallInt NULL
Feb SmallInt NULL
...
Nov SmallInt NULL
Dec SmallInt NULL
I need a stored procedure to update one of the...more >>
Perf Monitor not showing all DBs Posted by at 8/3/2007 12:00:00 AM I'm using Performance Monitor and trying to select a specific database
using performance object "SQLServer:Databases" but the specific
database is not displayed in the "Select instances from list" list
box. I can see it clearly in Enterprise Manager (it's SQL 2000 dbs)
so I'm a bit lost on why...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |