Viewing 15 posts - 3,046 through 3,060 (of 3,221 total)
Congratulations to both
As stated previously
I know that every time that I read one of Jeff's articles, I am probably going to learn something that helps me in my job!
Let...
July 2, 2008 at 7:45 am
Using Query Analyzer
ALTER TABLE testing1 DROP COLUMN Cid
GO
ALTER TABLE testing1 ADD Cid INT IDENTITY (1,3) NOT NULL
GO
July 2, 2008 at 6:28 am
Jeff as usual you are CORRECT ... I must have gotten carried away reading all these posts ... tell me one thing what the heck is RTFS and if...
July 1, 2008 at 5:53 pm
In the master database. Look at sp_msforeachtable
for an explanation of what and how it works try
http://www.databasejournal.com/features/mssql/article.php/3441031
July 1, 2008 at 11:01 am
I am facing this error frequently in the application my data base in Sql Server 2000 any solution please provide me at the earliest
What error?
Please read the article whose...
July 1, 2008 at 10:45 am
Suggest you read "Trouble Shooting Metadata Visibility"
http://msdn2.microsoft.com/en-us/library/ms190785.aspx
scroll to the bottom of the page and review:
"Metadata Visibility Configuration"
http://msdn.microsoft.com/en-us/library/ms187113.aspx
Plus search this site for many, many articles discussing injection attacks, and how to...
July 1, 2008 at 10:29 am
per rbarryyoung:
Except that that is NOT what was wanted. What was wanted was:
Eliminate One row from each distinct Group.
With the Following restrictions:
...
July 1, 2008 at 10:13 am
You could using SSMS
a). In design mode drop the column cID
b). Save the table
c). Go back into design mode insert a new column named cID
d). Set...
July 1, 2008 at 8:06 am
May I suggest using BOL subject "Using Pivot and Unpivot" or url:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm
June 30, 2008 at 1:25 pm
If I understand you correctly the following T-SQL should do what you want:
Insert INTO tbl_trans(code,no,name,amount)
SELECT code, no, name, amount FROM tbl_application ORDER BY no
June 29, 2008 at 9:04 am
From Jeff Moden's post:
you're going to spend that much time on it... write it as an article and submit it, instead.
...
People really get ticked at me when I say...
June 28, 2008 at 12:37 pm
We have a client that has approximately 150 employees that check in with us each day, 3 times a day, to ensure their safety
Strictly an assumption on my part but...
June 28, 2008 at 11:35 am
Although this sounds like a home work question. Start here:
1. Open your .net interface
2. Click on Help
3. Enter ADO in help search window
4. Read the...
June 28, 2008 at 10:50 am
The lack of information provided makes it highly unlikely you will get help for your question. Please follow the link in my signature and re-post
June 28, 2008 at 8:20 am
Insufficient information -- Do you mean convert a possible 3 characters (clnt_access varchar(3) NOT NULL) to binary, since a bit can only be a 1 or 0, or to binary?
(BOL...
June 27, 2008 at 5:27 pm
Viewing 15 posts - 3,046 through 3,060 (of 3,221 total)