Hi,
I am aggregating some in-coming XML SOAP envelopes and I need to persist them to the database.
Is there a recommended data type to handle this? Should I be using ntext, text or other data type?
I know in Sql Server 2005 there will be a specific Xml Data Type; but, that is not an option until Nov 7, 2005.
HI,
Kindly Guide me how to store picture files in SQL server 2000 using Visual studio 2005
HI there,I currently store the date using the getdate() functionbut how can I store just the time or seperate the time off from adatetime datatype?M3ckon*** Sent via Devdex http://www.devdex.com ***Don't just participate in USENET...get rewarded for it!
View 4 Replies View RelatedHello,
Please help me find solution to these questions?
1. How do I store audio and video files in sql server 2000.
2. Is it possible to store and retrieve audio and video files using t-sql
3. Which is the most efficient way to store and retrieve audio and video files in sql server
Your suggestions are most valued.
Thanks!
HI
i want to save data larger than 8000 charactors in a colomn
is there any way to do it in mssql server 2000 desktop addition
plz help me
Thanks in advance
Hello,
I am using Jrun 3.1 + MS SQL Server 2000 + JSPs + Java on W 2000. I am having a lot of trouble storing Unicode characters in MS SQL Server since my 1.2 JDBC driver seems to assume that my characters belong to the Windows basic-Latin character set. Does anyone know how to solve this problem?
Many thanks.
Philippe
hi,
i would like to store just the time part in sqlserver 2000. time part with default date which is 1899 - 12- 30 in my sql server. but i read some articles which mentioned default date as 1900 - 01 - 01. i am not sure which one but if i enter just the time part in my sql server and do the query i get 1899 -12-30 and (time part). anyway, i am just wondering whether it is possible to set the trigger or constraints to strip off the date part of entered value and replacing it with default is ok.
the reason is i need to some queries on time part only which is giving some problem now.
Scenario:
We want to stage all data coming into our database from various
applications. We have a generic control where all data goes
through to get to the database.
We want have the data staged in a 'staging database'. My question
is, what would be the best way to store the staging database in the
database.
I'm thinking storing it as XML in a SQL column. The reason for
this is because the data could change from application to
application. It would be impossible to create a relational table
because maintenance would be a nightmare.
Has anyone ever done something like this. Would you save the node names in another table in SQL?
Any help would be appreciated as I'm new to XML.
Thanks,
ScAndal
Hi folks,Is it possible to store Binary Files in MS SQL 2000 ??? Say I have a100K PDF or a 150K word document. Is it possible to store this in afield in MS SQL and pull it out somehow? We're using ColdFusion on theserver on Apache.Thanks,Ringo
View 3 Replies View RelatedHello there,I just want to ask if storing data in dbase is much better than storing it in the file system? Because for one, i am currenlty developing my thesis which uploads a blob.doc file to a web server (currently i'm using the localhost of ASP.NET) then retrieves it from the local hostAlso i want to know if im right at this, the localhost of ASP.NET is the same as the one of a natural web server on the net? Because i'm just thinking of uploading and downloading the files from a web server. Although our thesis defense didn't require us to really upload it on the net, we were advised to use a localhost on our PC's. I'll be just using my local server Is it ok to just use a web server for storing files than a database?
View 6 Replies View RelatedMy forms are taking user input, then HtmlEncoding them prior to being stored in the SQL DB. For some reason, SQL is storing quotes as � and it is causing the HTML when decoded in the page to not be rendered properly.
Has anyone come across this issue before?
For example (without encoding for readability):
SQL should store the parsed string as: <a href="someurl" class="main">
but for some reason it's being stored as: <a href=�someurl� class=�main�>.
Thoughts?
Hello Everyonen and thanks for your help in advance. I am developing a conetnet management system to allow for the storage of articles within a SQL Server 2000 database. I am using FreeTextBox as the editor for users to enter articles. I ahve two questions. First, many of the articles are quite lengthy and including HTML formatting go well beyond 8000 characters. How should I go about storing these articles? Should I use a TEXT datatype, or perhaps split the data into more than one row. This leads to my second quuestion. Many sites that display article type data break the artilce into multiple pages with page numbers or next links to page back and forth. I am not sure hot to go about implmeneting this. Any help on this topic would be greatly appreciated. Thanks.
View 3 Replies View RelatedI have some C# code that iterates through the session state, serializes each object and stores the binary representation in an SQL table with an 'image' column. The problem is: it doesn't work. SQL server doesn't throw an error (at least ADO.NET doesnt propagate it); the table is just left unchanged. The SP works (I tested it with a few simple values); the MemoryStream and byte array are being populated correctly and bound to the parameter correctly.
What am I doing wrong? Anyone have a better approach? I know there is a builtin way of storing state in an SQL server, but I only need to do this once--namely, when a user is redirected from non-secure to secure pages--so I don't want to take that performance hit,
string uid = _session.SessionID;
object toSerialize;
BinaryFormatter formatter = new BinaryFormatter();
MemoryStream stream;
SqlConnection dbConn = SupportClasses.SqlUtilities.DBConn();
SqlCommand cmd;
SqlTransaction storeSession = null;
SqlParameter uidParam, keyParam, objParam;
try
{
dbConn.Open();
storeSession = dbConn.BeginTransaction();
foreach (string key in _session.Keys)
{
toSerialize = _session[ key ];
stream = new MemoryStream();
formatter.Serialize(stream, toSerialize);
cmd = new SqlCommand("store_session_object", dbConn, storeSession);
cmd.CommandType = CommandType.StoredProcedure;
uidParam = new SqlParameter("@uid", SqlDbType.VarChar);
uidParam.Value = uid;
cmd.Parameters.Add(uidParam);
keyParam = new SqlParameter("@object_key", SqlDbType.VarChar);
keyParam.Value = key;
cmd.Parameters.Add(keyParam);
objParam = new SqlParameter("@data", SqlDbType.Image);
objParam.Value = stream.ToArray();
cmd.Parameters.Add(objParam);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
SupportClasses.ErrorHandler.HandleSQLError(ex);
storeSession.Rollback();
}
catch (System.Runtime.Serialization.SerializationException exs)
{
// do something
}
finally
{
dbConn.Close();
}
For those interested, here is the code for the SP:
CREATE PROCEDURE store_session_object
@uid varchar(50),
@object_key varchar(25),
@data image
AS
INSERT INTO session_hold (uid, object_key, object)
VALUES (@uid, @object_key, @data)
[Cross-posted because issue spans several topics.]
I want to store a multipul paragraphs of information into one field in sql server. It works fine but when I output to html the writing does not have the paragraphs and all the text goes together like one big paragraph.
Hello,
We are just setting up SQL Server 2000 and wanted to keep track of all our server settings(everything needed for worst case scenario). Does anybody have a standard template that we could follow to record all our info?
Thanks!
I wanted to store image files in my Db.So can i use image data type?If i can use the image data type how big images can i store.My image are arounf 10 mb in size.
Thanks.
I understand that packages can be stored in the MSDB database. However, is it possible to store packages in another database and have them managed by the SSIS service?
View 7 Replies View RelatedHi All,I am looking to store a DataSet into a Table in SQL Server 2005, or any object for that matter. I cannot find any code to perform. Can anyone help?Many Thanks,Peppa.
View 2 Replies View RelatedSo what's the secret to getting images in and out of a SQL database? There's lots out there about this, but I cant seem to get any of it to work...
I have a table, named Attachments and among other columns I have one called Attachment. I've tried using both image and varbinary(max) data types, both with the same results.
I have an sproc with the following code:
INSERT INTO Attachments (Attachment) SELECT * FROM OPENROWSET(BULK 'c: est.bmp', SINGLE_BLOB) AS BulkColumn
That seems to read the file and create a record. If I move the file, yeah it complains it doesnt exist... If I "show data" on the table, there is a new record and under Attachment, it says "<Binary Data>. t seems to be there, but who knows for sure...
So in an aspx file, I have the following:
myConnection.Open();string SQL = "SELECT Attachment FROM Attachments";SqlCommand myCommand = new SqlCommand(SQL, myConnection);byte[] bytePic = (byte[])myCommand.ExecuteScalar();
When I run it, it errors out on that last line with "Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.
With the use of "DBNull", it sure does seem the SQL is coming up emtpy handed, eh? If I change the SELECT to AttachmentId (an identity field), it says it cant cast a "system32" - which makes sense... Any ideas whats going on? Many thanks!! -- Curt
hi friends, i want to store an image in DB. but most of my friends told that, to store an image in web server then store tat location in a DB and access it anywhere. this is for asp.net in C#-code behind. how to do this? i've a table with a text field. then .......? waiting for ur reply............ note: i need coding. not by using controls. pls...
View 1 Replies View RelatedHi Everyone,
I have an e-commerce site that uses Profiles in ASP.NET 2.0 to store items in a shopping cart. The problem is that we are now using LDAP authentication, so we are getting rid of the ASPNETDB membership database that stores the profile values. How can get the shopping cart functionalty to work with SQL Server 2005? How can I store the profile object in a SQL Server instead of the ASP.NET memberships database?
Here is the profile field:
<profile enabled="true"> <properties> <add name="Cart" serializeAs="Binary" type="Commerce.ShoppingCart" allowAnonymous="true"/> </properties> </profile>
Thank you in Advance
-Sam
Can you guys give me any specific classes I should read about to implement the above? Any specific methods?
Any webpage I should read?
Thanks for your direction/help!
I have records with 50 plus fields of data.I was thinking of writing all the fields data into a XML file and then store it in a SQL server database for retrieval later on.Is there anyway i can go about doing this?
View 6 Replies View RelatedHi,
Thanks in advance.
I need help(Tutorials or online links) regarding storing and retrieval of files in Sql server (BLOB) using ASP.net and C#.
Secondly,Is it possible to search file in BLOB using SQL server Full text search service.
Hello, I am using .net 1.1 and sql server 2000.
I want to store a byte array, but it seems that only a string is stored there.
Code:
SHA512 sha = new SHA512Managed();
byte[] ReturnedPasswordByte = sha.ComputeHash(ToCryptByte);
MyGenericCommand.Parameters.Add("@Password", ReturnedPasswordByte);
MyConnection.Open();
MyGenericCommand.ExecuteNonQuery();
MyConnection.Close();
If I select the record later, all I get is "System.Byte[]" (as string)
Is it possible to store multiple languages in one sql server.Now i have a sqlserver with US English.Can i store spanish and french data in the DB?If possible how can i store it...?
Thanks.
I'm constructing an image gallery for my site and was wondering how to store the pictures in the database? Would the best way to do it, by storing the link instead of the image in the database?
How would I use the insert and select with it? :confused:
Hi Guys
i have a list of 10 word docs and i want to store them in sql server.
How can i do that??
Should i create any fmt files for that???
Thanks
Vic
Is there any way of storing an image file into a specific Table .It would be of great help for me if i come to know something about it.
View 2 Replies View RelatedHi There
I have not had much luck finding info in BOL.
I have a directory with many images, i need to load these images into sql server.We want to staore them in the database instead of the file server.
What is the best way to do this? TSQL (i am hoping), .NET code or maybe even SSIS ?
I have been reading what i can find in BOL basically all i know so far is that image data type will be no more in the future and i should use a varbinary(max) data type.
Basically i need a good link or something that can demonstrate how one can go about loading images into Sql Server 2005.
Thanx
Does anyone know whats wrong with my code?
~Nothing wrong with my code, code is correct!
I let it run and it keeps saying that the file does not exist. Seem as though, the path of my file doesn't exist! Any suggestions on how to program the path of my file so I can be able to retreive it such as open the file and access the file?
CODE:
Imports System
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports System.Web
Imports System.Configuration
Imports System.Reflection
Imports System.Security.Permissions.FileIOPermission
Imports System.IO
Imports System.Collections
Imports System.Collections.Generic
Imports System.Windows.Forms
Imports System.Security.Permissions
Imports System.Windows.Forms.Form
'<Assembly: PermissionSetAttribute(SecurityAction.RequestMinimum, Name:="Local Intranet")>
'<Assembly: PermissionSetAttribute(SecurityAction.RequestOptional, Unrestricted:=True)>
Public Class Form1
Inherits Form
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SQL As String
Dim rawData() As Byte
Dim RowsAffected As Integer
Dim filename As String
filename = "H:My Documentsabc.pdf"
Try
If System.IO.File.Exists(filename) Then
Dim filePermission As New System.Security.Permissions.FileIOPermission(System.Security.Permissions.FileIOPermissionAccess.Read, System.Security.AccessControl.AccessControlActions.View, filename)
filePermission.Demand()
Else
MessageBox.Show("file does not exist", "File", MessageBoxButtons.OK, MessageBoxIcon.Information)
End If
Dim fs As FileStream
fs = New FileStream(filename, FileMode.Open, FileAccess.Read)
Dim FileSize = Convert.ToInt32(fs.Length)
rawData = New Byte(FileSize) {}
fs.Read(rawData, 0, FileSize)
SQL = String.Format("INSERT INTO test_file_save(FILE_ID, FILE_NAME, FILE_SIZE, CREATE_FILE) VALUES({0}, {1}, {2}, {3})", _
1, filename, FileSize, rawData)
Using Conn As New SqlConnection("server=1234;" _
& "uid=F_User;" _
& "pwd=password;" _
& "database=Database")
Using Cmd As New SqlCommand("sp_InsertPDF", Conn)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add(New SqlParameter("@FILE_ID", 1))
Cmd.Parameters.Add(New SqlParameter("@FILE_NAME", filename))
Cmd.Parameters.Add(New SqlParameter("@FILE_SIZE", FileSize))
Cmd.Parameters.Add(New SqlParameter("@CREATE_FILE", rawData))
fs.Close()
Conn.Open()
RowsAffected = Cmd.ExecuteNonQuery()
End Using
End Using
MessageBox.Show("File Inserted into database successfully!", _
"Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk)
Catch ex As Exception
MessageBox.Show("There was an error: " & ex.Message, "Error", _
MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub
End Class
Hi
is it possible to store a SQL CE command object in SQL Server CE database.
If so then what would be the datatype of such column????
thanx in advance
Which is better, to store the files onto the server's folders or to a database?
I tried storing to MSSQL 2000 but the varbinary does not allow me to set "MAX" for the data type.