Database

Re: Get Two top element

GuyThiebaut25-Oct-07 23:47

GuyThiebaut

25-Oct-07 23:47

select top 2 itemnumber
from stocktable
order by itemnumber desc

You always pass failure on the way to success.

how to run sp_who2 script [modified]

skyleo_200825-Oct-07 22:54

skyleo_2008

25-Oct-07 22:54

first,thank for willing help me to solve my question, Q1 and Q2.

Q1. I knew "sp_who2" is using to detect who is using database.But , i have not idea that how i write at first?
Q2. Where should i put my script?

Thank again.

-- modified at 5:37 Friday 26th October, 2007

Re: can some1 help me ?i have not idea at all.

pmarfleet25-Oct-07 23:24

pmarfleet

25-Oct-07 23:24

First of all, read the forum guidelines about naming your posts. Your subject line isn't helpful.

I don't understand your question. Do you want to run an ad-hoc SQL script that calls the SP sp_who2. If you are using Management Studio, open up a new query window for your database and execute it from there. If you are using the SQL 2000 client tools, fire up Query Analyser and do the same.

Paul Marfleet

Re: can some1 help me ?i have not idea at all.

skyleo_200825-Oct-07 23:37

skyleo_2008

25-Oct-07 23:37

thank for your remind about my mistake and your solution.
thank again.

SQL Server and VSS

Anilkumar K V25-Oct-07 20:13

Anilkumar K V

25-Oct-07 20:13

Can we connect SQL Server 2005 to VSS directly or indirectly using Visual Studio 2005?

Re: SQL Server and VSS

Frank Kerrigan26-Oct-07 11:17

Frank Kerrigan

26-Oct-07 11:17

You need to create a VS2005 database project first I'm afraid.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Can anyone explain in detail about DB LOCKING

Sathiyaraj Ganesan25-Oct-07 18:36

Sathiyaraj Ganesan

25-Oct-07 18:36

Many times i came across situations where multiple users updates the same set of records at the same time simultaneously. And i also came across situations while i am selecting a set of 100 records another process should not pick the same set of records.How to Implement this???

Can anyone explain in detail about DB LOCKING and how to retaining DB Integrity..

Whether to apply in Application end while querying or at DB end. And how to test whether LOCKING is implemented or not???

Sathiya

Re: Can anyone explain in detail about DB LOCKING

il_masacratore26-Oct-07 3:22

il_masacratore

26-Oct-07 3:22

I think that google is your answer...

Start reading this guide for database integrity and concurrency : http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10743/data_int.htm

And these about locks:

http://www.dbpd.com/vault/saracco.htm

Visit my blog at http://dotnetforeveryone.blogspot.com

How to deploy .Net App with Sql Server and Configure Clients

DotNetWWW25-Oct-07 7:59

DotNetWWW

25-Oct-07 7:59

Hi ,
I'm writing .Net Application that works with MS SQL 2005 , and I'm going to run this app on a Windows Server 2003 Operation System and Windows XP Clients , What should I do to deploy this app? Is it enough to Install the main app just in Server computer and then install prerequisites on Clients?Note that I connect to SqlServer using a unique Login and I'm not going to create a new Login for each client .I mean all clients must connect to server using ONE SqlServer Login. I need help on this subject ,

Thanks in advance .

Re: How to deploy .Net App with Sql Server and Configure Clients

pmarfleet25-Oct-07 9:49

pmarfleet

25-Oct-07 9:49

You haven't explained what the architecture of your system is. Which parts of the system do you install on the server computer and which parts on the client machines?

If your architecture consists of a SQL Server database on your server and a .NET app installed on a number of client PCs, all you need to do is add a connection string entry to the App.config file for your client app that allows your app to connect to the database using the aforementioned SQL login.

Paul Marfleet

Re: How to deploy .Net App with Sql Server and Configure Clients

DotNetWWW25-Oct-07 11:01

DotNetWWW

25-Oct-07 11:01

Thanks , Is it possible to just install .Net App on server and share it so that other clients can run it to avoid installing my .Net app on each client?

Change in Generate Scripts Options

Brady Kelly25-Oct-07 5:12

Brady Kelly

25-Oct-07 5:12

For a long time, the Tasks-Generate Scripts command in SSMS used to really annoy me, because I had to choose between creating DROP or CREATE scripts, and only had an optional IF EXISTS check.

Now I'm presented with a set of options that allows an IF NOT EXISTS, and DROP and CREATE in the same script. Am I going mad? What could have caused this change?

Re: Change in Generate Scripts Options

Frank Kerrigan26-Oct-07 11:19

Frank Kerrigan

26-Oct-07 11:19

No seems quite sensible to me; these are used to stop you getting an errors by creating something that is already created.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: Change in Generate Scripts Options

Brady Kelly28-Oct-07 22:18

Brady Kelly

28-Oct-07 22:18

It know it's more sensible, I just don't know when it changed and what updated caused it to change.

SELECT DISTINCT Help

solutionsville25-Oct-07 4:58

solutionsville

25-Oct-07 4:58

I have an SQL 2005 data table that has these coloumn;

Name Type
EventDate, DateTime
WaysideAddress, Nvarchar(50)
WaysideName, Nvarchar(50)
State, nchar(10)
AlarmMessage, Nvarchar(50)

What I am trying to do is count the total number of distinct AlarmMessage that each WaysideName reported from the table Grouped by EventDate and WaysideName.

The AlarmMessage is all text.

So the results of the query should look like this;

WaysideName|AlarmMessage|Count

Thanks,

Re: SELECT DISTINCT Help

solutionsville25-Oct-07 5:47

solutionsville

25-Oct-07 5:47

Solved my own question;

SELECT DISTINCT WaysideName, ST, AlarmMessage, COUNT(AlarmMessage) AS Error_Count
FROM AlarmsList
GROUP BY WaysideName, ST, AlarmMessage
ORDER BY Error_Count DESC, ST, WaysideName, AlarmMessage

Thanks Everyone regardless!

Counting rows containing data in Dataset;

Shahzad.Aslam25-Oct-07 3:57

Shahzad.Aslam

25-Oct-07 3:57

Hi
I want to count the rows in a DataTable but it should ignore blank rows, I am trying something this,

string batchid = ds.Tables["No"].Columns[0].ColumnName;
ds.Tables[0].DefaultView.RowFilter = "" + batchid.Trim() + "=" + string.EmptyString;
int records=ds.Tables[0].Rows.counl;

the above code showing me following error.

Syntax error: Missing operand after '=' operator

Shahzad Aslam
Software Engineer
Email: shehzadaslam@hotmail.com

Re: Counting rows containing data in Dataset;

J4amieC25-Oct-07 4:45

J4amieC

25-Oct-07 4:45

You are mixing up code with a string expression.

<br />
ds.Tables[0].DefaultView.RowFilter = "" + batchid.Trim() + "=''";

---

How to get answers to your questions[^]

Re: Counting rows containing data in Dataset;

Shahzad.Aslam25-Oct-07 19:44

Shahzad.Aslam

25-Oct-07 19:44

This is still not working and giving the following error:

Cannot perform '=' operation on System.Int32 and System.String.

Shahzad Aslam
Software Engineer

Persistant Memory with CLR Stored Proc

Brady Kelly25-Oct-07 2:58

Brady Kelly

25-Oct-07 2:58

I've just had a very strange experience running a CLR stored proc. The procedure takes its data source connection from the context, and its destination connection string from the source DB. When I first ran the proc, I got back the error, "Keyword not supported: Provider", so I removed the provider clause from the destination connection string.

However, until I restarted my SQL server, I continued to get the same error. My ONLY action that resolved it AFTER correcting the connection string was restarting the server. This is plain scary if updating DATA, never mind code, requires a server restart.

Re: Persistant Memory with CLR Stored Proc

Brady Kelly25-Oct-07 8:46

Brady Kelly

25-Oct-07 8:46

OK, it turns out the dest. connection string is stored in a static field, and I only set its value from the database the first time it is read. SQL Server just keeps the class loaded 'forever', so every subsequent access returns the first value.

SCOPE_IDENTITY()

Illegal Operation25-Oct-07 1:16

Illegal Operation

25-Oct-07 1:16

I wrote a stored procedure that looks like this.

CREATE PROCEDURE dbo.TEST
(
@Name varchar(50),
@Surname varchar(50)
)

DECLARE @ID int

INSERT INTO Table1
(
Name,
Surname
)
VALUES
(
@Name,
@Surname
)
SELECT @ID = SCOPE_IDENTITY()

The problem is that the SCOPE_IDENTITY() does not get the ID value.

Illegal Operation

Making Computer Software Talk

Re: SCOPE_IDENTITY()

N a v a n e e t h25-Oct-07 1:31

N a v a n e e t h

25-Oct-07 1:31

Illegal Operation wrote:
SELECT @ID = SCOPE_IDENTITY()

try SET @ID = (SELECT SCOPE_IDENTITY())

My Website | Ask smart questions

Re: SCOPE_IDENTITY()

WoutL25-Oct-07 1:45

WoutL

25-Oct-07 1:45

Does the table have an identity column?

Wout Louwers

Re: SCOPE_IDENTITY()

John-ph25-Oct-07 2:14

John-ph

25-Oct-07 2:14

Illegal Operation wrote:
DECLARE @ID int

Here in your stored procedure you have Declared @ID as just a local variable. If you need that value to be returned by the procedure then you have declare it as a output parameter.

DECLARE @ID int OUT

[OR]

CREATE PROCEDURE [spTest]<br />
          @ID    int OUT,<br />
	    -- Other parameters here<br />
AS<br />
	    -- Your Insert Query Here<br />
          SELECT @ID= SCOPE_IDENTITY()<br />
GO

Regards
- J O H N -

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.