i think you'll have to move the logic to an ON INSERT trigger, ;

this might be a little tricky, considering that a trigger needs to assume multiple rows might exist....

say...

I agree with Barry; still waiting to hear why an Identity() column, or varchar based off of an identity, or a GUID won't do the job.

for views,procedures,functions (and triggers) you could use a cursor to exec sp_helptext [objectname]

that would give you the script for those objects, assuming they were not marked WITH ENCRYPTION when they...

harish_ravi (1/20/2009)

---

is it possible to call a user define function in SQL Server from asp.net page (, just like we call a stored procedure from asp.net page) ???

if so please...

the ISNULL function substitutes a value in place of the variable or column if it is null:

SELECT ISNULL(@Variable1,0.00) - ISNULL(@Variable2,0.00)

two things to consider....

if you are going to delete the records after archiving them off to another table, consider doing it in batches....if you do too many rows at a...

hopefully, this is not homework, because if you submit this as your answer, and can't explain what it does, you'll get burned.

FOR XML has a neat way of getting values...

i suspect it has something to do with being loos-goosy on your varbinary and varchar sizes:

DECLARE @prize_encrypt VARBINARY(256)

Set @prize_encrypt = EncryptByPassphrase(@pass,Cast(@prize_id as varbinary))

you try to use a varbinary(256 in one...

don't crosspost. you only need to ask once, the Newest Posts feature lets us see everything. asking the same question multiple places wastes posters time and fractures the continuity of...

don't crosspost. you only need to ask once, the Newest Posts feature lets us see everything. asking the same question multiple places wastes posters time and fractures the continuity of...

if this only happened once, i'd lean towards a minor intermittent network error:[DBNETLIB][ConnectionWrite (send()).]General network error.

if it's happening everytime or a lot, then

I found a lot of really good information...

in general, you'll see two ways to do this.

you can use a

SELECT * FROM TABLE1 WHERE [Client ID] in (SELECT [Client ID] FROM TABLE2 WHERE Trading_Code IN('ZBwhatever') )

or you...

i misread the original post;

here's a sample from my snippets where someone wanted a unique alphanumeric, in order, ie AAA001 thru ZZZ999;

the nubmer gets generated based on an identity.you could...

how about an Identity using a bigint column that starts with the first 16 digit number ?

create table #example( bigintID bigint identity(1000000000000000,1) primary key,

morestuff varchar(30) )

also why must it be...

remember SQL encryption is not all that strong, even in 2005, a simple Google search will allow anyone that can run a TSQL script see the un-encrypted text of something...