|
|
Yes it is. And since it's native for Sql Server, I'd say you have lot's of opportunities when you play with it 
|
|
|
|
|
codeproject is may interested site and is my project for software engineering 2 in university
.please send me the er of codeproject.com
|
|
|
|
|
r.kh wrote: please send me the er of codeproject.com
er?
|
|
|
|
|
that looks more like a question, not an answer.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You are right, of course!
|
|
|
|
|
Yes ... What do you mean by er ??
|
|
|
|
|
prasanta_prince wrote: What do you mean by er ?
I don't know, what do you mean by er?
|
|
|
|
|
I trust the Emergency Room is strictly staff only, the Evaluation Report is a work in progress, the Equipment Required is simply more, and the Entity Relationships are a business secret.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You forgot Encryption Rights. Although they are tough to decrypt.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
The OP clearly was familiar with them already.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Luc Pattyn wrote: Emergency Room
|
|
|
|
|
codeproject <-- there they are!
|
|
|
|
|
I can send you the ar of CodeProject, the ur of CodeProject, and the ir of CodeProject but we ran out of er's last week. Sorry.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
you are bad, you may be the worst of us all.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
He is, indeed. Intentionally didn't mention the or's at all
|
|
|
|
|
And I thought Luc was bad
|
|
|
|
|
No way.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
r.kh wrote: please send me the er of codeproject.com
I assume by 'er' you really mean Entity-relationship model? Correct? There used to be a site similar in setup to Code Project (not written by Chris), not sure what ever happened with it though. You might go looking around the web development articles and find something interesting to learn from.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
When a variable in my stored procedure contains an apostrophe, it returns me an error.
CREATE PROCEDURE sp_GetEZQueryList @@sUser as nchar(500), @@sSupervisor as char(1), @@sAllowed as varchar(8000) AS
--set @@sUser = REPLACE(@@sUser, '''''','''''')
IF @@sSupervisor <> 'Y'
SELECT
EzqDateMod, EzqFlxID, EzqUserName, EzqName, EzqData, EzqDescrip
FROM EZQuery
WHERE (EzqUserName=@@sUser)
OR (EzqUserName='SYSTEM' AND Cast(EzqFlxID as varchar(10)) IN (select * FROM intlist_to_tbl(@@sAllowed)))
ELSE
SELECT
EzqDateMod, EzqFlxID, EzqUserName, EzqName, EzqData, EzqDescrip
FROM EZQuery
GO
The SP is retrieving @@sUser from VB and its getting the value Do'Sullivan.
When I ran a trace I found it is executing the SP like this
exec sp_getezquerylist 'DO' + CHAR(39) + 'SULLIVAN', 'n', '100'
Think + CHAR(39) + is causing the error
Thanks
Waiting for your suggestions
|
|
|
|
|
You have already posted this message in this forum. Repeating it will only annoy the people who might otherwise give you a solution.
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Hi
I want to generate alpha numeric no like this:
If I say length is 4 it generates like
0001
0002
0003
---
---
---
9999
A001
A002
---
---
---
A999
B001
---
---
zzzz
Please help
Thanks in advance
|
|
|
|
|
You might be able to do something like this with two columns. Put a normal running number in one column and then populate the other column based on the value in the first one:
Col 1 Col 2
1 0001
...
999 0999
...
9999 9999
10000 A001
etc.
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
SELECT CAST(RAND() * 1000 AS VARCHAR) AS [Random_Number]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
