Programming SQL

How do i add Pubs database to Sql server 2005
Hi there, I just want to play with Pubs data base that is available in Management Studio and apply all the enhancements of T-SQL in SQL '05. How would i install the PUBs and Northwind databases to the Management Studio databases? Thanks -D ... 15 Feb 2006 11:50

ALTER Table
I am trying to use the ALTER table Alter column command to set the default value of a column and to drop the default value of a column. can anyone pls give me the syntax.I tried the one given in sql help file but gives me a syntax error. thanks! ... 13 Feb 2006 18:04

Cursor Operation Conflict
I keep getting a cursor operation conflict when calling the "Update" method of a recordsetup object using VB6 with a SQL Server 2000 DB. I have 0 "INSTEAD OF" triggers in the database, my user options are set to 0. I am running MDAC 2.81.117.0 on a Win XP SP2 machine against a Win 2003 Server with SQL Server ... 14 Feb 2006 17:02

While loop
I have a stored procedure that inserts records into a table. Currently my code looks something like this: CREATE PROCEDURE sp_FinancialReport <init variables here> EXEC sp_myproc @lLocationID, @sFrom1Date, 'Visa', 'Visa', 'SALE' EXEC sp_myproc @lLocationID, @sFrom1Date, 'MC', 'MC', 'SALE' EXEC sp_myproc @lL... 13 Feb 2006 15:58

Having trouble w/ Decimal field
Hi, I have a decimal field with precision 3 and scale 1. This field will have values ranging from 0.5 to 10. When enter new values into the table using the following stored procedure, my decimal values get rounded up. If I enter values directly into the table, everything is fine. Do I need to define the pre... 11 Feb 2006 01:35

Guaranteed consecutive identity values
If I do a INSERT INTO <table> SELECT ... and <table> has an identity column with an increment equal to 1, does SQL/Server 2000 and/or SQL/Server 2005 guarantee that the identity values generated for a single successful INSERT of this type will be consecutive. So if I do an INSERT INTO ... SELECT which inserts,... 10 Feb 2006 15:46

VB Script
Hi , I am try to write a rename file using vb script and use it on the DTS package but I am not sure what is the proper command .. can someone help ? -- Travis Tan ... 10 Feb 2006 02:39

Misunderstood INSERT when using CASE on ORDER BY
Hi Group, In the script below, the commented lines, when uncommented, produce: "An explicit value for the identity column in table '#dest' can only be specified when a column list is used and IDENTITY_INSERT is ON." Can anyone explain to me why it is only when I use a CASE statement for my orderby that SQL S... 9 Feb 2006 18:24

Copying data between databases with different collations
I have written a system which I now want to intergrate to some degree with with Syspro accounting software, both run off MS SQL databases on the same server. I am writing a trigger on the syspro database, I need to join across the 2 DBs, each have different collations When I try: Insert INTO DB1.dbo.Table1 ... 9 Feb 2006 09:29

Need some assistance
Hi, I am importing some phone numbers from a lagacy system and I find some of them having the following exeptions: 1. 2122121222 2. 212 212 2122 3. 212/212 2122 4. 212/2122122 5. 212.212 2122 6. 212.2122122 7. 212.212.2122 8. 212-212-2122 9. (212) 212-2122 10. 212-2122122 11. (212)-212-2122 12. TEXT 1... 8 Feb 2006 19:55