I keep running into xml format issues in various editors ... please advise - Database Discussion Boards

Re: Database design for E commerce web site

subbaraogaddam8-Mar-13 20:40

subbaraogaddam

8-Mar-13 20:40

Thanks a lot....

Re: Database design for E commerce web site

Shameel11-Mar-13 4:51

Shameel

11-Mar-13 4:51

subbaraogaddam wrote:
but i am unable to understand

subbaraogaddam wrote:
as per my understand

Your project is in deep trouble.

Re: Database design for E commerce web site

Richard MacCutchan8-Mar-13 22:08

Richard MacCutchan

8-Mar-13 22:08

I don't know how you managed to get this job, but I hope your boss does not belong to CodeProject. I would suggest you spend the rest of the weekend using Google to research "e-commerce solutions".

Use the best guess

Re: Database design for E commerce web site

jschell10-Mar-13 6:30

jschell

10-Mar-13 6:30

You are in trouble.

You need a basic understanding of the following skills
- Reading and understanding requirements.
- Creating designs
- Creating data models
- Creating databases

And I expect that you are going to also need the following skills
- Internet Security
- Web design
- Basic SQL
- Intermediate Database management and SQL
- Basic user security
- Basic business retail knowledge

You could probably start by learning how to create databases, create tables and use SQL to access them. That would probably take a week.

Then learn about business retail and improve your requirement reading skills. No idea how long that will take you.

The two above together can then be used to create some tables that are at least something like what is needed for the project.

db_accessadmin?

ThePotty17-Mar-13 23:57

ThePotty1

7-Mar-13 23:57

OK, so as I understand it the db_accessadmin role got merged into db_securityadmin in recent versions of SQL server? This is fine, it's better this way.

My question is, when did it happen? I try to cater for all reasonable flavours of SQL server in my system, I recently took great joy in removing support for SQL 7 (The last client using it paid me to migrate their data to 2008r2 via 2005).

Now I'm trying to set up a login with both db_accessadmin & db_securityadmin rights. Or just db_securityadmin, if appropriate. So I need to know which release they merge in. Google is useless on this, so is MSDN.

I could just try to grant the right and suppress the error if it fails, On Error resume next anyone Poke tongue | ;-P

One day we'll look back on this and plow into a parked car.

Re: db_accessadmin?

JammoD878-Mar-13 1:21

JammoD87

8-Mar-13 1:21

Hi,

Looking on MSDN, it looks like the last version that the db_accessadmin role was available was SQL Server 2000.

I have attached the links for the Fixed Server Roles in SQL Server from 2000 onwards.

http://technet.microsoft.com/en-us/library/cc966453.aspx[^] - 2000
http://msdn.microsoft.com/en-us/library/ms175892(v=sql.90).aspx[^] - 2005
http://msdn.microsoft.com/en-us/library/ms175892(v=sql.100).aspx[^] - 2008
http://msdn.microsoft.com/en-us/library/ms175892(v=sql.105).aspx[^] - 2008 R2

Hope this helps!

Cool | :cool:

Personal Blog: A Software Programmer
Twitter: JammoD

Re: db_accessadmin?

ThePotty18-Mar-13 1:53

ThePotty1

8-Mar-13 1:53

well now I feel suitably daft, this is ancient history.

Thank you Big Grin | :-D

I keep running into xml format issues in various editors ... please advise

RedDk7-Mar-13 11:13

RedDk

7-Mar-13 11:13

I have a SQL Server project that I'm currently adding code to using SSMSE2k8 and beside the fact that this is all TSQL, there's this creep that's occuring in the facility. Namely the .xml. Now, here's the more technical side of TSQL as related to XML, using a FOR XML PATH juncture. I can do a basic SELECT query and get output of xml (pseudo output really because ... this is the creep; in ssmse that's as far as development WENT) but I'm constrained by all these substitutions in he editor:

<?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://www.opengis.net/kml/2.2"> <Document>

Control characters!

What's the purpose of eliminating right & left arrows ... anyway?

And how might I preserve them and keep the phantom formatter from invading my ... "style" (if you could call it that)?

[Edit]
And wouldn't you know it? This phantom has got me here in a paste! That tagged string up there in the midst of my paragraph is suposed to be:

&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;kml xmlns="http://www.opengis.net/kml/2.2"&gt; &lt;Document&gt;

[End edit]

Re: I keep running into xml format issues in various editors ... please advise

RedDk7-Mar-13 12:13

RedDk

7-Mar-13 12:13

Wow,

Could have knocked me over with a feather ... the reason that my editor (was) going south was because of the type I had used to reassign parsed lines of singleline .xml while striking it up as data in a table!.

[nvarchar](MAX) throws (bad use of an alliteration) the phantom formatter into overdrive, while [xml] is silently overlooked. Thus arrows are preserved.

Re: I keep running into xml format issues in various editors ... please advise

Davidduraisamy7-Mar-13 19:45

Davidduraisamy

7-Mar-13 19:45

To avoid XML Escape Characters (" ",' '< <> >& &)

Use this:
FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)')

Re: I keep running into xml format issues in various editors ... please advise

Davidduraisamy8-Mar-13 0:54

Davidduraisamy

8-Mar-13 0:54

Have you got the result...

Re: I keep running into xml format issues in various editors ... please advise

RedDk8-Mar-13 8:31

RedDk

8-Mar-13 8:31

My bad,

The original code that I used as the query:

SELECT [xmliform] AS 'data()' FROM [database].[xml].[tblXMLAsTypeNvarchar] FOR XML PATH('')

So, as you can see, an editor will try to format anything from a table where the type is [nvarchar] using it's xml parser when I specify "FOR XML PATH" regardless of how bad I "want" it as xml. And that is with substituted control characters.

how to unloch table in sql

mhd.sbt7-Mar-13 7:38

mhd.sbt

7-Mar-13 7:38

hi to all

i lock a table in sql with belwo query

SQL

begin tran
select * from  BML.LoanApplication with(TABLOCKX)

now i want to unlock this table but i cant
.
i can read from this table by nolock but i want to unlock this table
any help can be usefule

Re: how to unloch table in sql

Eddy Vluggen7-Mar-13 8:01

Eddy Vluggen

7-Mar-13 8:01

First of all, locking has little use when selecting. Second, the lock is released as soon as the statement completes.

What did you think it does?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: how to unloch table in sql

mhd.sbt7-Mar-13 21:15

mhd.sbt

7-Mar-13 21:15

ok but this is when that you use COMMIT end of my related code.
but i dont use COMMIT tran in my code.
and if use this code you can see that this table is lock:

SQL

select * from sys.dm_tran_locks inner join sys.objects on sys.dm_tran_locks.resource_associated_entity_id=sys.objects.[object_id]

Re: how to unloch table in sql

Eddy Vluggen7-Mar-13 22:31

Eddy Vluggen

7-Mar-13 22:31

mehdi.sabet wrote:

ok but this is when that you use COMMIT end of my related code.

but i dont use COMMIT tran in my code.

First, it's a lousy example; there's no way that the server can "guess" whether it should be rolled back or comitted automatically. Second, there is nothing to commit or rollback, since a SELECT statement doesn't change the data. Don't use a transaction when selecting. Also, set

<a href="http://msdn.microsoft.com/en-us/library/ms188792.aspx">XACT ABORT</a>[<a href="http://msdn.microsoft.com/en-us/library/ms188792.aspx" target="_blank" title="New Window">^</a>]

to ON. Also, don't lock an entire table, unless really, really required.

mehdi.sabet wrote:
and if use this code you can see that this table is lock:

Code to close it on SO[^]

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: how to unloch table in sql

mhd.sbt7-Mar-13 22:51

mhd.sbt

7-Mar-13 22:51

ok thankue

a query by less performnace

mhd.sbt7-Mar-13 4:00

mhd.sbt

7-Mar-13 4:00

hi to all
im face with low performance by below query in sql server 2008 any one can help me.
my query is goon work when top has larg number but when top has less row (for example top 19) this query has low performance for table loaninstallment with amount of records(10000000 R).
any one can help me
thanks for any help
my code:

SQL

select top 19 * from(select ROW_NUMBER()over (order by ID ) as rowNumber,* from BML.LoanInstallment where total_amount like '%80%') tbl

Re: a query by less performnace

Eddy Vluggen7-Mar-13 8:02

Eddy Vluggen

7-Mar-13 8:02

mehdi.sabet wrote:
my query is goon work when top has larg number but when top has less row (for example top 19) this query has low performance for table loaninstallment with amount of records(10000000 R).

..caused by the ROW_NUMBER function. Do you need it? Is it "just" a way of numbering the records? If yes, select into a temp-table and add the ROW_NUMBER there.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: a query by less performnace

mhd.sbt7-Mar-13 22:46

mhd.sbt

7-Mar-13 22:46

thankue for answer
i change my query to this:

SQL

create table  #tblTemp(
ID int,
RowNumber int
)
insert into #tblTemp
select ID,ROW_NUMBER()  over(order by ID) RowNum from BML.LoanInstallment
select top 19 * from(select payment_date,total_amount,BML.LoanInstallment.ID,RowNumber from BML.LoanInstallment
inner join 
#tblTemp on #tblTemp.ID = BML.LoanInstallment.ID
 where total_amount like '%80%') tbl

this run completed a large of second
i think the reason of this is my where clause that i use like in this clause and if i remove it my query is ok and response in reasonable time.
what you thinks ?
thanks

Re: a query by less performnace

Eddy Vluggen7-Mar-13 22:49

Eddy Vluggen

7-Mar-13 22:49

I think you should try it, and then thank Mycroft Smile | :)