Database

Reza Raad28-Mar-09 21:53

Reza Raad

28-Mar-09 21:53

you can generate sql script for you table structure and also data which exist in your table.
if you have sql server 2008 follow this instructions:
Open Sql Server Management Studio
Right Click on your database
go to : Tasks
then: generate scripts...
wizard will shown then

try this wizard you can find it very simple

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

xbiplav29-Mar-09 6:59

xbiplav

29-Mar-09 6:59

I have to do that programatically and i am using Vb.Net or may be C# will do.

Reza Raad29-Mar-09 10:34

Reza Raad

29-Mar-09 10:34

You can create your own SSIS package and then run it with your .NET application

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Lambin6-Apr-09 18:59

Lambin

6-Apr-09 18:59

Hello ,

You can use SMO ( SQL Server Management Objects ) to do that but it might be complicated for a beginner ( in SMO )

azad yadav28-Mar-09 3:02

azad yadav

28-Mar-09 3:02

Dear Friends,
I attached sql 2000 database in sql 2005 server and deattaching from 2005 again try to attached with sql 2000 then give error (could not find sysindexes for database id 9 Run dbcc chack table on sysindexes)
Please help me

Thanks and Regards
Azad Yadav

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Mycroft Holmes28-Mar-09 16:00

Mycroft Holmes

28-Mar-09 16:00

I will be astonished if you can do this. The idea that you can take a 05 db back to 2000 seems unlikely in the extreme.

Never underestimate the power of human stupidity
RAH

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Reza Raad28-Mar-09 23:25

Reza Raad

28-Mar-09 23:25

use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Lambin6-Apr-09 18:56

Lambin

6-Apr-09 18:56

Hello,

If you have modified the structure of your database or introduced features specific to SQL Server 2005 like PIVOT in a view or stored procedure, bad luck.
Try to reattach your database to your SQL Server 2005 , check if the compatibility level of your database is always 80 ( SQL Server 2000 ). If yes, bad luck, if it is 90, try to modify it to 80.
Detach it properly and try to reattach it to your SQL Server 2000. You have a little hope of success ( except if you have introduced features specific to 2005 )

Recoverying deleted record from SQL server table

Saleem Tahiri28-Mar-09 0:34

Saleem Tahiri

28-Mar-09 0:34

I have deleted some of the records from my SQL server Database table

How can I recover those records?
Rose | [Rose]

Re: Recoverying deleted record from SQL server table

scottgp28-Mar-09 1:42

scottgp

28-Mar-09 1:42

By restoring from a backup? You could restore the backup to a new database and copy the rows over.
Scott

Sql server

anup keshari27-Mar-09 21:42

27-Mar-09 21:42

how i can create pyramid in sql server 2005.

Blue_Boy28-Mar-09 0:27

Blue_Boy

28-Mar-09 0:27

Which pyramid you want to create by SQL Server 2005?!

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

anup keshari28-Mar-09 0:35

28-Mar-09 0:35

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

Blue_Boy28-Mar-09 0:47

Blue_Boy

28-Mar-09 0:47

Here it is:

DECLARE  @i AS INT<br />
SET @i=0<br />
<br />
DECLARE  @j AS INT<br />
SET @j=1<br />
<br />
DECLARE @kosova AS VARCHAR(255)<br />
SET @kosova=''<br />
<br />
WHILE(@i<10)<br />
BEGIN<br />
	WHILE(@j<@i)<br />
	BEGIN<br />
		SET @kosova=@kosova+CAST(@i AS VARCHAR(10))<br />
		<br />
		SET @j=@j+1	<br />
	END<br />
	PRINT @kosova<br />
	set @kosova=''<br />
	SET @j=0<br />
	SET @i=@i+1<br />
END

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

anup keshari28-Mar-09 1:04

28-Mar-09 1:04

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

Blue_Boy28-Mar-09 1:08

Blue_Boy

28-Mar-09 1:08

And your question is?
I don't understand what you mean by this last pyramid!

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

anup keshari28-Mar-09 1:17

28-Mar-09 1:17

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

here the 1 printed after 8 spaces 1 times
here 2 printed after 7 spaces 2 times .
and so on .

Eddy Vluggen29-Mar-09 1:33

29-Mar-09 1:33

You're cheating! You can't get a decent pyramid by adding a number, you'll have to add two numbers to get a decent pyramid Laugh | :laugh:

I are troll Smile | :)

anup keshari29-Mar-09 23:55

29-Mar-09 23:55

i think u should try it ,
its possible in sqlserver .
so dont laugh ,but try it.

Eddy Vluggen30-Mar-09 2:36

30-Mar-09 2:36

I enjoy making and solving these kind of riddles, it's a fun way of learning Smile | :)

I'm still @work, but I'll give it a try to build my pyramid when I'm home Thumbs Up | :thumbsup:

I are troll Smile | :)

Eddy Vluggen30-Mar-09 6:15

30-Mar-09 6:15

Result

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

Here's my homework;

DECLARE @R AS INT
SET @R = 0
DECLARE @FILL AS INT
SET @FILL = 10
DECLARE @NUMCNT AS INT
SET @NUMCNT = 1

DECLARE @ROWSTR AS VARCHAR(100)
DECLARE @I AS INT

WHILE (@R < 10)
BEGIN
      SET @ROWSTR = ''

      SET @I = 0
      WHILE (@I < @FILL)
      BEGIN
            SET @ROWSTR = @ROWSTR + ' '
            SET @I = @I + 1
      END

      SET @I = 0
      WHILE (@I < @NUMCNT)
      BEGIN
            SET @ROWSTR = @ROWSTR + CAST(@R AS VARCHAR)
            SET @I = @I + 1            
      END

      SET @R = @R + 1
      SET @FILL = @FILL - 1
      SET @NUMCNT = @NUMCNT + 2

    PRINT @ROWSTR
END

I are troll Smile | :)

anup keshari30-Mar-09 6:34

30-Mar-09 6:34

ITS GOOD BUT THE RESULT IS NOT SO DESIREABLE .

BECAE WHEN I PASS 5 THEN ITS NOT GINGING THE PROPER RESULT

I NEED A DYNAMIC FUNCTION FOR ANY INPUT VALUE

EX .FOR 5
1 ,1 TIMES
2 2 ,2 TIMES
3 3 3 ,3 TIMES
4 4 4 4 ,4 TIMES
5 5 5 5 5 ,5 TIMES
I NEDD LIKE ABOVE

Eddy Vluggen30-Mar-09 8:05

30-Mar-09 8:05

Well, it's *your* homework obvious, not mine Poke tongue | ;-P

Besides, my pyramid differs from yours, so you'll have to write your own anyway.. See, this below was your desired pyramidresult:

        1
       2 2
      3 3 3
     4 4 4 4
    5 5 5 5 5
   6 6 6 6 6 6
  7 7 7 7 7 7 7
 8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

and this was mine:

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

Your pyramid should only grow by a single number (e.g. 22 -> 333), whilst mine adds two numbers to each row (e.g. 111 -> 222 + 22 = 22222)

Good luck Thumbs Up | :thumbsup:

I are troll Smile | :)