|
You can store everything in a single column of a single table; but then you'd be better of with storing that blob in a file, and not in a database.
Every "field" should hold 1 piece of information, not more - regardless of how it is shown.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Your question isn't clear.
If you want to store a single 'item' without respect to the type of the item and you need to have no limit on the size then you would use a single column which has a blob (binary not character data.)
If you want to keep a hint as to what type of data is in that column then you could create another string\text column which stores the name of the type like 'url', 'txt', 'img', etc.
muraliDarenKassi wrote: is it possible?if so,how?
If the above is a correct re-statement of your question then the above is also the answer.
|
|
|
|
|
I want to show reports by fetching data from OLAP. How to do that in .Net? Thanks
|
|
|
|
|
choose a reporting tool[^],learn how to connect to the database, learn how to develop reports in the chosen tool and build your reports. Deploy your reports in your chosen tool.
.Net does not have a specific reporting tool.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Is there a better way (xml) that would prove to be better? Space is not an issue; however, length of time to display is, as always, a major factor.
I would save as a file and link to the file, but I fear that in the manner suggested they will not map the network drive to a consistent letter at all workstations.
What have you done or would you do?
|
|
|
|
|
PrissySC wrote: however, length of time to display is, as always, a major factor
..then fetch it once, and put it in the users' temp directory.
PrissySC wrote: I would save as a file and link to the file, but I fear that in the manner suggested they will not map the network drive to a consistent letter at all workstations.
As a user, I can see everything in that path? Could I delete everything? I can try of course, since you probably have a backup 
PrissySC wrote: What have you done or would you do?
I'd go for the database-solution, but I'd be putting the files in their own database on the server. That way it could have it's own backup-policy.
If the users are only "reading" files then a webserver might be preferable; IIS has nice caching options, and getting the files would be easy.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
If you're using MS SQL 2012, you might want to look at FileTables[^]. For 2008 / 2008 R2, FileStream[^] might help.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
PrissySC wrote: Is there a better way (xml) that would prove to be better? Space is not an
issue; however, length of time to display is, as always, a major factor.
That of course depends on how the user is accessing it.
PrissySC wrote: I would save as a file and link to the file, but I fear that in the manner
suggested they will not map the network drive to a consistent letter at all
workstations.
Again this depends on how the users access it.
PrissySC wrote: What have you done or would you do?
Depends on the system but at least one file based solution is to provide an application\web server which can return a file URL and where the server permissions allow only for read only access into the file system. The database then returns something that can be massaged into a file url.
There are other solutions and other factors such as how many files, what sort of access, how often does access occur, size of files, goals of project, etc.
|
|
|
|
|
hi,i want to create this funcyion but sql not allowed,
create FUNCTION returnrahgiri(@rahgiri text)
RETURNS text
as
BEGIN
return (Select response from work_with_us where (response=@rahgiri))
END
message error:
Msg 2716, Level 16, State 1, Procedure returnrahgiri, Line 1
Column, parameter, or variable #0: Cannot specify a column width on data type text.
|
|
|
|
|
You can replace text with Varchar(50)
or any specified size.
|
|
|
|
|
Assuming you're not using SQL 2000 or earlier, you shouldn't be using the text data-type[^]:
ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
I am using the following code to populate all cleaners and display the income from every cleaner. It works fine when there is a entry for the cleaner in the job_order table but if no entry then it will not display the cleaner.
I want to display ALL cleaners even if no entry in the job_order table but of course with ZERO income.
SELECT
cleaners.cleaner_id,
cleaners.cleaner_name,
cleaners.date_of_join,
SUM(invoices.invoice_net_amount) as total_income
FROM
cleaners
INNER JOIN job_orders ON job_orders.cleaner_id = cleaners.cleaner_id
INNER JOIN invoices ON invoices.job_order_id = job_orders.job_order_id
GROUP BY
cleaners.cleaner_id
ORDER BY cleaners.cleaner_name;
Jassim
XoomPage[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: I want to display ALL cleaners even if no entry in the job_order table
..then don't use an INNER join.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
but I want to get order details as well?!
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: but I want to get order details as well?!
You'd also want the cleaners that don't have an order detail?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
yes.. I want to display all
if cleaner has order then it will display the SUM but if not then I want to display ZERO, null, blank or whatever..
Technology News @ www.JassimRahma.com
|
|
|
|
|
|
|
Look into LEFT OUTER joins
|
|
|
|
|
Hie everyone I have the below code on my console to import data from an excel sheet to a mySql database but unfortunately I am having an error which reads:
NO CONNECTION TRYING TO RECONNECT....
ERROR 2005 (HY000): UNKNOWN MYSQL SERVER HOST '(ID,NAME):' (11001)
ERROR:
Can't connect to the server
My command is as follows:
LOAD DATA LOCAL INFILE `C:\\temp\\test.csv' INTO TABLE bd_george.test FIELDS TERMINATED BY `;' LINES TERMINATED BY `\r\n' (id,name);
Regards
George Tsiga
STUDENT
|
|
|
|
|
George Tsiga wrote: My command
The command isn't executed if you can't even connect. Check your connectionstring.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Thanks a lot its now working I was using a backtick on rapping \r\n. The correct command is as follows.
LOAD DATA LOCAL INFILE 'C:\\temp\\test.csv' INTO TABLE bd_george.test FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' (id,name);
Regards
George Tsiga
STUDENT
|
|
|
|
|
I am working on a legacy app with a SqlServer DB
I am about to create 18 brand new table to support new functionality I'm going to add
Just for clarity sake I was thinking to create this table in a new schema (a bit like grouping my C# class by namespace / folder in my mind)
But as I'm reading about schema I read that it has security associated with it.. 
I don't want to make thing more complicated..  (quite the opposite)
So.. what's your take on shema? is it here for grouping things together for
1. clarity / purpose
2. security
|
|
|
|
|
This is a flavour of the month thing, some do some don't. Security allows you to assign specific users to a schema, really useful if your users have query access to the database but if you use a schema just for you to identify the functionality grouping simply give all users the rights to the schema.
Another issue will be your DAL, it will need to support multiple schemas, this one bit me many years ago as I assumed dbo only.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The purpose of the schema is security, how you use it is up to you.
It's not an overly big deal to give the user associated with one schema rights on another schema.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
