I get the same error, can't find in BOL why the syntax error. Anyway, what about this: -- First add an identity column... ALTER TABLE MyTable ADD MyNewIdentityColumn INT NOT NULL IDENTITY(1,1) GO -- Next, throw the old values into the new identity column UPDATE MyTable SET MyNewIdentityColumn = MyOldIntColumn GO -- Next, drop old […]
2003-06-17
Crispin, thanks. Is there any way to return the name of each of these tables, per user? E.g., if user A created a temp table (the longer life type), how would I be able to reference it in a select statement for example? Thanks
2003-06-17
Frank, Never thought about it that way... One question though ... What is the best program : 1. a perfectly written program, written with the best design methodology, with optimal performance, making use of the best technology for the job, taking into account all the pitfalls of the language, having a high degree of readibility […]
2003-06-16
1 reads
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first place. The situation is more one of coming into a place where they keys are generated in this way, but for each table and I […]
2003-05-22
2 reads
create procedure MySP @var varchar(20) = null as if @var = null Select * from news_items else Select * from news_items where division = @var Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-20
Hi 5409045121009, I tried the function you mentioned, and modified it a little so that it gave me the whole string and it worked. CREATE FUNCTION MyStrip1(@v varchar(50)) RETURNS Varchar(50) AS BEGIN Declare @vv Varchar(50) Set @vv=Right(@v,DataLength(@v)) RETURN Left(@vv,DataLength(@vv)) END Problem though is that it is returning it as a varchar value. I need to […]
2003-05-16
SQL Profiler and the Index Tuning Wizard. With SQL Profiler, you can capture long running queries to concentrate on first, or you could do a general capture for feeding the Index Tuning Wizard.
2003-05-15
Not the best, but seems to be working. CREATE VIEW Test as Select DateAdd(hh,2,GetDate()) as TheDate GO CREATE FUNCTION TestDate() Returns @TheTable TABLE ([GETDATE] DateTime) as BEGIN Insert @TheTable Select TheDate From Test RETURN END GO CREATE FUNCTION TestDateII() Returns DateTime BEGIN RETURN (Select [GetDate] from dbo.TestDate()) END GO Select dbo.TestDateII() GO Suspect the overhead […]
2003-05-15
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers