2003-08-04
security
RE: SQL
quote: Hello Mark I tried with another query which is as follows SELECT TOP 5 * FROM table However I am not getting the lowest 5. I tried with bottom, but it's not working what about ORDER BY salary (DESC) ? Cheers, Frank
2003-08-04
RE: SQL
Hello Mark I tried with another query which is as follows SELECT TOP 5 * FROM table However I am not getting the lowest 5. I tried with bottom, but it's not working Thanks, Jacobe
2003-08-04
RE: 1st SELECT after INSERT
Hi Andy, Yeah, yeah. The app shouldn't be inserting the data and then immediately retrieving it. But that's an app problem to be solved another day. Nonetheless, Here are some timings using the MSSQL profiler. Created the business entity, then fetched the business entity for the 1st time after the inserts (1900ms). Fetch the business […]
2003-08-02
1 reads
RE: Replication failure
MSrepl columns are added by replication, the problem is that it in this case the publisher doesn't expect to be inserting a value into that column. This happened because you did the restore rather than a snapshot. Delete the column from the subscriber and see what happens. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-02
RE: A function like "IS_MEMBER" ?
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!
2003-08-01
RE: Crystal Reports......
Depends on your version of Crystal but yes you can set the query via code to any valid SQL syntax for the connection object you are using. I always make my connections ADO in Crystal and at runtime I submit the proper SQL string to process the data (remember thou you have to provide the […]
2003-08-01
Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses
Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.
2003-08-01
15,714 reads
RE: how to SELECT 'unassigned' elements
Here's one way... select Counter from (SELECT DISTINCT storeNumber FROM tblStore) storeNumbers RIGHT OUTER JOIN ( select n1*10 + n2 + 1 [Counter] from (select 0 [n1] union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) list1 […]
2003-07-31
1 reads
RE: Triggers and INSERTED
quote: This error happens when more than one record is in the Inserted table. This can easily happen on an Update trigger. Oh, I understand this. But this error is returned when I'm changing a single record in a grid, the grid in Enterprise Manager precisely. Logically, the INSERTED table should only contain a single […]
2003-07-31
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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