|
|
|
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 Encrypted Credit Card Info? Posted by Sender at 7/20/2003 9:31:46 PM How should I store the credit card details in the SQL Server Table in an
encrypted form?
...more >>
Parent-child insert/copy Posted by sqlvs NO[at]SPAM myway.com at 7/20/2003 7:18:16 PM Hello,
[I posted this to microsoft.public.sqlserver, but I think it's been
phased out? I couldn't locate the group on DevelopersDex.]
My basic question is, how can I insert/copy related parent/child rows
from one database or set of tables to another? [I've searched old
posts for the last co...more >>
Create Database Posted by Byron Hopp at 7/20/2003 5:21:06 PM Can you set the size of a database when creating using
the 'Create Database' command?
...more >>
SQL conversion help needed Posted by Scott R at 7/20/2003 3:49:19 PM Hello,
I've just been given a horribly designed Access system to upsize to SQL
Server. So far, it's been long, annoying exercises in sifting through
spaghetti, but now I've got a query that is doing my head in!
Can I have some suggestions as to what to do with this:
select iif (isNull(Sale....more >>
Problem creating function in MS SQL 2000?? Posted by Sameer Karmarkar at 7/20/2003 3:07:29 PM Hi,
I am trying to create the following function in MS SQL Server 2000 through
WinSQL (ODBC utility program):
CREATE FUNCTION GetString (@input_value varchar(255)) returns varchar(255)
as
begin
return SUBSTRING(@input_value, (CHARINDEX(';', @input_value)+1),
LEN(@input_value))
end
...more >>
Start a new transaction Posted by Mr. J. at 7/20/2003 12:40:49 PM Hello,
What is the sql-server command for starting a new transaction ?
Thanks :)
...more >>
Is This Even Possible? Posted by Ron at 7/20/2003 12:34:33 PM I have a database that stores items, categories, etc. in one table. Each
item can encompass multiple categories. I have chosen to design my table
such that the categories are all placed in one row, with the values
seperated by a semicolon. Currently I am just pulling the category values
out of t...more >>
Nested distributed transaction - rollback error (Msg 6401, Level 16) Posted by kioto NO[at]SPAM activenetwork.it at 7/20/2003 12:09:48 PM Hi,
I have 2 SQL Server 2000, ServerA and ServerB, as linked servers.
On ServerB I have a stored procedure (spB), that performs some actions
within a transaction. I run the commit or the rollback depending on a
parameter, @bInputParamB.
-- spB code --
BEGIN TRANSACTION trSpB
INSERT [....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Identities Posted by Mr. J. at 7/20/2003 11:22:57 AM Hello,
In SQL-Server :
1) How can I get the current identity number of a table after I insert a
record (if the primary key is identity) ?
2) What SQL-command is for changing the Identity current number (so, if I
insert another record, I'll start with another sequence number) ?
Thanks :)
...more >>
Debugger with triggers Posted by Matt at 7/20/2003 11:05:44 AM I am trying to debug some trigger code and want to be able to examine
the contents of inserted, deleted, temporary tables etc. There doesn't
seem to be a way to do this directly from the debugger so I hit on the
idea of using a local variable to control the selecting of these tables.
Code fol...more >>
SQL Newbie Primay-Foreign Key question Posted by Jonathan Simms at 7/20/2003 9:46:15 AM I have 2 tables
CREATE TABLE [dbo].[Accounts] (
[Acct_GUID] [uniqueidentifier] NOT NULL ,
[Login] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Pwd] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Acct_Owner_GUID] [uniqueidentifier] NULL ,
) ON
an...more >>
iteration newbie question Posted by mike lindner at 7/20/2003 8:20:08 AM hiyas,
i'm new to sql, as you'll soon realise
q: in a stored procedure how do you iterate?
....i'm selecting a bunch of records, and then one
by one i want to subject them to a second
stored procedure.
sure this is a silly q., but i've been thrown
in the deepend with no reference material a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |