|
Is there anyway that we can extract or backup data from a sql server table to anything, and later importing them?
Is there any popular tool or technique to do so?
|
|
|
|
|
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
|
|
|
|
|
I have to do that programatically and i am using Vb.Net or may be C# will do.
|
|
|
|
|
You can create your own SSIS package and then run it with your .NET application
|
|
|
|
|
Hello ,
You can use SMO ( SQL Server Management Objects ) to do that but it might be complicated for a beginner ( in SMO )
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways
|
|
|
|
|
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 )
|
|
|
|
|
I have deleted some of the records from my SQL server Database table
How can I recover those records?
|
|
|
|
|
By restoring from a backup? You could restore the backup to a new database and copy the rows over.
Scott
|
|
|
|
|
how i can create pyramid in sql server 2005.
|
|
|
|
|
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.
|
|
|
|
|
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 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.
|
|
|
|
|
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 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.
|
|
|
|
|
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 .
|
|
|
|
|
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
1
222
33333
4444444
I are troll
|
|
|
|
|
i think u should try it ,
its possible in sqlserver .
so dont laugh ,but try it.
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
That is similar to calculating Mandelbrot sets in SQL, only somewhat faster.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
modified on Saturday, March 28, 2009 1:46 PM
|
|
|
|