Forum: Microsoft SQL / MS SQL Server

How would I create a system table or stored procedure?

I have a website with some asp pages running off of a MS Sql db. For reasons that I can't explain, whenever querying the database with a SELECT...

Jane, If you have a unique identifier within each group, e.g., col2 in the following schema: CREATE TABLE T1 ( col1 CHAR(1) NOT NULL, col2...

I have a trigger (code below). Where do I put in IF statements to kick off the CASE? I put in a commented out example of the IF I want to do in...

I would greatly appreciate some help, or a point in the right direction, please. I am new to MS SQL Server administration, and specifically...

Can it have dependences without a relationship among the tables?

Howdy, Is it possible to use a table located in one SQL database in another database? I have two databases, DB1 & DB2 DB1 has a table named...

I have a query running inside of Coldfusion webpage. query blah cfoutput query blah { query another_blah { cfoutput another_blah

How can I use Visual Basic to view the SQL built into a query? I have two databases in SQL Server. One is on a SQL 7 production server, and the...

Tom, I did a profiler trace and all I could see was that the stored procedure within the cursor was called 62 times. I dont know what the...

Where can we find the index (list) of all the Microsoft KnowledgeBase Articles (KB Articles)on SQL Server 2000. Under the "Search Knowledge Base"...

How do I reposition a column through SQL (Without using enterprice manager). In a table I have a column ServiceID at column number 5, How do I...

Dear Friends My company have started a new office in another City which will work as a backoffice for our comany. Hence we need that all the...

Dear Friedns We have purchase a new office which is in another city and far away from our office. We want to make the same as our back-office or...

Does anybody have a suggestion for the best way to send email from a trigger? Is it even possible? I'd like to send a notification everytime a...

select foo1.myid, foo1.MyDate, MAX(foo2.subDate) from foo1 join foo2 on foo1.myid = foo2.myid where foo1.MyDate in ( foo2.subDate ,...

Hi, all. Is anybody currently using a web-based tool to add/edit/delete records to SQL Server 2000 tables? I've been writing my own ADO.NET &...

i am using sql 2k. as far as i know, in previous versions doing a select... into could cause blocks in sysobjects and maybe on syscomments,...

Hi, Is there a way to select all user tables? For example, I created 5 tables. In SQL analyer, I want to select table name and strutures of tables...

I am looking for some sample code to use global variables/parameters to replace the hard-coded idetifiers in the stored procefures/DDLs where...