|
|
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.
|
|
|
|
|
Could you explain your questions in a different way? Do you want to transfer data between an SQL database(SQL Server or MySQL) and an Access database?
|
|
|
|
|
So i want to transfer data between an SQL database(SQL Server 2000) to an Access database.
If you knew any thing about this problem please tell me.
|
|
|
|
|
Well, you can create DTS package in SQL Server to transfer data, and then run the package from your application. Do you get it?
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|