To get a list of the columns in a specific table: declare @TableName varchar(150) -- select sc.* from syscolumns sc inner join sysobjects so on so.id = sc.id inner join sysindexes si on si.id = so.id where si.indid < 2 and so.type = 'u' and si.name = @TableName
2003-07-25
We've seen this happen a couple times on joins to derived tables, but never seen it happen from two permanent tables with an inner join. This code looks like it was transplanted from MS Access. Is that correct? If so, sometimes there can be errors in the transfer from Jet to T-SQL. It may be […]
2003-07-25
1 reads
Hi I see three alternatives depending on your requirements on speed/data-integrity. Alternative 1. If you are using MSSQL2K then you could create a user defined function to strip leading zeroes. (See BOL on how to create functions.) SELECT ... FROM TableA a LEFT JOIN TableB b on dbo.fn_stripZeroes(a.column) = b.column This method will suffer in […]
2003-07-25
Hi Carknee, quote: The records look like this in one table 00123 and 123 in the other. However, there are a few instance where it is 00123ed of 123ed. Therefore CASTing them to int will not work for all records. is it coincidence in your example that in both case you use 'ed' or is […]
2003-07-25
Well, It looks like it is doing a full count of all permissions on login. If they only have select, it's better. If I through them in datareader or datawriter, thr problem goes away. Also, the owner doesn't have the problem. I'm not very good with Profiler, but the trace I ran looks like it […]
2003-07-25
1 reads
At least this install is an automated package like the re-release on ms02-061. No more manually coping files.
2003-07-24
This is the stored procedure that inserts the new entry into tableA CREATE PROCEDURE [dbo].[mmap_sp_Insert_OutgoingMessages] @inp_SendDateTime AS DATETIME = NULL, @inp_Sender AS NVARCHAR(30) = NULL, @inp_MessageText AS NTEXT = NULL, @inp_Status AS INTEGER = NULL, @inp_DateTimeSent AS DATETIME = NULL, @out_MessageId AS INTEGER OUTPUT AS INSERT INTO TableA ( SendDateTime, Sender, MessageText, Status, DateTimeSent) VALUES […]
2003-07-23
2 reads
If your source-db is in simple-recovery-mode (yes, some vendors still recommend this for their apps), you can forget log-shipping and the only option left is backup/restore if you want the full db. (put the destination-db in read-only to avoid accidental updates)
2003-07-09
You can take a look at Microsoft's site. They have a book on Securing Windows 2000 Server. I'll be talking about the basic services you need in a later security article, but I haven't gotten it written yet in a suitable format. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance […]
2003-07-02
I'm view the Question of the Day like an Open Book Test. It only takes a few minutes to find the answer to the questions and I always seem to run across things that are new to me or help clear things up. The Question of the Day is a great idea for your site.
2003-06-26
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