Database

Re: common genreal stored procedure in sql server

26-Apr-07 5:21

And another thing...

You should define the column list in the SELECT statement for a number of reasons.

Performance - Defining the list up front means SQL Server doesn't have to work it out.

Reliability - Defining the list up front gives your stored procedure a consistent interface to the outside world. If you add or rearrange columns the stored procedure's output will remain the same - which means that the application using it will continue to work. If the changes are breaking changes then the point it breaks will be in the stored procedure which is closer to the change than anywhere else. This means it should be easy to find the dependencies and fix the remaining code.

Upcoming events:
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Hasan Jaffal26-Apr-07 5:31

Hasan Jaffal

26-Apr-07 5:31

thanks man

creating a crystal report using a dataset

rkherath26-Apr-07 0:50

rkherath

26-Apr-07 0:50

Hi all,

I am having a stored procedure which requests 2 parameres for the where statement. i wanna fill a dataset from this stored procedure and then create a crystal report from that.

dataset fill happenes when user clicks

please help me and tell me a way to do thid.

Regards
Ruwandi

rkherath

Tirthadip26-Apr-07 0:57

Tirthadip

26-Apr-07 0:57

Design A report(suppose its ID is myReport)

after populating your dataset(say myDataset) try this code.....

[take a CrystalReportViewer Control(say it's ID is myViewer)]<br />
 Dim oRpt As New myReport<br />
 oRpt.SetDataSource(myDataset)<br />
 myViewer.ReportSource = oRpt

Tirtha

Miles to go before I sleep

rkherath26-Apr-07 1:08

rkherath

26-Apr-07 1:08

Hi,

Thanks. but i wanna keep a certain format in the report . can i do that with this.

eg:
if dataset fills like

group groupNum Code balance
A 1 a1 10
A 1 b1 15
B 2 a2 20
B 2 b2 25
C 3 a3 30
C 3 b3 12

but i need report to display

code balance
a1 10
b1 15

A 1 25

a2 20
b2 25

B 2 45

a3 30
b3 12

C 3 42

total 112

i hope you can understand

Regards
ruwandi

regards
ruwandi

rkherath

Tirthadip26-Apr-07 1:22

Tirthadip

26-Apr-07 1:22

You can Group your data on your "group" field....and for the addition of balance amount you can use a Simple Formula in Crystal report....

Tirtha

Miles to go before I sleep

Re: storing array values in a column

rkherath26-Apr-07 1:39

rkherath

26-Apr-07 1:39

thx but how about displaying group number infront of the gruop

regards
Ruwandi

rkherath

[Message Deleted]

gubba25-Apr-07 23:37

gubba

25-Apr-07 23:37

[Message Deleted]

Tirthadip25-Apr-07 23:50

Tirthadip

25-Apr-07 23:50

Concatenate the array values into a string with some Separator or Delimiter(e.g comma,apostrophe,tilde etc.) and insert in table as Text....

Tirtha

Miles to go before I sleep

Re: storing array values in a column

Hasan Jaffal26-Apr-07 5:25

Hasan Jaffal

26-Apr-07 5:25

the array is in vb.net ????
if yes : so u can place it in a datatable
and then insert it in table of the data base

SQL Management Studio Security

Brady Kelly25-Apr-07 23:23

25-Apr-07 23:23

Please will someone advise me on a resource that nicely explains security using Management Studio. I need to grant a permission to the database owner, but dbo isn't a real user, so how can I grant the permission? The user is linked to login 'sa'.

Colin Angus Mackay26-Apr-07 0:09

26-Apr-07 0:09

Brady Kelly wrote:
The user is linked to login 'sa'.

If the user is "sa" surely they have permission to do anything?

Brady Kelly26-Apr-07 0:16

26-Apr-07 0:16

The term 'surely' is the most innaproprate term I have ever come across for describing anything related to this area of SQL Server security.

Colin Angus Mackay26-Apr-07 1:57

26-Apr-07 1:57

Okay - "sa" has permission to do anything it likes.

Brady Kelly26-Apr-07 2:05

26-Apr-07 2:05

Except create unsafe assemblies. I had to log in under my Windows account and grant that user the unsafe assembly permission.

Colin Angus Mackay26-Apr-07 5:11

Scheduling stored procedures in sql server 2000

26-Apr-07 5:11

Ah... I'm still going on my knowledge of SQL Server 2000. My bad.

siddhi030325-Apr-07 22:35

siddhi0303

25-Apr-07 22:35

Hi I have a table with datetime field and a stored procedure which should update this table on the date n time specified. This should take place automaticaly at the specified date and time.

Kindly suggest any solutions to this query.

Thanking you in anticipation.

Regards

Siddhi

Database Security

.NET- India 25-Apr-07 22:23

.NET- India

25-Apr-07 22:23

Helllo All,
I want to keep my database secure by backened. Actually i donot want to let anybody to make any modification in my database(Sql Server2000) through Enterprises Manager and also only the authorised users can have accesss to the database through frontened(ASP.NET)

Plz.......................
..........................

Re: Database Security

Colin Angus Mackay25-Apr-07 22:32

CLR Deployment in SQL Server

25-Apr-07 22:32

The Knowledge wrote:
Actually i donot want to let anybody to make any modification in my database(Sql Server2000) through Enterprises Manager

Not gonna happen.

Enterprise manager can connect to the database using any account that has been set up. (Typically it will connect as sa [the sys admin]). If you have any kind of access to the database from an application, Enterprise Manager will be able to connect using the same credentials.

Brady Kelly25-Apr-07 21:21