|
|
|
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 create custom id's Posted by Jason at 5/7/2006 9:06:46 PM Hi,
Can someone tell me how to create custom id's in sql server by using
user-defined functions.
I was thinking about creating a id with a length of 6. The first character
should by a alphanumeric.
Then i would like to have some sort of checkid function, if someone insert a
fictious i...more >>
Can I access SQL Server from client Linux? Posted by Bpk. Adi Wira Kusuma at 5/7/2006 6:57:12 PM Can I access SQL Server from client Linux?
And Any functions in Postgre are in SqlServer?
...more >>
Constraint: Table xGUID and Deleted Posted by Pete Smith at 5/7/2006 6:14:18 PM Hi,
I have a database table which contains a column with a GUID. In addition I
have column that contains a Deleted flag. I now would like to create a
contraint that makes sure that there is only one undeleted GUID.
What is the expression for this?
Thanks for any advice
Pete
--
Pet...more >>
SQL Aggregation Query Posted by Liddle Feesh at 5/7/2006 6:06:25 PM Dear Group,
I appreciate that you are all busy; however I have a SQL programming task
that I can't seem to get my head around at the moment. Any assistance will
be very warmly appreciated.
I have the following SQL view, which returns a Data Table, STOCK_TRADE, with
the following data..
...more >>
Aggregating groups of rows using SQL Posted by Liddle Feesh at 5/7/2006 5:58:36 PM Dear Group,
I have a SQL coding problem, which I hope that you can help me with!
I have the following SQL view, which returns a Data Table, STOCK_TRADE, with
the following data..
CUSTOMER STOCK_CODE QUANTITY PRICE DATE
J. BLOGGS MSFT 1000 535.50 10/05/2006
J. BLOGGS MSFT 2000 536....more >>
Best way to create SQL2005 DB from VB.Net Posted by David at 5/7/2006 5:52:01 PM I have written a VB.Net (2005) program to load an empty SQL Server 2005
database from another data source. At the moment I create the empty SQL
database by manually running a DDL script in SQL Server Management Studio.
However, I need to modify the VB.Net program so that the database is create...more >>
Field type for email address? Posted by Noozer at 5/7/2006 4:43:06 PM Technically, and email can be 128 or more characters long. In reality they
rarely are.
Is a VARCHAR field the best way to store an email address? 128 a good limit?
I know that it's not a lot of wasted bytes, but it is a large percentage of
each of my records.
...more >>
Problems with Dynamic Query from Newbie Posted by Stephen K. Miyasato at 5/7/2006 3:25:43 PM Thanks for the help thus far. I'm still having problems
Below are the error message.
I can run the print statement noted below and it works.
I can also just do the select statement but placing the insert into breaks
the procedure.
Questions.
1. What am I doing wrong.
2. I need to out...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
sql suggestions / giudance Posted by Jon Paal at 5/7/2006 2:17:49 PM I have a table which needs to have duplicates removed.
duplicates are defined as records with same field values except for one which is a date value.
The records with matching values and oldest date are to be removed.
any suggestions ?
...more >>
Can you fix this query: Getting PrimaryKey and ForeignKey Information Posted by Russell Mangel at 5/7/2006 12:48:03 PM /*
I am using SQL 2005.
I have a database that contains 97 tables.
I have created a new table (MyColumnInfo)
that will contain information about each column,
and this is working okay.
I would like to join the columns in MyColumnInfo table
back to the real columns and return primary key,
...more >>
Linked Server to dBASE Posted by scott at 5/7/2006 12:23:45 PM I'm trying to create a "Linked Server" in QA to a dBASE file. Below are some
examples I've tried. They seem to create the "Linked Server" in Ent.
Manager, but give errors when i run a SELECT .. OPENQUERY statement. They
also give errors with Ent. Manager when trying to expand the linked server...more >>
Help with Dynamic SQL Posted by Stephen K. Miyasato at 5/7/2006 8:49:23 AM I'm a newbie and need help with this Dynamic SQL
probably with the sp_ExecuteSQL parameters as well as the order by not
working.
error
Must pass parameter number 4 and subsequent parameters as '@name = value'.
After the form '@name = value' has been used, all subsequent parameters must
...more >>
,_ô_for_e.g.)_in_SQL_Server Posted by Rakesh at 5/7/2006 3:22:01 AM Need to Bulk Insert from a txt file:
***************************************
Problem Description - There are special characters present in the file. For
e.g., Montréal, Côte-de-Liesse… through Bulk Insert, they are getting saved
in SQL Server as Montr+¬al, C+¦te-de-Liesse…
--------...more >>
Replication problem (please help if you can) Posted by Kev at 5/7/2006 3:01:05 AM Since our outsourced database team made some changes to the database we
are getting the following from the Distribution Agent Error Details:
{call sp_MSget_repl_commands(5, ?, 0, 7500000)}
Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__7AB9340C'.
Cannot insert duplicate key in ...more >>
cast ( host_name() as int ) Posted by rmanchu NO[at]SPAM gmail.com at 5/7/2006 1:39:17 AM
hi. i'm new to sql server administration.
i need to migrate a table that has field (from memory)
uid INT DEFAULT CAST(HOST_NAME() AS INT)
the current table has field values that r integers
new table of same structure is blank
trying to export the data to new table i get error sayi...more >>
db file folder Posted by rmanchu NO[at]SPAM gmail.com at 5/7/2006 1:32:46 AM
hi. i'm new to sql server administration.
i've a instance whose default store folder is C:\SQLDB. i would like to
move the 3 databases that run on it to another harddrive. what's the
way to do this?
1) create backups of the 3 databases.
2) uninstall sqlserver
3) instal sqlserver with the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |