QUERIES VS STOREDPROCEDURES

I use visual studio 2005 standard edition and sql express 2005.I would like to know if there is any difference using queries(designed in dataset xsd) or stored procedures.

Also I am having the following problem :Whenever I make a change on a table in my database (add columns etc) and use the wizard to retrieve the changes i loose all the queries for that table (I have to write them again).Am i doing something wrong?

Thanks in advance!!!

There is quite a bit of difference between VS queries and SQL Server Stored Procedures.

First, Stored Procedures are actually stored in SQL Server. They don't just 'vanish' -as you are discovering happens to your VS queries. (If you make changes to the tables that cause the stored procedures to fail, they will still be there -just error when executed (until repaired.)

Stored procedures, when called, are compiled and an execution plan is prepared on SQL Server. That execution plan can be reused the next time the stored procedure is called -saving time.

Security can be applied to stored procedures, allowing or denying the 'right' to use them.

Developers don't have to know where the stored procedures are getting their data, and the application doesn't have to be changed when the database changes -just change the stored procedures.

And the list goes on...

|||

Stored procedures are easier to maintain than in-line queries. They are more secure than in-line queries, since they are less vulnerable to SQL Injection attacks. They can also reduce network traffic (incoming to the DB server).

As long as you don't change the interface of a stored procedure (name, parameters, and return values). This will insulate you from the problems you are seeing now when you make table changes.

|||

Hi,

If you seperate the database queries from your application codes by using stored procedures, it will be easier to modify the sql queries for purposes of improving performance, updating queries, etc. Otherwise you should make those changes in your application.

Eralper

http://www.kodyaz.com

|||

Thank you!

I can see now the benefits of stored procedures.

QUERIES VS STOREDPROCEDURES

I use visual studio 2005 standard edition and sql express 2005.I would like to know if there is any difference using queries(designed in dataset xsd) or stored procedures.

Also I am having the following problem :Whenever I make a change on a table in my database (add columns etc) and use the wizard to retrieve the changes i loose all the queries for that table (I have to write them again).Am i doing something wrong?

Thanks in advance!!!

There is quite a bit of difference between VS queries and SQL Server Stored Procedures.

First, Stored Procedures are actually stored in SQL Server. They don't just 'vanish' -as you are discovering happens to your VS queries. (If you make changes to the tables that cause the stored procedures to fail, they will still be there -just error when executed (until repaired.)

Stored procedures, when called, are compiled and an execution plan is prepared on SQL Server. That execution plan can be reused the next time the stored procedure is called -saving time.

Security can be applied to stored procedures, allowing or denying the 'right' to use them.

Developers don't have to know where the stored procedures are getting their data, and the application doesn't have to be changed when the database changes -just change the stored procedures.

And the list goes on...

|||

Stored procedures are easier to maintain than in-line queries. They are more secure than in-line queries, since they are less vulnerable to SQL Injection attacks. They can also reduce network traffic (incoming to the DB server).

As long as you don't change the interface of a stored procedure (name, parameters, and return values). This will insulate you from the problems you are seeing now when you make table changes.

|||

Hi,

If you seperate the database queries from your application codes by using stored procedures, it will be easier to modify the sql queries for purposes of improving performance, updating queries, etc. Otherwise you should make those changes in your application.

Eralper

http://www.kodyaz.com

|||

Thank you!

I can see now the benefits of stored procedures.

Queries in SQL compact Edition

If my research is correct SQL CE as of this date does not support STORED PROCEDURES (queries).

If this is true, how can it hope to compete with MS ACCESS or MS Foxpro as a Desktop database.

This seems to be a lot of hype for something that appears to be totally in-adequate.

I thought this was a way to wean off of MS ACCESS.

Can someone tell me what I am missing ?

Thanks

John

SQL CE is not a replacment for MS Access, but can be used as small footprint, in-process database engine together with yur custom application. Queries (meaning select statements in your code) is supported. The storage of your query strings must be handled by your application, not by SQL CE.|||

Access is a front-end database application tool--not a DBMS. Access by default uses JET as its DBMS engine. SQLCe is not an Access replacement but it can be a faster, lighter, more secure alternative to JET.

AFA stored procedures, these can be implemented in your code but they are not stored in the database or exectuted by the DBMS engine. This gives you the ability to create your own common code routines to replace SP functionality--something JET does not have. While JET supports canned queries, these do not support the logic afforeded by a real SP as supported by TSQL and SQL Server.

For many situations even JET is overkill--SQLCe is designed for these situations--especially when security of the stored data is an issue. JET databases cannot be encrypted--SQLCe databases can.

See my EBook FMI: www.hitchhikerguides.net.

Quad dualcore CPU server - can I use SQL2k5 Standard?

Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
said - up to 4 CPUs. Will Standard Edition use all 8 cores?"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
> said - up to 4 CPUs. Will Standard Edition use all 8 cores?
Yes.
David|||Thanks David.
But I can not found it on MS site, may you give link?
"David Browne" wrote:
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> > Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
> > said - up to 4 CPUs. Will Standard Edition use all 8 cores?
> Yes.
> David
>
>|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Note under CPU Comments column, it says "Includes support for multi-core
processors".
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:2DA4C3BD-7DFD-4B1A-8D97-104F969CAD40@.microsoft.com...
> Thanks David.
> But I can not found it on MS site, may you give link?
> "David Browne" wrote:
>> "andsm" <andsm@.discussions.microsoft.com> wrote in message
>> news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
>> > Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs?
>> > Licence
>> > said - up to 4 CPUs. Will Standard Edition use all 8 cores?
>> Yes.
>> David
>>

Quad dualcore CPU server - can I use SQL2k5 Standard?

Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
said - up to 4 CPUs. Will Standard Edition use all 8 cores?"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
> said - up to 4 CPUs. Will Standard Edition use all 8 cores?
Yes.
David|||Thanks David.
But I can not found it on MS site, may you give link?
"David Browne" wrote:

> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> Yes.
> David
>
>|||http://www.microsoft.com/sql/prodin...e-features.mspx
Note under CPU Comments column, it says "Includes support for multi-core
processors".
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:2DA4C3BD-7DFD-4B1A-8D97-104F969CAD40@.microsoft.com...[vbcol=seagreen]
> Thanks David.
> But I can not found it on MS site, may you give link?
> "David Browne" wrote:
>

Quad dualcore CPU server - can I use SQL2k5 Standard?

Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
said - up to 4 CPUs. Will Standard Edition use all 8 cores?
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence
> said - up to 4 CPUs. Will Standard Edition use all 8 cores?
Yes.
David
|||Thanks David.
But I can not found it on MS site, may you give link?
"David Browne" wrote:

> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:3F997145-B8CD-46F0-9D22-3115C4D4DB7B@.microsoft.com...
> Yes.
> David
>
>
|||http://www.microsoft.com/sql/prodinf...-features.mspx
Note under CPU Comments column, it says "Includes support for multi-core
processors".
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:2DA4C3BD-7DFD-4B1A-8D97-104F969CAD40@.microsoft.com...[vbcol=seagreen]
> Thanks David.
> But I can not found it on MS site, may you give link?
> "David Browne" wrote:

Qaurterly Report

Hi everyone,

I'm currently using Visual Web Developer 2005 Express Edition, I have a chart that shows everything The Y axis displays the quantity and X axis shows the month.Well, the X axis I grouped it by month, but i want to set jan-march as q1 and so on.How can I format it, or do so it can display that format?

Thanks ahead of time,
Shuy

It would be easy if you could populate the data from the backend. You could group the data for three months and send the database back to the front end.

|||

If you mean to change the output in some text field based on a column result, you can use IIF to make that change:

= IIF(Fields!Column.Value) = "Quarter1", "Jan-Mar",IIF(Fields!Column.Value) = "Quarter2", "Apr-Jun", IIF(Fields!Column.Value) = "Quarter3", "Jul-Sep", "Oct-Dec")

|||

Thanks so much...just what i needed.