Thanks Frank. I think you've got it but let me make sure. You're saying create the 'Create Table' statement dynamically by adding a field, (@tname) to the 'Create Table' statement during my loop then execute (@stmt) it at the end? I'm fairly new to SQL and still figuring out the syntax, what does the N […]
2003-07-24
You can also customize the toolbar to run applications like Notepad. I did this for Textpad. Didn't mention this before 'cause I didn't think that was what you were looking for. From MSDN: To add commands to the Tools menu 1. On the Tools menu, click Customize. 2. In the Customize dialog box, click the […]
2003-07-12
I would definently bring this to their attention. Seems like a waste if they don't help you with their solution or take your findings into account. Otherwise sounds like a real pickle.
2003-07-11
1 reads
2003-07-09
quote: Hi Markus, quote: I know the forum has a little bit of this on the XML section, but maybe a section devoted to ASP would be handy. I had a few questions on some HTML code that needs to interact with my DB . post it to this forum. I've tried posting some VB, […]
2003-06-26
Your DBA dropped PUBS on your DEV box? Bit over-zealous isn't he/she? I can understand and agree in production, but pubs and northwind can be very handy in dev/test environments. Hope these results post ok... select * from authors a where NOT EXISTS (select * from titleauthor ta where ta.au_id = a.au_id) (3 row(s) affected) […]
2003-06-24
They track that (at least they did for my MCSE) and will send you your cert pretty quickly. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
1 reads
I completed it again. I liked the SQL Server hat and my son won't give it up. Now, what will probably happen is my 4 year-old will see it and want it and I'll be back to the Veritas hat. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-05
Narrie, Try: . . EXEC @hr = sp_OASetProperty @MailID, 'To', @To -- Add the attachment file EXEC @hr = sp_OAMethod @MailID, 'AddAttachment', NULL, 'InsertAttachmentPath&FileNameHere' EXEC @hr = sp_OAMethod @MailID, 'Send', NULL EXEC @hr = sp_OADestroy @MailID
2003-06-04
1 reads
Since the DBs are very small you can either use DTS or Backup/Restore and take care the users part. Here is a good article on moving 7.0 to 2000 http://sqlteam.com/item.asp?ItemID=9066 Edited by - Shas3 on 05/29/2003 2:59:04 PM Edited by - Shas3 on 05/29/2003 2:59:39 PM
2003-05-29
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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