hi, How can I generate a list of table names along with their record counts from a database? Thanks a lot. JJ...more >>

Error handling in TSQL I have the following codes in TSQL to run. I set the last insert statement to have error. But I did not get the rollback tran. What i got is: Here goes the transactions (10 rows) (12 rows) (13 rows) Server: Msg 208, Level 16, State 1, Line 6 Invalid object name ...more >>

'1+0.25' is stored as a string in a variable, say @str. Is there a function to evaluate the expression and return output as 1.25? How to replicate eval() function ,present in vbscript, in SQl server?...more >>

hello, is there a way to create a user function that returns boolean? so that i could use it with, say, NOT, etc? thanks! k ...more >>

Hi, Can anybody tell me what is the best way to insert data from a text file into SQL server database table on a weekly basis with minimal administration? I will be thankful for your cooperation. Rama...more >>

I have SQL Server 2000 with five databases. Three of them were created on a SQL Server 2000 and two of them were upgraded from SQL Server 6.5 I can not create a user defined function on the two databases upgraded from 6.5. I receive a message: Server: Msg 170, Level 15, State 1, Line 1 Lin...more >>

Hi again to all, I'm using Crystal Report as my reporting tool for Visual Basic. I have a problem on how to run the report from my Visual Basic w/o adding them to my project and automatically logging it into SQL Server. As you know, when you develop the report in crystal IDE, you should logge...more >>

Hi, I hv the following query that is returning correct values. However, I want to add one more condition to this query. select b.btdnumber as btdnumber, b.btdtrfno as bbtdtrfno, a.btdtrfno as btdtrfnohidden, a.BtdAcno as BtdAcno, a.BtdCertNo as BtdCertNo, a.BtdShare as BtdShare from shrba...more >>

I have a table that logs people logging into an application. It has these fields: id int 4 (identity) entityID int 4 LoginTime datetime 8 id is just a unique number for each login. entityID is the ID of each person logging in. LoginTime uses dates in the format of: 3/28/2003 12:42:00 P...more >>

HI: does anyone know if s stored proc can execute a DTS package ? if so, the conceptual basics and maybe sample code ? thanks...more >>

I'm trying to set up a table that contains a different field for all of the Primary Keys that will be used in the Tables in a project. The NextID Table may look as follows: ProdID Int CustID Int ReceiveID Int The value for a particular fiel...more >>

When I run these commands: Select * into #Temp1 from Prod Insert into #Temp1 Select * from OldProdI get this Result: Server: Msg 208, Level 16, State 1, Line 121 Invalid object name '#Temp1'. If I highlight the above commands and run them by themselves, it returns the correct result. It seems...more >>

Hi, I have one excel sheet form with more than 10000 records. I need to move these data to multiple tables in SQL 2000. I was wondeing what would be the fastest solution to move this data. I have one master tble with all the identity of other tables and 5 other tables to hold my data. ...more >>

Question: What would be the best way to add carrage returns to a record, and would my method create alot of overhead and wasted space. What would be the best method to minimize overhead and wasted space. Scenario: Server MS SQL 2000 Table name= mitTickets Fields= problem,details, created, l...more >>

I'm designing a web-application (SQL-server). This app will be used by multiple customers, all using their 'own' data. I was just wondering if anyone here had any thoughts on this, I can think of 3 ways to deal with this 1. Create an SQLserver DB for each customer 2. Create a seperate set o...more >>

I'm running Windows XP Professional I'm logged on as an Administrator to Windows I'm Running MSSQLServer 8.0 I start Enterprise Manager I succesfully Create a Database called Sample I successfully Create Table called SampleTable with 3 columns SampleID int identify(1,1) not null, SampleD...more >>

I need help with a SELECT statement. tables are ORDERHEADER, ORDERLINES AND CUSTOMER. An input form will ask for starting and ending item number, starting and ending date, starting and ending zipcode and a customer category. I need to find all the customer names and addresses for any custom...more >>

Can anyone tell me if it is possible to link external data files to an sql server as you can do with an access data base. If so can you please tel me how or point me to instructions as to how I can do this Regards Newman...more >>