I'm a little confused by the terminology of the question. As written above to actually return the value of intcount to a process outside the statement a third statement would be needed: select intcount from table1 where loc = 'A' after it has been updated.The statementupdate table1 set intcount= intcount +1 where loc='A'will increment the value of intcount by […]
2004-06-21
This SQL statementSELECT MAX(DISTINCT ProductVersion) AS New, ProductType, ProductDesc, CAST(ProductLogo AS varbinary) FROM eProducts GROUP BY ProductType, ProductDesc, ProductLogo gives me this errorServer: Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.How can I retrieve […]
2004-06-17
2 reads
Itzik Ben-Gan wrote the best series of articles for this in SQL Magazine www.sqlmag.com. They were great.
2004-06-17
1 reads
Hi,You can use @@IDENTITY to obtain the inserted ID value: INSERT INTO MASTERTABLE(val1,val2)Values('hello','world')declare @MyID intSelect @MyID = @@IDENTITYINSERT INTO CHILDTABLE(ForeignKey,val1)Values(@MyID,'value') Good Luck
2004-05-20
- use decimal[(p[, s])] check BOL in stead of float.- check constaints can help to delimit values : from BOL : ALTER TABLE doc_exd ADD CONSTRAINT exd_check CHECK (column_a between -99 and +99) alter table dox_exd ADD CONSTRAINT exd_check_precision CHECK (case column_a - cast(column_a as integer) when 0 then 1 when 0.5 […]
2004-04-20
I'm a bit confused by your post. Are you saying you've passed a SQL Server exam, but have no real-world experience with the product?
2004-04-12
When you create a temporary table it is in scope for either the duration of the batch (Local Temporary Table) or for the duration of the connection (Global Temporary Table.)A Local Temporary Table is identified by a single pound sign (#TempTable). A Global Temporary Table is identified by a double pound sign (##TempTable).Since dynamic SQL […]
2004-03-03
Discover the script section here. There are several scripts for finding duplicates.
2004-03-02
I'm trying to build a procedure to search all stored procedures in the Db for a text string. What tables contain the text of the procedures and how to construct it. I get sysobject name but it doesn't have the text. Any assistance would be appreciated.
2004-02-26
6 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-23
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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