|
To insert two table with the same fields into one table using stored procedure.
table A with field E and R
table B also have the same fields with table A
result:
table C with the records from table A and B. Thanks
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
Never mind I figured it out already by using Insert into, But now I'm having String or binary data would be truncated. error .
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
string or binary data would be truncated means that the length of the string you are trying to insert is > then the length of the column.
For example,
Maybe the column length is 10 and you are trying to insert a 12 char string.
"People who never make mistakes, never do anything."
|
|
|
|
|
|
create or replace view YOUR_VIEW as
select SOME_COLUMN_LIST
from SOME_TABLE_LIST
where CONDITIONS
;
Chris Meech
I am Canadian. [heard in a local bar]
Gently arching his fishing rod back he moves the tip forward in a gentle arch releasing the line.... kersplunk [Doug Goulden]
Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]
|
|
|
|
|
create viewname (Syntex of the SQL)
eg create viewname (Select * from emp)
|
|
|
|
|
how to save pic in your database
|
|
|
|
|
Here ya go. FYI, it's more efficient to save a pic in a file directory rather then a database.
Dim bufferLen As Integer
Dim fs As System.IO.FileStream
Dim br As System.IO.BinaryReader
Dim buffer() As Byte
bufferLen = 10000000
fs = New System.IO.FileStream(fileName, FileMode.Open, FileAccess.Read)
br = New System.IO.BinaryReader(fs)
buffer = br.ReadBytes(bufferLen)
br.Close()
fs.Close()
Dim sConn As New String(strConnection)
Dim Con As New SqlConnection(sConn)
Dim sqlcmd As SqlCommand
sqlcmd = New SqlCommand("INSERT INTO Picture (Picture) VALUES (@Picture)", Con)
Dim dataParm1 As SqlParameter
dataParm1 = sqlcmd.Parameters.Add("@Picture", System.Data.SqlDbType.Image, buffer.Length)
dataParm1.Value = buffer
Con.Open
sqlcmd.ExecuteNonQuery()
Con.Close()
"People who never make mistakes, never do anything."
|
|
|
|
|
Hi,
I am binding the database column with dropdownlist box.It is working fine.
But i have to set particular value as my first value in the dropdownlist box.
for example, the coulmn values are
Windows 2003
Unix
Solaris
Linux
Windows 2000
Windows XP.
I want to show Linux as my first value in the dropdownlist box, then other values.
Linuxt may be 5 th record or 24 th record or anywhere in the table.
I have used simple query now. "SELECT CategoryName From Category".
Can any one help me to write a query.
Thanks & Appriciate You.
|
|
|
|
|
Since you require a sort order and that sort order is not the lexical order of the text, you can add a column to the table called, .. Sort_Order. Load that column with unique numeric values and then your query becomes "Select CategoryName from Category order by Sort_Order".
Chris Meech
I am Canadian. [heard in a local bar]
Gently arching his fishing rod back he moves the tip forward in a gentle arch releasing the line.... kersplunk [Doug Goulden]
Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]
|
|
|
|
|
Hi,
Thanks for your reply,
My table has only two column one is automatic(identity) column and other is CategoryName.
i can't add any more column this is the problem, so how can i do this.
Thanks
|
|
|
|
|
Perhaps another way would be to not bind a datatable to the control, but to loop manually around the datatable adding the data items to the control. Put an IF clause in to look out for the item that you want and insert this into the first position of the control.
Shawn
|
|
|
|
|
I have a recordset and want to push this one into a database. Is there any way to do it without a recordset loop ?
|
|
|
|
|
You can look into the BCP command in SQL Server. If you are using VB I think you can do a rs.Save to save it to a text file. It has been a while since I used VB so can't remember if you can set the delimited for the file or not. If you are using .Net, not sure. I do know you can save it to an xml file using the dataset object. I haven't notice the capability to save to disc in any other format though, but it might be there.
Also, triggers don't fire when you use BCP.
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Why should i use databinding in my forms while coding with business objects is easier for me?
|
|
|
|
|
|
Please tell me!
How can i get first 5 records in SELECT query? (I'm using SQL server 2000)
Thanks
|
|
|
|
|
|
Hi,
Please suggest if there is any difference between using keywords JOIN and INNER JOIN? Is there any perfomance advantange in using one of them ?
Ashu Sharma
Web Analyst
|
|
|
|
|
JOIN == INNER JOIN. INNER JOIN is implied when using JOIN. No performance difference.
|
|
|
|
|
|
|
I thought similar but was just wondering about the performance. Thanks anyways!
Ashu
|
|
|
|
|
|
Hi...,
In VB or C#.net how i export sql database data in access database file as in Sql default feature.
Also i if someone know the script of export sql data in access file.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
