|
|
|
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 Checking if a log in exists in the SQL Server Posted by TomTom at 5/22/2004 9:03:15 PM I am trying to add a log in my SQL DB and ran the procedure below in Query
Analyzer.
exec sp_addlogin 'tomtom','mypassword'
The problem is I get the warning below when I ran this procedure for the
second time.
The login 'tomtom' already exists.
Can someone let me know how I can check i...more >>
Finding Missing Dates in ... Posted by Robert Taylor at 5/22/2004 7:25:44 PM I have a temp table that stores several aggregate values for data
manipulation. For several elements I need to know what months they are
not found in this table.
I am running into a problem when the months are not all the same
duration. When March is missing , but April and May are present i...more >>
Common searches using search phrases, with options for 'all words', 'any words' or 'exact phrase'? Posted by GM at 5/22/2004 6:22:42 PM This must be a common question, but a day of research hasn't got me an
answer I can use.
How to do common searches using search phrases, with options for 'all
words', 'any word' or 'exact phrase'?
Is it best to just create the query in webpage code like VB.NET and execute
in on the ...more >>
How to Convert Access Transform/Pivot Query for SQL Server Posted by Charles Law at 5/22/2004 5:11:36 PM Sorry for cross-posting this, but I have had no luck in some of the other
Access and SQL Server groups, so I thought I would try here.
I have two queries that I use in Access:
<qrySelect>
SELECT table2.column1, table2.column2, table2.column3, table1.column4 FROM
table1, table2 WHERE table1....more >>
out parameter Posted by Ran Y at 5/22/2004 3:10:36 PM hello all,
i am trying to get a returned value from a SP using an out parameter.
my code is in C# and i need some help (pls).
be greatfull if you send an example of the SP and the C# code that execute
it and collect the returning parameter value.
thanks a lot, Ran.
...more >>
Recursive SQL - Parent-Child Posted by Daniel Sitima at 5/22/2004 2:41:55 PM Hello,
I have a hierarchy Parent-Child.
I want to pass as parameter the code of the Parent and to return all the
existing children and children of the children.
Somebody has an example.
PLEASE.. That is urgent...
Tks!!!
...more >>
Setting Query Analyzer's default database? Posted by Dean Slindee at 5/22/2004 2:31:03 PM Is there a way to set Query Analyzer's default database to be something
other than 'master'?
Have looked in Options and Customize menus, but did not find anything there.
Thanks,
Dean Slindee
...more >>
Difference between openrowset and opendatasource Posted by TomTom at 5/22/2004 2:06:56 PM It looks like OpenDataSource was introduced in SQL 2000, but I wonder what's
the difference from OpenRowSet. Looking at the construct, they look very
similar. BOL also does not explain the differences. What is the major
difference? Thanks!
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Query difficulty Posted by Mike at 5/22/2004 12:41:01 PM I'm having difficulty importing data from a text file. Consider the following three tables
table
[Imported ID] char 6
[Version] in
table
[ID] int P
[Imported ID] char 6
table
[ID] int FK to table
[Version] in
tableA is a temp table consisting of all the imported records (roughly 15,000...more >>
crosstab query Posted by amish m shah at 5/22/2004 11:08:14 AM HI ALL
How can I Create Cross tab query in Sql Server
Thanks
...more >>
parameter view or query Posted by amish m shah at 5/22/2004 10:36:53 AM Hi all gurus
How can I create parameter View in Sql Server and can I use that parameter
view in any other view. If not possible there is any other way for it?
Thanks
...more >>
search phrase Posted by Reza Alirezaei at 5/22/2004 10:21:57 AM I am going to search an specific keyword in a field and I used following
line in my sp,I just wondered if it is optimized enough.
select * from study where [name] like '%' + @Keyword + '%'
How can I make my search case sensitive?
Thanks for your time.
...more >>
Query Help Posted by pflint at 5/22/2004 8:56:04 AM I have 12 tables, each has around 250,000 records; each of those records being a sale of a given SKU (item). Say, for argument's sake, these are Home Depot (this is purely fictional -- just trying to inject some "real world" into this) sales.
So -- I want to structure a query which returns all s...more >>
cant a trigger do two actions at a time?? Posted by R.D.CHETTY at 5/22/2004 6:36:05 AM in the given code below trigger is doing first action of the if condition. it is not updating the values in the reservations table when criteria is satisfied
Any help. Thanks in advance
ALTER TRIGGER cancellationTable_Trigger
ON dbo.cancellationTabl
FOR INSER
A
DECLARE @TEMPRIDNO in
DECLA...more >>
XML in stored proc and execution plan Posted by Mark Goldin at 5/22/2004 5:58:44 AM In general, is a stored procedure that receives XML to update data
optimizable?
Does it get recompiled every time it's called?
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |