Database

Re: Resetting the auto-increment

8-Mar-06 22:19

Thanks, but where do I type this in? SQL Management studio? Where can I read more about this?

albCode8-Mar-06 22:31

albCode

8-Mar-06 22:31

Open Query analizer use ur Databse and write taht line code
dbcc checkident('table_name',reseed,0) and run this query

check this also http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5lv8.asp

--run this query

use name_of_dataabse
dbcc checkident('table_name',reseed,0)

Sql sending SMS or email, or launching an application.

Sirag8-Mar-06 18:35

Sirag

8-Mar-06 18:35

Hi all..
Please help me make SQL server, send alerts with special text, as SMS or email to a specified person whose phone or email are present in the database.The sending process should occur when the data related to this person is updated, or when his birthday is met for example(as a reminder).
And how can SQL launch an application, for example vb.net or asp.net application as a responce for an event, alert, or job.

AND Thanks before...

Sirag..

Re: Sql sending SMS or email, or launching an application.

shm5314-Mar-06 7:45

Insert Values from Radio Button into a SQL Table

14-Mar-06 7:45

Have you looked at SQL mail? There is a COTS package called Postie that will send mail too. SQL mail requires Outlook to be installed on the SQL Server. Check also DatabaseMail with SQL 2005

Armando_Ramirez8-Mar-06 18:18

Armando_Ramirez

8-Mar-06 18:18

Im developing in Visual Studio 2005 and trying to insert the value of a Radio Button into a specific row of a SQL Table.

Is there a "codeless" way to do this ????

Thanx ¡

Armando
---
Mexico

Re: Insert Values from Radio Button into a SQL Table

shm5314-Mar-06 7:28

How to setup a column to auto-increment

14-Mar-06 7:28

PLESE RE_POST IN PROPER AREA. THAT IS NOT A SQL QUESTION

help me>>>

confusegal8-Mar-06 17:56

confusegal

8-Mar-06 17:56

I am developing a system using Dreamweaver ASP.NET VB, with MS SQL server. I need to know how to insert signature in database (store) and make it appear at a page that comes with the person's name, position and etc for user's view. each page for one person's particular. Sleepy | :zzz:

Mundo Cani8-Mar-06 8:07

Mundo Cani

8-Mar-06 8:07

Hello,

I have an identity column that is set up to auto-increment via the "Identity Increment" property for the column. This is working fine.

However, I have another column that I'm calling "Sequence". This is not an identity column, it just specifies the position of each record which is subject to change. I want to set up the column to auto-increment so I don't have to manually enter the Sequence number for each record I add. Is there a way to set up a column to auto-increment without making the column an Identity column, and still allowing me to manually change the Sequence numbers later if I want?

BTW: I'm adding data to the table in Microsoft SQL Server Management Studio.

Thanks!

Ian

Re: How to setup a column to auto-increment

goyal manish8-Mar-06 18:20

goyal manish

8-Mar-06 18:20

Use follwing:
objCol.AutoIncrement = true;
objCol.AutoIncrementSeed = 1;
objCol.AutoIncrementStep = 1;
objCol.ColumnName = "ID";
Smile | :)

Re: How to setup a column to auto-increment

Mundo Cani10-Mar-06 9:28

Mundo Cani

10-Mar-06 9:28

Thanks for the reply. I should have specified that I'm creating the table in Microsoft SQL Server Management Studio. These column properties don't seem to be exposed in the table designer. At least I can't find them...

Ian

Re: How to setup a column to auto-increment

shm5314-Mar-06 7:23

14-Mar-06 7:23

You caqn not have more that one identity column per table. The way to handle what you are attempting may be to insert the new record, get the identity using the SCOPE_IDENTITY() function then updating the record with that value

ROLLBACK TRANSACTION

Brendan Vogt8-Mar-06 2:58

8-Mar-06 2:58

If I have 2 INSERT statements in my stored procedure, one to add a member to the member table, and one to add the member's role to the MemberInRoles tables.

Let say the second INSERT fails, and I do a ROLLBACK TRANSACTION, will it remove the row added in the first INSERT statement?

How far does ROLLBACK TRANSACTION go? Will it reverse everything?

Colin Angus Mackay8-Mar-06 3:08

Colin Angus Mackay

8-Mar-06 3:08

ma se wrote:
will it remove the row added in the first INSERT statement?

It depends where you put the BEGIN TRANSACTION

ma se wrote:
How far does ROLLBACK TRANSACTION go?

Back to where you put BEGIN TRANSACTION.

ma se wrote:
Will it reverse everything?

It will reverse everything on that connection to the point that BEGIN TRANSACTION was called. Other users of the database are unaffected (unless they are reading uncommitted changes [aka dirty read]- in which case they are declaring they realise some of the changes they are reading may not be valid)

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Brendan Vogt8-Mar-06 3:18

8-Mar-06 3:18

Ok thanks!!

When I do a COMMIT TRANSACTION, do I need to do it for both INSERTS, or does using it once commit both INSERTS?

Colin Angus Mackay8-Mar-06 3:20

Colin Angus Mackay

8-Mar-06 3:20

ma se wrote:
When I do a COMMIT TRANSACTION, do I need to do it for both INSERTS, or does using it once commit both INSERTS?

The COMMIT TRANSACTION will commit all changes since the BEGIN TRANSACTION. So, do it once after both inserts.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Brendan Vogt8-Mar-06 3:24

8-Mar-06 3:24

Hey Colin!!

Thanks for all the information, it is greatly appreciated!!

So how long have you been in databases? You probably know everything there is to know on SQL Server. Hows it going with SQL Server 2005? Do you do any other databases?

Cheers.

Colin Angus Mackay8-Mar-06 4:06

Colin Angus Mackay

8-Mar-06 4:06

ma se wrote:
So how long have you been in databases?

Commercially? About 12 years.

ma se wrote:
Hows it going with SQL Server 2005?

I've played with it a little, but I've not had a chance to work with it yet.

ma se wrote:
Do you do any other databases?

To the same level as SQL Server? No. But I do know various other databases, but since I've been using SQL Server almost exclusively for the last 3 years it would take a wee while to pick some of it up again. However, most databases I've used have some varient of SQL so it isn't that hard to go from one to another.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Brendan Vogt8-Mar-06 3:30

8-Mar-06 3:30

I have another question.

I have a stored procedure that inserts the member, and a stored procedure that inserts a roles for that member. So when the member is added successfully, then it calls the other stored procedure passing it the parameters of memberID and roleID.

Now comming back to the COMMIT TRANSACTION and ROLLBACK TRANSACTION. If a ROLLBACK TRANSACTION is done now after this call, will it go and remove that record as well (which was inserted from the call to the "outside" stored procedure)?

toxcct8-Mar-06 6:58

toxcct

8-Mar-06 6:58

i think Colin is the best one to answer SQL questions over CodeProject, but i can give it a try Wink | ;)

transactions can be seen for what you write on the database as an atomic statement. this means that when you begin a transaction, everything you write inside the transaction is actually buffered. when you commit the transaction, the database is physically altered by writing you datas. if you rollback the transaction, everything you did inside the transaction is lost, and the database state (as it was before your transaction) is not modified.

SQL statment

charbelasmar7-Mar-06 22:47

charbelasmar

7-Mar-06 22:47

hi guys

i have question in SQL

select * from user where id='aaa' and pass='hello';

the problem is who can i make it case sensitive
like if in my table AAA exist it's different then aaa how can i select
the exacte word

Regards,
Charbel

Re: SQL statment

cbhkenshin8-Mar-06 0:25

cbhkenshin

8-Mar-06 0:25

hi,

First of all if your user table has an identity column PK so you can get the data by The PK.

Second here is a function that may come in handy

//For small a at the begining

Select * from user<br />
Where ASCII( id ) = 97

//for Big a at the begining

Select * from user<br />
Where ASCII (id ) = 65

ASCII Function:
Returns the ASCII code value of the leftmost character of a character expression.

Re: SQL statment

Michael Potter8-Mar-06 9:19

Michael Potter

8-Mar-06 9:19

Cast them to varbinary:

SELECT
    *
FROM
    user
WHERE
    CAST(id AS VARBINARY(50)) = CAST('aaa' AS VARBINARY(50)) AND
    CAST(pass AS VARBINARY(50)) = CAST('hello' AS VARBINARY(50))

Re: SQL statment

shm5314-Mar-06 7:26