User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 402,488 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,841 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
•
•
•
•
Showing results 1 to 7 of 7
Search took 0.01 seconds. Posts Made By: itsdavetime
Save these search results for 24 hours
Forum: MS SQL Sep 21st, 2006
Replies: 4
Views: 5,713
Posted By itsdavetime
Re: Insert Into Syntax Problem

You're not substituting Me.classname.UserID as a variable. You're passing it in the code as a value itself.
Forum: MS SQL Sep 19th, 2006
Replies: 1
Views: 2,600
Posted By itsdavetime
Re: connection problem via driver

I really have never heard of that driver nor understand what you're trying to do.
The question is though, why are you connecting to port 1279? Did you change the port number in the server network...
Forum: MS SQL Sep 1st, 2006
Replies: 4
Views: 3,286
Posted By itsdavetime
Re: Column Aliases

I don't believe there is a way to store a column alias with a table. If you really need to do this, I'd suggest creating a table of aliases which relate back to the original column and table name. ...
Forum: MS SQL Sep 1st, 2006
Replies: 1
Views: 3,129
Posted By itsdavetime
Re: Drop User In Mssql

You can't drop a user if they are currently logged in. Do an sp_who to find the SPID's the user is logged in with, and kill those spid's. Then drop the user.
Forum: MS SQL Sep 1st, 2006
Replies: 3
Views: 6,740
Posted By itsdavetime
Re: Accesing tables rows in Stored procedure without using cursors

Just to a while loop.

declare @rowcount int,
@counter int
select @rowcount = (select count(*) from table_name)

set @counter = 0
while @counter <= @rowcount
begin
select * from...
Forum: MS SQL Sep 1st, 2006
Replies: 4
Views: 3,286
Posted By itsdavetime
Re: Column Aliases

Not sure what you mean when you ask if you can store the column alias when you create the table. A column alias can be assigned when you perofrm a query on the table.
Forum: MS SQL Aug 21st, 2006
Replies: 1
Views: 3,726
Posted By itsdavetime
Re: datetime/ i need only date

select convert(mydatecolumn,varchar(15),101)
Showing results 1 to 7 of 7

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 4:53 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC