Click here to Skip to main content
15,915,019 members
Home / Discussions / Database
   

Database

 
GeneralRe: Challenging DB Quest. (Tree-Node) Pin
Dinuj Nath25-May-06 19:07
Dinuj Nath25-May-06 19:07 
QuestionRestoring a BAK file (created suing SQL Server 2000) in SQL Server 2005 Pin
spirit_kleptus24-May-06 7:27
spirit_kleptus24-May-06 7:27 
QuestionConnectionString Changes during Runtime? Pin
DEWright_CA24-May-06 5:38
DEWright_CA24-May-06 5:38 
Questionreturning a user group in MS Access Pin
achrafus24-May-06 4:07
achrafus24-May-06 4:07 
QuestionInserting lots of rows programmatically Pin
AnneThorne24-May-06 2:59
AnneThorne24-May-06 2:59 
AnswerRe: Inserting lots of rows programmatically Pin
john.nada24-May-06 5:33
john.nada24-May-06 5:33 
GeneralRe: Inserting lots of rows programmatically Pin
AnneThorne24-May-06 8:59
AnneThorne24-May-06 8:59 
GeneralRe: Inserting lots of rows programmatically Pin
Eric Dahlvang24-May-06 11:59
Eric Dahlvang24-May-06 11:59 
Using REPLICATE() is a little shorter:

DECLARE @PostalCode varchar(10)
DECLARE @Number int
DECLARE @cTemp varchar(10)
SET @Number = 0

WHILE @Number < 100000
BEGIN
   /* Format PostalCode */
   SET @cTemp = CAST(@Number as VARCHAR(10)) 
   SET @PostalCode = REPLICATE('0',5-LEN(@cTemp)) + @cTemp

   /* Insert PostalCode */
   INSERT INTO Wzip_Detail(PostalCode)
   VALUES(@PostalCode)

   /* Increment number */
   SET @Number = @Number + 1
END


----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

GeneralRe: Inserting lots of rows programmatically Pin
john.nada24-May-06 12:07
john.nada24-May-06 12:07 
QuestionODP.NET vs System.Data.OracleClient Pin
CooperWu24-May-06 0:11
CooperWu24-May-06 0:11 
AnswerRe: ODP.NET vs System.Data.OracleClient Pin
CooperWu24-May-06 0:36
CooperWu24-May-06 0:36 
AnswerRe: Query With Collection Values Pin
CooperWu24-May-06 0:19
CooperWu24-May-06 0:19 
QuestionParameterized query Pin
dayakar_dn23-May-06 23:50
dayakar_dn23-May-06 23:50 
AnswerRe: Parameterized query Pin
CooperWu24-May-06 0:24
CooperWu24-May-06 0:24 
AnswerRe: Parameterized query [modified] Pin
Luis Alonso Ramos24-May-06 19:49
Luis Alonso Ramos24-May-06 19:49 
Questioncreate forenkey syntex Pin
vipinpaliwal198023-May-06 22:19
vipinpaliwal198023-May-06 22:19 
AnswerRe: create forenkey syntex Pin
maryamf24-May-06 12:03
maryamf24-May-06 12:03 
AnswerRe: create forenkey syntex Pin
Colin Angus Mackay25-May-06 9:41
Colin Angus Mackay25-May-06 9:41 
GeneralRe: create forenkey syntex Pin
vipinpaliwal198025-May-06 17:54
vipinpaliwal198025-May-06 17:54 
QuestionDbf Tables & Sql Strings Pin
Vinicius Pontes23-May-06 10:11
Vinicius Pontes23-May-06 10:11 
AnswerRe: Dbf Tables & Sql Strings Pin
Eric Dahlvang24-May-06 3:06
Eric Dahlvang24-May-06 3:06 
Question-- Is it possible??? -- Pin
WetRivrRat23-May-06 9:56
WetRivrRat23-May-06 9:56 
AnswerRe: -- Is it possible??? -- Pin
Eric Dahlvang24-May-06 3:36
Eric Dahlvang24-May-06 3:36 
GeneralRe: -- Is it possible??? -- Pin
WetRivrRat24-May-06 4:01
WetRivrRat24-May-06 4:01 
AnswerRe: -- Is it possible??? -- Pin
Eric Dahlvang24-May-06 8:35
Eric Dahlvang24-May-06 8:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.