Viewing 15 posts - 151 through 165 (of 224 total)
bayudw (7/22/2010)
For example, I have two tables. First, a table for list of accounts. Second, a table for list of account's transactions.
I want to get the...
July 22, 2010 at 4:02 am
Brian, Thanks for the article. I have a question here. I am not gonna post the DDL scripts as I have used your sample tables.
Consider the following statement that you...
July 22, 2010 at 3:37 am
Hmm i see. I agree that it is more readable if you list the columns. In the specific case that you have mentioned, it is always better to list the...
July 21, 2010 at 6:45 am
Mike do you mean to say that the following select statements are not the same?
create table #table(col1 int, col2 int)
select * from #table
select col1, col2 from #table
If so, please explain.
-...
July 20, 2010 at 11:48 pm
hi,i want to select my data from table using where clause.then i want to use if else condition to set the output parameter value as 1 else 0.so that i...
July 20, 2010 at 6:38 am
Hallelujah!!! I was getting a li'l sleepy at work and now - never been more awake. This is a lively thread.
- arjun
July 20, 2010 at 5:28 am
What do you mean by already existing roleid? I believe the user-role association is created in user_role table. So, how can users be assigned roleids before entries are made in...
July 13, 2010 at 1:26 am
Ya right, I was confused there. What I meant was if karthik needs to identify inserted rows and updated rows separately, he needs two columns - Time_of_Creation and Time_of_Updation. And...
June 22, 2010 at 4:40 am
GilaMonster (6/22/2010)
Arjun Sivadasan (6/22/2010)
If you have a timestamp, you can query like 'select * from table where timestamp > dateadd(d,-1,getdate())'
If you're talking about the timestamp data type, it is not...
June 22, 2010 at 4:27 am
Create two columns - Time_of_Creation, Time_of_Updation and fill them accordingly.
- arjun
June 22, 2010 at 4:23 am
Dear karthik, there is no log to do this job. What Gail has mentioned is that if you have an identity column, you can probably query like 'select top 10...
June 22, 2010 at 4:08 am
Lotsa interesting notes here 🙂 My favorite hobby is motorbike or car racing; and yeah I would love to take that for a job. But I think you gotta be...
June 8, 2010 at 6:11 am
rjohal-500813 (6/3/2010)
Raju The Leader (6/2/2010)
Thanks but its is coming error like Convert is failed like that
Did you DECLARE Now and Then as Datetime? You should do, then SET them sooner...
June 8, 2010 at 1:16 am
Try this; it does the trick but it would work only if you have two or less rows for a particular a_id. I would like to add that this is...
June 7, 2010 at 1:49 am
Viewing 15 posts - 151 through 165 (of 224 total)