sql 2005 views
I am beginning the process of converting a 15 yr old Access db (frontend)
into a website application. It might be 15yo but is still very much used
today and has gone thru all the updates over time. The back end is sql
server 2005. Much in the front end uses sql views.
How are views treated in asp.net sqldatasource? As stored proc, view,
table, or ??? How are they referred to in a sqldatasource? Same as a stored
proc? Any samples/examples/links of using a view?
"JohnE" <JohnE@discussions.microsoft.com> wrote in message
I've moved to a new pc and for some reason I thought that when you
backed up, a new file was created. Am I right? At the moment, it's
just backing up to the backup file. So I've just just my working file
and my backup file. Please could you clarify this?
In microsoft.public.money, abc wrote:
>I've moved to a new pc and for some reason I thought that when you
>backed up, a new file was created. Am I right? At the moment, it's
>just backing up to the backup file. So I've just just my working file
>and my backup file. P...how SIN, COS and TAN works on sql server
I ran this:
declare @f float
set @f = 30
and got -0.988031624092862
What is this?
"Roy Goldhammer" <email@example.com> wrote in message
> I ran this:
> declare @f float
> set @f = 30
> select sin(@f)
> and got -0.988031624092862
> What is this?
The values for SIN, COS, and TAN are in radians, not degrees. You are seeing
the value of SIN(30 radians), which is correct.
"Dan" <firstname.lastname@example.org...Question about Xml Schemas "qualified" and "unqualified"
In the textbook, there is a sentence that "Default XML
namespaces(xmlns="...") helps a lot, but can also create problems, as a side
effect of the rules for automatic qualification. How to understand "automatic
qualification" here? Could you please give me an example? Secondly, unless
otherwise specified, a schema prescribes that loal elements and attributes
must be "unqualified". What does "unqualified" mean? Could you please giv eme
an example? Finnaly, could you please tell me what's purpose of using these
two things? Thanks a lot!
...a question and a question
What is the correct name of the type of selection box used in "customizing
Word", for example.... you select a word or operation from a list on the left
pane and move it over to the right pane.
Is there a template to build one of these?
You will have to explain more in detail what you are trying to do.
Microsoft Word MVP
"cliffordjf" <email@example.com> wrote in message
> What is the correct name of the type of selection box used in "c...Question about Paste Special
Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another. For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t
transpose the data and paste link among other options. And the
sometimes I try and paste data to another workbook and I end up th
paste special options: Bitmap Image Object, picture, bitmap, and I als
lose the ability to paste link. Well you can do it, but it puts it i
as an object.
What I want is the first past...IE8 privacy question
I am running XP-Pro SP3 and considering upgrading from IE7 to IE8.
I have read all the feature and benefit articles from MS, but have one
question that remains unanswered.
In IE8 there is mention of being able to restore previously viewed websites
or something to that effect. I think this is on a drop down menu somewhere.
1) Does In-private viewing prevent this?
2) Does manually deleting your complete browsing history clear this?
3) Is there a registry entry that can prevent this action?
4) Is there a group policy change that can prevent this action?
In essence for privacy pur...IF AND question
I need a function that can provide one of three answers:
1 2 1 1...
3 3 4 4...
? ? ? ?...
If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if
A1=2, regardless of A2, answer 95.
The next function for column B is the same, except the answer is dependent
on the value delivered from the column A function. E.g. A3 + 6 or A3 +4 or
Any help would be most appreciated.
Use the below formula for your first query.
...SQL 2005 Upgrade #2
I know there are Dynamics users that have completed the transition from SQL
2000 to SQL 2005. We are on Dynamics 8.0 SP5 running on SQL 2000 SP4. Step
1 of our move to 10.0 is to upgrade to SQL 2005. We're very clear about the
Server side of the upgrade. I have looked for information on CustomerSource
about impacts and required activities for Dynamics, but have not found much
(This forum is where I have found the most). Is there any
Tim, see below link for upgrade information from Dynamics 8.0 SP5 to 10.0.
https://mbs.microsoft....Microsoft Query question
I am trying to use Microsoft Query to get data from my SQL 2000 databases.
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table...Question
Why did the chicken cross the road?
Dr. Stephen Hopkins, MD
"Dr. Stephen Hopkins, MD" <DrStephenHopkinsMD@discussions.microsoft.com>
wrote in message news:B8434E21-DDA3-44D7-B39B-CD5A8C33A7BD@microsoft.com...
> Why did the chicken cross the road?
> Dr. Stephen Hopkins, MD
To collect her email, why else?
You should be ashamed to put such a title on an idiotic off topic post !!
MS-MVP. MAIL. [DTS] UK.
> "Dr. Stephen Hopkins, MD" <DrSte...OWA Question #16
Quick Question regarding OWA. We are about to finalize migration from 5.5 to
2003. We have an existing web presence already in DNS a www.mydomain.com.
and running on existing web servers. With 5.5 natrually, to access OWA, it
This will not be possible now since OWA runs off of the Exchange server
instead of relying on our web server under 5.5. What's the easiest way to
If you can afford the extra license, you'll probably want to run a front-end
server so no one is connecting directly to the Exchange database s...Text Box Question
I have been using Visio for years, however, something has happened and I
can't figure out how to undo it. Basically up until today when I added a
text box and entered text, the text went horizontal as it was typed. Today
when I add a text box and enter text, the text goes vertical. How do I get
back to the old behavior?
using text container shape adjusting tool (text block tool), make the text
container shape wider horizontally.
Have you used Asian text font recently?...check help for "vertical text"
"Ray Batig" wrote:
I just started a 401K at work and I'm wondering how to deal with it in Money.
I've got my paycheck split into different categories currently and now I
have to put the 401K amount into a category as well. I didn't see one
specifically for this. What do other people use?
Should I start using the 401K Manager? I haven't gone through it yet I'm
just wondering if it works well and how much benefit I'll get from it.
Thanks in advance!
You will want to create an investment account for the 401(k) and TRANSFER
your contributions from your checking account to the...VBA//Oracle Interfacing Question
I have been able to correct to my database but I have one question
Within objSession I want to list all available tables and all
How exactly is this done?
Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
On Nov 16, 12:05=A0pm, jason <jason.mell...@gmail.com> wrote:
> I have been able to correct to my database but I have one question
> Within objSession I want to list all avail...If / Then Question
How would I do this:
IF A1="N" then I need A2 and A3 to="N/A
pknivens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2767
View this thread: http://www.excelforum.com/showthread.php?threadid=47531
> How would I do this:
> IF A1="N" then I need A2 and A3 to="N/A"
In A2 and A3 use this formula > =IF(A1="N","N/A",""), this will return
blank if A1 is not N, if you want it...ROWCOUNT question
The below is a UDF that returns the ROWCOUNT for a table. I need to know
for WHILE loop.
How do I take the Returned value from the UDF and load it intio a variable
in the SP where it was called from? Or maybe there is another way.
ALTER FUNCTION [dbo].[RecCount]
SELECT Rows FROM sysindexes
WHERE id = OBJECT_ID(@TableName) AND indid < 2
Eric S (xxx_noSpam@Hotmail.com) writes:
> The below is a UDF that returns the ROWCOUNT for a table. I need to know
> that va...Exmerge Question #7
When I run Exmerge on a mailbox on my 2003 server to export to a PST,
it will delete all emails after the copy. I thought EXmerge would
"copy" not delete. is this the default? If so how can I just have it do
a copy out to the PST and leave the mailbox alone.
in "options", make sure "archive data to target store" is not selected on
the "Import procedure" tab...
Susan Conkey [MVP]
"Rick" <firstname.lastname@example.org> wrote in message
> When I run Exmerge on ...MS SQL Express 2008
in order to increase performance of my Access 2007 application i choose to
split the backend to a SQl Express 2008 Database engine. However..this seems
not to function..i receive an error message saying - The Upsizing Wizard does
not work with the version of Microsoft SQL server to which your project is
connected..I cannot find anything related to this issue on the Microsoft
I'm not sure, but I doubt Access 2007 can control SQL 2008. Access has never
worked with SQL versions that came out later than the Access versio...question about "delete"
I have a pointer:
MyWindowClass *p = NULL;
p = new MyClass(...);
After delete p, does p equal NULL(it is in C++ standard?)? How to
decide if p has been deleted?
The reason I asked this question is that in my project, there are many
code/files use the pointer which I need to determine is it is deleted?
Can I use:
if(p != NULL)
I guess somewhere p has been deleted, but p still not NULL(possible?),
the above code might cause problem.
I typically just set p to NULL when I delete it:
p = NULL;
Then you can check it in other places and ...More combining companies questions
We too have acquired another company and need to look at all of our options
concerning what to do with email. We run Exchange 2003, they run Exchange
2000. What is the best way to combine the two so we can share GAL, free-busy
info, etc.? No decisions have been made as far as what we are going to do
with their AD.
We could of course change their MX record to point to our server, update our
RUS, etc., but what if we want to keep an Exchange server at their site?
What has to be done to join their server to our Exchange org?
If you want sync both GAL,pls check this
http://www.microso...switchboard question 12-26-07
Is there a way to put the names of different switchboard pages on the
switchboard form? If you put one name on a switchboard page (in form design
view), the same name appears on all the switchboard pages. I understand why
this happens, but what if I want the user to be able to know which
switchboard s/he is on?
PS the same thing happens if I go into form design view and put in control
tip text. It puts the same text for the same-numbered menu item on two
different switchboard pages.
"Debbie S." wrote:
> Is there a way to put the names of different switchboard ...Some Questions about Outlook
1. what's the max size of attachment for sending email?
2. newMail notifitor: when there is a new mail, can the tary be changed to
other until i check the mail? can it work with hotmail?
3. is there any function likes "To Do List"; calendar require time setting?
4. configure file backup; can i back up all of my setting?
Me, Who I am
On Sun, 7 May 2006 22:17:01 -0700, Dotku <email@example.com> wrote:
>1. what's the max size of attachment for sending email?
That would depend on your mail server/ISP.
>2. newMail notifitor: when there is a new mail, can the ...Error Installing SQL jobs during installation of CRM 4.0 trail ver
While trying to install SQL jobs during installation of CRM 4.0 trail version
i get an error message.
Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed.
Invalid user name.Failed to validate username for given domain.only existing
domain usernames and email addresses are allowed
Invalid user name.Failed to validate username for given domain.only existing
domain usernames and email addresses are allowed
can anyone help me solve out this issue ?
...Version control for SQL Server databases
It is my understanding that version control for sql server databases
can be problematic. I have been thinking about this problem on and off
for a while, and over the last couple of hours the beginnings of a
system have crystallized. I am going to sketch the first draft of this
evolving idea below. If anyone recognizes the mechanisms as already
existing in some product or solution, please let me know. If anyone
recognizes problems or limitations of the system, please let me know
about those too.
Once again, this is just a first draft that I have been brainstorming
for about 2 hours, ...