|
jkirkerx wrote: I needed that chart. I used a char for boolean Y/N, just going to change it to a
number with 0/1.
There's nothing wrong with using Y/N as such, it uses only one byte of storage just like the zero, while the one uses two bytes.
But 0/1 implicitly translates to boolean TRUE/FALSE in dot.net, while Y/N needs a bit of logic to convert to a boolean. Not that I recommend implicit conversions.
People say nothing is impossible, but I do nothing every day.
|
|
|
|
|
I think it's 11 gigs, thus the name 11g. I'm going to 0/1 on the boolean, just use to it.
I'll have to look up the backup feature, but it's 1 cpu 1 core, 1 gig, oh well it's free to use. I'm starting to like it, makes sense now.
[Day3]
I got the ODP client software working on the web server, the xcopy version. And the 11gXE working on the database server and tested the connection added SQL Explorer and EMS SQLServer, took about an hour to download, extract and run.
My asp.net code is working using the ODP client, so far so good.
I need to get my tables or my table file from my computer to the database server. In SQL Server 2008, I can just copy the files over and attach, is that possible on Oracle?
|
|
|
|
|
Hi,
On my report i have used the following to display 100 reports per page =Floor((RowNumber(Nothing) - 1) / 100).
The records are grouped by department.
However I'm getting the group header on everypage.
For example if I have 200 records for Department2 and 50 records for Department2,
on the first page Department1 is displayed followed by 100 records and on page 2 the Department1 is displayed again followed by 100 records. I want the Department1 to be displayed only once even if the next 100 records are on the next page
Any advice?
|
|
|
|
|
when i click on a link, i should get a list of values from the database into the html page.i am using asp for connectivity.
|
|
|
|
|
nuts15 wrote: when i click on a link, i should get a list of values from the database into the html page.i am using asp for connectivity.
Classic ASP? There are tutorials here[^]. You'd need to learn a server-side language, and how to talk to the database.
Meaning, you'll have to learn to program it; there's little chance someone else will post the code - in this case, someone might, as it is part of the basics. If you have a specific question or get stuck, I'll gladly help.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
i have crystal report delivery in which i want display product list and hv done it bt i want to display returns product list below current product sale and adjust the amount from current amount to previous product return amount. also i would like to mention that data come from two tables of same dataset. i have tried to do that by adding two tables column name at detail field it shows record current product list but not all list of previous product list. is there any other way to solve this problem? thnks in advance
|
|
|
|
|
You'll need a Sql-statement to fetch the data. Are you familiar with the "join"-keyword? If not, start there.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
thnks for ur suggestion. i hv Access database due to this have problem. yes i m familiar with join concept. bt i doesn't work for my requirement.
is there any solution?
|
|
|
|
|
Azher.Cybertech wrote: yes i m familiar with join concept. bt i doesn't work for my requirement
I'm sure the examples don't work as-is. You'll need to write some Sql to gather the required results
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
sql server 2008 table convert to xml files
|
|
|
|
|
shannya wrote: sql server 2008 table convert to xml files
Is that a statement or a question?
If it's a statement, tell us more.
If it's a question look herehere.
By the way, it would be more polite to tell us what do you want to know and ask a real question.
------------------------------
Author of Primary ROleplaying SysTem
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.
|
|
|
|
|
select*from <Table Name> for xml path ('Head')
select*from <Table Name> for xml path ('Head') ,root('Title')
select*from <Table Name> for xml raw
try like this there are more formats
modified 26-Oct-12 15:29pm.
|
|
|
|
|
Seems that you inserted html code that corrupts the output of codeproject. The topics after yours are missing and if I open your answer I see the others again but displayed wrong!
------------------------------
Author of Primary ROleplaying SysTem
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.
|
|
|
|
|
select*from for xml path ('Head')
select*from for xml path ('Head') ,root('Title')
select*from for xml raw
try like this there are more formats
|
|
|
|
|
(SELECT * from [db].[schema].[tbl] FOR XML PATH(''),ROOT(''))
|
|
|
|
|
Hello All,
When designing an application, desktop or web, what is the best way to manage users that must access a database?
Is it better to have a single group that all users belong to and let the application manage all the security?
Or setup different groups with different permissions on the database and then associate users with that and whatever security the database can't manage handle that in the application?
Or is there a third way that I am just not seeing?
Thanks,
Koshbert
|
|
|
|
|
You will get answers for both methods.
1) Create users and handle security in the database
2) Create users in the application and connect with one user to the database.
There are pluses and minuses for both situations, however, consider this ...
Given a website like Facebook, you can create an account and have some set of permissions.
Do you really think it is creating a database user on the backend? Hmmm ... Probably not.
The real answer is up to you. You can do it either way.
I personally create one user in the database and handle all the security in the application.
Good luck.
|
|
|
|
|
I agree with David.
I usually create users/rights as structures in the database and use one SQL user/password to access the database.
I do break this rule when security is a one shot item -> You either have full access or you have zero access. In this case I won't go to the trouble to create user/rights structures and just use standard group security on the database.
|
|
|
|
|
So then you guys have a table with user ids and a hash for the password that is used for logging into the application and everyone is associated with the one database user id.
That makes the database management piece pretty easy.
So what is the downside to this approach?
Thanks,
Koshbert
|
|
|
|
|
The only downside is adding development complexity. You need to manage rights in the application which requires the development of objects manage users and thier rights.
|
|
|
|
|
Follow up question:
For desktop applications how do you keep the single user id / password in sync? Alot of people for good reason want to change the supplied default password so hard coding it would be a bad idea.
Is this kind of design pattern covered in a blog, article or book anywhere online?
Thanks,
Koshbert
|
|
|
|
|
I work in a closed environment and have no applications in third party hands so changing the db password is not an issue.
Not sure how I would handle an application at other sites. Even encrypting a connection string would require a hardcoded key somewhere along the line.
|
|
|
|
|
Hello
I am trying to execute this query:
Create Domain Email
As
Varchar(255) Check (Position('@', Value) > 1)
But the below error will occur:
Unknown object type 'Domain' used in a CREATE, DROP, or ALTER statement.
SignatureNotFoundException
|
|
|
|
|
..Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables.
How did you expect this to work? Simply throw in the word "domain" and pray that Sql knows what you want?
Computers don't work like that. You learn the computers language if you want things from it, not the other way around.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables.
A DOMAIN in SQL is defined as a set of values for a given attribute! So, of course SqlServer knows something about domains! It just called different!
In SqlServer you use ADD CONSTRAINT to simulate domains.
------------------------------
Author of Primary ROleplaying SysTem
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.
|
|
|
|