|
|
|
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 SELECT DISTINCT and SUBSTRING combined to dynamically create distinct entries Posted by Johnny O. at 7/10/2004 9:34:09 PM Cross-posted from sqlserver.ce...
Is is possible to construct a query SQLCE recognizes which will return a
list of distinct entries which are a substring of a column's text? I have a
series of customer account numbers in column CAccount, such as:
CAccount
10-23452
10-23456
10-23555
12-12...more >>
Can We Explain Missing Rows? Posted by Mac McMicMac at 7/10/2004 8:49:47 PM My database has TableA and TableB (among many others). Schema information
is at the bottom of this message
Table A contains a DELETE trigger that removes rows from TableB (TableA has
no other triggers)
The problem: I just discovered that TableA is missing a bunch of rows that I
did not exp...more >>
Newbie - Drop down list alternative Posted by Tennessee at 7/10/2004 8:31:41 PM I am in the process of upsizing an access database to sql
server. In access I have several tables that are linked
to the MAIN table. The child tables only contain
information related to one Field in the parent table and
a autonumber field.
The MAIN table field has a dropdown or Combo box w...more >>
Protecting Connection String Data from End-Users Posted by ScanPlus at 7/10/2004 3:22:01 PM Hi All:
I'm writing code for a .NET app that makes extensive use of MSDE/SQL
I was wondering if any of the experts here could recommened a prefered method for protectiong my connection data from my end-users.
My application (Point of Sale) could be running in a single user environment (MSDE), or ...more >>
SELECT INTO and dropping a temp table Posted by Earl at 7/10/2004 2:42:57 PM I need multiple resultsets to appear as a single table, so I'm planning to
use SELECT INTO to combine everything I need into one temp table. I'm
speculating that I need to DROP the temp table in case it exists before
creating the new temp. Is the best approach to always call a DROP statement
in ...more >>
Concatenating Posted by Khurram Chaudhary at 7/10/2004 1:05:56 PM Hi,
I have an SP that returns results as follows:
UserName AccessAllowed
Khurram Read
Khurram Write
Tim Write
James Write
Tim Delete
How can I get the resul...more >>
Need to Covert a unix clock into a readable format during my query Posted by MUR T at 7/10/2004 12:19:02 PM
Hello All -
I have a column that is in a unix clock format .
E.g. - column is called data_time_created.
I need to query this column and others - in the table - and want
my output to be in a readable format ( convert the column during the
query .)
example query
1085501841 1.2.124....more >>
Is There any Resource for SQL Managment Posted by Hoa at 7/10/2004 12:08:13 PM Hi *.*
I've two questions:
1) I've heard that storing database on different logical drive will increase
the performance of SQL Server. Is it true?
2)Is it a good habit to use different owners for creating tables and views
to classified database objects or using "dbo " is recommended?
At...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Collate Query Posted by Panks at 7/10/2004 11:40:16 AM Can anyone please explain in simple words what do you mean by
COLLATE SQL_Latin1_General_CP1_CI_AS NULL
What does COLLATE do. What is its benefits.
If possible give an example
Thanks Pradeep
...more >>
bcp utility Posted by JIM.H. at 7/10/2004 10:33:20 AM Hello,
I am panning to use bcp to import csv file into SQL table.
I have following questions:
1. can I specify append or overwrite?
2. I have an identity filed in the SQL table and this is
not available in the file, I need to update all the
columns other than identity, can I get bcp do that...more >>
Don't load the same .XLS again Posted by Alex at 7/10/2004 10:03:02 AM Hi;
I am using an Excel file to load data into the database. There is a new Excel file every other day... Would it be possible to append a row to the top of the xls file upon the completion of my stored procedure and check for that same row at the beginning to prevent the same file from being loa...more >>
Date Display Posted by C. David Rossen at 7/10/2004 8:49:53 AM Hello:
I am new to sqlserver and I took over managing this website that has class
schedules. I found a stored procedure in the database that gets dates for
the classes. The problem is that if a class spans two different months, it
does not name the second month. For example, if a class goes fr...more >>
Passing Table Variables Posted by Mark Pauker at 7/10/2004 8:44:22 AM Is there a way to pass a table variable to a stored procedure other than
using dynamic SQL? If so, is it better to do this or to pass a local
temporary table?
Thanks,
Mark
...more >>
bcp not working Posted by JIM.H. at 7/10/2004 8:17:58 AM Hello,
This does not work
bcp MyTest..myPatient in
d:\tmp\myPerson.csv /SmyServer /UMyTestUser /PMyTestUser /c
/t,
Line 1: Incorrect syntax near '.'.
What is problem?
Jim.
...more >>
Cursor error? Posted by Ben at 7/10/2004 8:14:02 AM I have a procedure that I am calling from an ASP that selects values from one table, and inserts into another table. This procedure contains an outer loop, iterating through year values from the current year (passed parameter) to the current year + 6. Within this loop, I am declaring, and looping ...more >>
Stored procedure error Posted by JIM.H. at 7/10/2004 7:25:25 AM Hello,
I have this stored procedure created:
CREATE PROCEDURE dbo.GetMyPerson AS
BEGIN
DECLARE @bcpCommand VARCHAR(8000)
SET @bcpCommand = 'bcp "SELECT FName,MName, LName,
Age FROM MyTest..myPerson" queryout'
SET @bcpCommand = @bcpCommand + '
C:\Tmp\myPerson.csv -c -t"," -Slp-sriniva...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |