I'm having some problems writing a SP to do some reporting on a table. I need to count the number of rows that meet one criteria and count the number of rows that meet another criteria (which is mutually exclusive from the other) and return each as a different column. I apologize for being so […]
2001-08-06
2 reads
I know this _may_ not be the right place for this topic but there isn't really any other place for it at this time. I was wondering what other user groups exist besides the north texas group. I have also seen groups in Austin but they tend to come and go. I'm looking for other […]
2001-08-06
A recursive or tree style table is a table which could have a Foreign key to itself. In my situation I have a product categories table. The one below: TB_Categories ---------------- catId INT IDENTITY catParentId INT catName nvarchar(50) Let us suppose that it has the following data TB_Categories ------------------------------------------------ catId |catParentId |catName ------------------------------------------------ 1 |0 […]
2001-08-03
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
How do i connect to a named instance of sql server over the internet using a IP i tried a combination of the IP/[instance name] the IP:Server Port Any ideas
2001-08-02
6 reads
What about it? I have some that would be of interest to others I believe, buty dont feel at using the forum for it is appropriate. Cheers Chris
2001-08-02
2 reads
How do you get the object_id of a table or any objeect on another server dynamically ? I have tried : select object_id("@servername.@dbname.dbo.attendance_details") It returns NULL. When i try to get the id without the use of variables ie. select object_id("servername.dbname.dbo.attendance_details") The query still returns NULL. I am executing it in a query in a […]
2001-08-02
7 reads
hi, I am using sel server6.5.I have to output records into a flat file on update trigger. without using xp_cmdshell is there a way to output records into flatfile thanks in advance
2001-08-01
3 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp
2001-07-31
3 reads
Hi all, What is the backup file format for a full-backup. When I give a filename for backing up using the backup wizard, should I give an extension like .bak etc. Because, I found that the backup which I make, has no extension. Kindly clarify Cheers Parasu Parasu Raman
2001-07-27
3 reads
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