|
|
|
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 How can I use \ character on the end of the string in STRCAT Posted by shnel at 12/9/2006 11:47:10 PM Hi,
I am trying to do STRCAT of a string that ends with \.
For some reason I set an error message (unclosed string).
Any ideas?
...more >>
IF EXISTS with a view Posted by Ant at 12/9/2006 7:54:00 PM Hi,
I'm using an IF EXISTS statement to determine if a view exists before
creating it.
If I use this when creating a table, I have no problems but I get an error
when using it to check for an existing View.
"Incorrect syntax near the keyword 'VIEW'"
Why is this so & how can I do this...more >>
how to tell SQL not to create NULL records Posted by childofthe1980s at 12/9/2006 2:19:00 PM Hello:
I have figured out why a SQL query that I created is bringing in "NULL" for
some records returned and why this same query run in Crystal Reports is not
bringing in any NULLs for records returned. Crystal is bringing in records
100% and this is correct.
There are five tables in th...more >>
removing commas from SQL fields Posted by childofthe1980s at 12/9/2006 1:15:00 PM Hello:
Disregard the posting the I just created. I really need help with this
question. Please respond.
I need to tell SQL to take out commas from a field. Also, I am trying to
get rid of space.
Why am I getting syntax errors with this:
rtrim(replace(SOP30200.CUSTNAME,",",""))...more >>
dumping data to Microsoft Excel Posted by childofthe1980s at 12/9/2006 11:48:00 AM Hello:
I have a query in SQL Server 2005, and I have placed commas within the query
so that it will ultimately become a comma-delimited file.
You see, I'm dumping the data to an .rpt file. This file is then opened by
Microsoft Excel, as a comm-delimited file.
I need help on three ite...more >>
simple xquery question Posted by M1iS at 12/9/2006 11:06:01 AM This seems trivial but I am having a problem retrieving a value with xquery.
I have an xml column with data that takes the form of the following:
<MyDataSet xmlns="http://tempuri.org/MyDataSet.xsd">
<Details>
<id>1</id>
<reportDate>2006-11-22T00:00:00-08:00</reportDate>
<scor...more >>
GetDate() sync'd across all nodes of a solution Posted by mike at 12/9/2006 9:22:45 AM I would like to create a solution that will use up to 100 SQL Express
Editions machines, a workgroup machine and a Std/Ent Server. What is
the best solution to ensure that the GetDate() function returns the
same time (down to ms) on all machines?
Thanks,
Mike
...more >>
Enabling Updates on system tables Posted by Jami at 12/9/2006 8:19:29 AM
Hi
how can i enable updates on systems table.
thanx
Jami
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How can I use openxml inside a T-SQL function for SQL 2000? Posted by sam at 12/9/2006 7:26:07 AM Basically what I am really trying to achieve is to be able to call a
web
service from a t-sql function in SQL 2000 (not from a SP)
Does anyone know how it is possible to call the sp_xml_preparedocument
and openxml command from a t-sql function?
The issue is openxml works in a t-sql function...more >>
How to select in different field R1, R2, ...RN Posted by Johan2000 at 12/9/2006 7:18:00 AM Please HELP... (because I can't find example like this...)
Here is the table of student's registration :
studentID R1 R2 R3 R4 R5
0010129 1 5 6 15 0
1022032 6 1 20 0 0
2003993 7 12 1 18 19
2000393 8 9 12 1 1
How to use select to get :
1. Show ALL Students register only N class
(ex. s...more >>
Select random record Posted by Marco Minerva at 12/9/2006 4:47:19 AM Hi all!
I use SQL Server 2005. What is the best method to select a random
record of a table?
Thanks in advance,
Marco Minerva, marco.minerva@tiscali.it
http://blogs.ugidotnet.org/marcom
...more >>
Database CTP Posted by Damien at 12/9/2006 4:06:00 AM Anyone checked out the Database CTP for Visual Studio Team Suite? It's got
Unit Testing, Load Testing (simulate multiple users), Data Compare and Schema
Compare. All the tools you ever wanted!
I'd be interested to hear of your experience.
wBob
...more >>
Query to get a comma separated list of item2 grouped by item1 Posted by Shocky at 12/9/2006 3:06:31 AM There is a table AuthorHeader
CREATE TABLE AuthorHeader
( AuthorID INT,
AuthorName VARCHAR(50),
BookTitle VARCHAR(100)
)
Sample Data in AuthorHeader
AuthorID AuthorName BookTitle
--------- ---------------- ------------
10001 A1 BT11
...more >>
Check whether an update/insert/delete is successful Posted by User at 12/9/2006 12:00:00 AM Hi,
For eg:
I have a stored proc here:
create procedure newuser
@userid int,
@password varchar(20)
as
insert into users values(@userid,@password)
How do I know whether the insert is successful?
Are there ways to capture return values?
Please advise.
Thanks
Posted Via ...more >>
how to generate INSERT script? Posted by Keith G Hicks at 12/9/2006 12:00:00 AM I occasionally use import/export to get data to and from some new lookup
tables that are currently being worked on (developed) but I was wondering if
it's possible to somehow turn table data into a series of INSERT statements.
For example if I have 3 rows in a table I want to generate this (witho...more >>
sql query Posted by latha at 12/9/2006 12:00:00 AM Alter table <tablename> Alter column <columnname> Drop Default
does not work.
what I have to do to drop the default created to the column?
I have created it without using constraint name.
Table is:
create table sample
(
Name Varchar(10),
City Varchar(10) Default 'Chennai'
)
Thanks a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |