|
i don't know how to use if...exists
i am new to asp.net & database as well
my requirement is to get 3 consecutive working days
declare @i int
declare @count int
set @i=0
set @count=0
while(@count <= 3)
begin
1) select Holiday_Name from Holiday where Holiday_On = DATEADD(day,@i,CONVERT(date,GETDATE()))
the above statement is to check whether holiday exists
2) IF DATEPART(day, DATEADD(day,@i,CONVERT(date,GETDATE()))) = 7 OR DATEPART(dw, DATEADD(day,@i,CONVERT(date,GETDATE()))) = 1
the 2nd statement is to check whether weekend or not
set @i = @i + 1
if there no holiday and not weekend then only the following code is executed
set @count = @count + 1
here i have to retrieve the date...i don't know how to get the date...because i vil get 3 dates...
end
actually i no need to select holiday name in 1)statement...there i am checking for holiday..
|
|
|
|
|
Hi,
I am using the below bcp command to export the binary files from the filestream db and all other files are seems to be exported fine (i.e. txt, pdf, rtf, image files & etc) except docx, xlsx & pptx files. I am able to export these files (i.e. docx, xlsx & pptx) but I am getting a warning/error message when opening those files and then it opens the file properly.
BCP "SELECT content FROM [dbo].[Contents] WHERE ID=1" queryout "C:\Temp\" -T -S (local) -f C:\Temp\files.fmt
I am getting the below message when opening docx, xlsx & pptx files:
XLSX - Excel found unreadable content and Do you want to recover the contents of this document? DOCX - The file test.docx cannot be opened bcos there are problems with the content and then Excel found unreadable content and Do you want to recover the contents of this document?
Also, I have this in my files.fmt file:
10.0
1
1 SQLBINARY 0 0 "\t" 1 content ""
Any help will be much appreciated.
|
|
|
|
|
Hi i am working for a E-Commerce website, i want to know about what are all the table that are required to achieve the task
|
|
|
|
|
|
thanks for your reply..
i have a requirement doc but i am unable to understand that one thats y can u tell me the basic tables which are required to achieve the e-commerce project..
as per my understand
1)user may signup using facebook,twitter,google+..
2)user interests and habits are need to be imported from social networking sites while signing up..
3)user may refer the friends, and stored in different groups
4)search, results will be in sorted as user wish(interest, buying habit, friends recommendations...)
5)reviews, user may write the reviews, like the others reviews.
these reviews are need to keep
6)rating..
7)all like wish list, shopping cart,payment, delivery..
Thanks
subbarao
|
|
|
|
|
Hi Subbarao,
I will give you some sample DB design Document by Monday....
|
|
|
|
|
|
subbaraogaddam wrote: but i am unable to understand
subbaraogaddam wrote: as per my understand
Your project is in deep trouble.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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 
One day we'll look back on this and plow into a parked car.
|
|
|
|
|
|
 well now I feel suitably daft, this is ancient history.
Thank you 
|
|
|
|
|
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:
<?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://www.opengis.net/kml/2.2"> <Document>
[End edit]
|
|
|
|
|
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.
|
|
|
|
|
To avoid XML Escape Characters (" ",' '< <> >& &)
Use this:
FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)')
|
|
|
|
|
Have you got the result...
|
|
|
|
|
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.
|
|
|
|
|
hi to all
i lock a table in sql with belwo query
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
|
|
|
|
|
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 
If you can't read my code, try converting it here[^]
|
|
|
|
|
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:
select * from sys.dm_tran_locks inner join sys.objects on sys.dm_tran_locks.resource_associated_entity_id=sys.objects.[object_id]
|
|
|
|
|
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
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
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:
select top 19 * from(select ROW_NUMBER()over (order by ID ) as rowNumber,* from BML.LoanInstallment where total_amount like '%80%') tbl
|
|
|
|
|
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 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
