|
Dudes,
I have a new project using SQL database. Here`s my scenario.
I have two database.
Database Name: PCON_A
Database Used: 2006/01 to 2006/12
Database Name: PCON_B
Database Used: 2007/01 to 2007/08
I want to copy the database PCON_A to PCON_B using sql script.
How to do that?
Thanks in advance,
Jeof;)
******************************
I just want to
know everything
|
|
|
|
|
|
link doesn`t work.
******************************
I just want to
know everything
|
|
|
|
|
Oops. Copy-and-paste error.
This link should work.
Paul
|
|
|
|
|
got it. this is very helpful.
thanks so much.
******************************
I just want to
know everything
|
|
|
|
|
<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />
or even
<br />
<br />
truncate table PCON_A.dbo.TABLE1<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />
|
|
|
|
|
Can i implement the same concept that google use when u press search and gives u did u mean...
For example if i put Camille and press search it gives me the following possiblilities:
1- Camile
2- Kamil
3- Kameel
I was thinking of comapring first 4 characters and last 4 characters if we have 2 or 3 charcters common it displays it.
|
|
|
|
|
You could consider storing a dictionary of words in your database and using the SOUNDEX function to test for phonetic similarity.
Information on SOUNDEX can be found here.
Paul
|
|
|
|
|
How to insert two tables in one gridview?and how to connect it and to navigate...tnx;)
sunshine
|
|
|
|
|
You could use a stored procedure with a temp table and use that
<br />
<br />
create proc myproc <br />
<br />
AS<br />
<br />
SELECT * INTO #TEMP<br />
FROM Table1<br />
<br />
<br />
SELECT * INTO #TEMP<br />
From * Table2 <br />
<br />
select * from #temp<br />
<br />
go<br />
<br />
or use a Union SELECT
<br />
<br />
SELECT * FROM TABLE1<br />
UNION ALL<br />
SELECT * FROM TABLE2<br />
<br />
You get the idea, use SQL to do it.
|
|
|
|
|
Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb")
con.Open()
Dim da As New OleDbDataAdapter(sql, con)
sql = "Select * from Supplier_Information union all Select * from Products"
da.Fill(ds, "Supplier_Information and Products")
dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView
is this right?how will i assigned in my textboxes the table name?
txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0)
tnx
|
|
|
|
|
I have a table that was created a few years ago (LIVE), but I need to change ANSI_NULLS from OFF to ON for this table. How can I do that without re-creating the table?
Thanks in advance!
|
|
|
|
|
Whats your database SQL Server ????????
You may have to change the value of any nulls in the table first
|
|
|
|
|
i want to know when i log into the sql server db whether i have connected successfully, using sql login via my appilication. is there any parametre the server passes back to the applicatioin.
|
|
|
|
|
According to connection object provide the property named state which denote the connection is establish or not.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
hi all im using sql server reporting services, to do a report, but i want to disable or hide the print button of the report.... please somebody help me or tell me if is possible do that....
thanks
luis
|
|
|
|
|
Are you using the ReportViewer control to display the report? If so, set the value of its ShowPrintButton property to false.
Paul
|
|
|
|
|
|
You can modify the URL to hide all the toolbars.
|
|
|
|
|
|
hello friends i am third year engineering student i have created a database system using vb.net and mysql which is working fine on a standalone system but now i want this system to be on multiple machines and connected through lan network with one pc working as the server
.
I am non-geek in networking so please can any one help me on this regard.please
gautam karan singh
student
|
|
|
|
|
It depends on the database.
Access : needs a direct url path eg. \\server\share\db.mdb
ODBC: Need a SQL server connection string and a network compliant application
You question is a bit fluffy to answer.
|
|
|
|
|
Hi ..
thanks for all here ..
on my example .. I want to save the image of a PictureBox to the Sql server 2000 database ...
I know how cant save it from a file ...
but I want to know how save the PictureBoc's image ...
again .. any one will try
jooooo
|
|
|
|
|
Convert the Picture property to a byte array and save that.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks my friend >>
can you give me alink or the code of it ??
jooooo
|
|
|
|