RE: Numbering the ResultSet - Equivalent of Rownum
Do you test it on 1000000 row??? I have slow perfomance...
2003-07-21
1 reads
CTE
RE: HELP!! why one of these DELETEs does not work??
hi bond007, thanks for reply; well the issue is that the original was exactly what you did propose to change this to, I suspected that issue is the conversio, hence the explicit cast/convert function, but you're right it is unnecessary since declare takes care of that, I just wanted to be sure; there are not […]
2003-07-17
1 reads
RE: Preventing MSAccess Connections
How can you use app role to control access from MS Access? Anyone who has done it before or knows how it can be done should please explain. Thanks.
2003-07-14
RE: Check contraint
This will work a little better: USE TEMPDB BEGIN TRAN GO CREATE TABLE MY_TABLE( THE_VALUE_A CHAR(1), THE_VALUE_B CHAR(1), CONSTRAINT CHK_A_AND_B CHECK (NOT(THE_VALUE_A IS NOT NULL AND THE_VALUE_B IS NULL))) GO /* insert ok */ INSERT INTO MY_TABLE VALUES('A','B'); GO /* insert not ok */ INSERT INTO MY_TABLE VALUES('A',NULL); GO /* insert ok */ INSERT INTO […]
2003-07-08
RE: Find second highest
I don't think there are any problems with @@rowcount, but I would consider using min/max to get the row you want rather than top.
2003-07-08
2 reads
RE: Web services, sql 2000 - without .net?
Hi there Yep, its called "SQL Server Web Services", its basically an IIS ISAPI extension + UI that allows you to very quickly create webservers (soap or not) from db stored procs. YOu can also hook in templates, return straight record sets etc. It is quick and easy to use. Search on MSDN for it. […]
2003-07-07
RE: Joining surrogate table entries into single field
I would see two ways of doing this - both involve a temporary table. Let's create the table as create table #comCity ( seqNo int, cityList varchar(2000), lastseq int ) Option 1 insert into #comCity select t1.seqNo, t2.location, t2.seqorder from table1 t1 (nolock) inner join table2 t2 (nolock) on t2.seqNo = t1.seqNo and t2.seqorder = […]
2003-07-07
1 reads
RE: Database Compare
quote: There are many SQL server Schema Comparision Utilities available in market. AdeptSQL (http://www.adeptsql.com) is one such a utility Thanks JGK I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ? Thanx in advance. Prateek.
2003-07-07
2 reads
RE: Triggers
There are only two table variables used in all trigger statements: the deleted table and the inserted table - there is no Updated (checkout BOL:"Using the inserted and deleted Tables"). So, in this case, you could perform an update on your log table using the rows in the inserted table for all rows in the […]
2003-07-04
RE: Triggers
I would try: Update LT Set LT.FileCreatedDateTime = Updated.FileCreatedDateTime, LT.FileType = Updated.FileType, LT.SourceFileName = Updated.SourceFileName FROM Updated inner join ImageCostFileImportLog LT on LT.RecordId = Updated.RecordId The advantage of this is it still works if you update the data table with a batch query, your method will only work if you update one record at a […]
2003-07-03
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers