Advertisement
Advertisement
| 06.19.2008 at 03:22PM PDT, ID: 23500727 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: |
ALTER PROCEDURE [dbo].[stU_GetIdentityFieldName]
@tableName varchar(500),
@identityFieldName varchar(500) output
AS
BEGIN
set nocount on
create table #identity (name varchar(1000))
--make sure this isn't a temp table
if @tableName not like '[#]%' begin
exec('
declare @name varchar(100)
declare c cursor for
select name from syscolumns where ID = object_ID(N''[' + @tableName + ']'')
open c
fetch next from c into @name
while @@fetch_status = 0 begin
if (select columnproperty(object_ID(N''[' + @tableName + ']''), @name, ''IsIdentity'')) = 1 insert #identity select @name
fetch next from c into @name
end
close c deallocate c
')
select @identityFieldName = name from #identity
end else begin
--if we have a temp table, we can't find it
print('As of now, we know no way of determining a sure-fire way of finding an identity column on a temporary table.')
end
set nocount off
end
|
