Viewing 15 posts - 2,206 through 2,220 (of 2,894 total)
That would be very bad desing. You should not do it in T-SQL.
As to achieve it you will need to write everything in dynamic SQL for no benefits at...
August 19, 2011 at 10:34 am
I think I've gave you everything you need to code it, but obviously you want solution ha?
After seconds of googling I've found http://wwp.greenwichmeantime.com/time-zone/usa/hawaii/time/
Where you can read that Hawaii Time...
August 19, 2011 at 10:27 am
davidsalazar01 (8/19/2011)
August 19, 2011 at 10:16 am
Where are you going to use these columns and what kind of data will be under them?
If you want to return empty recordset with "columns" to the client application,...
August 19, 2011 at 10:05 am
Usually localisation should be performed on the client and not on the server.
Do you store your datetime in UTC? You will need to use DATEADD function and apply required...
August 19, 2011 at 9:50 am
Column headings where? And what will be displayed under them?
August 19, 2011 at 9:41 am
karthikeyan-444867 (8/19/2011)
is it possible to generate the sequence number without using ROW_NUMBER () ? I mean can i use your method to generate the sequence number based on id, acc....
August 19, 2011 at 9:03 am
karthikeyan-444867 (8/19/2011)
I feel little bit hard to grasp all your points.
what is the relationship between these two combination? could you please explain it?
...
I have compared the performance of your...
August 19, 2011 at 8:27 am
karthikeyan-444867 (8/19/2011)
...But..how you know that we have to use "3" ?
...
You are right it's all to do with binary math and magic of some numbers in binary represented in binary...
August 19, 2011 at 7:11 am
Jeff Moden (8/18/2011)
August 19, 2011 at 4:00 am
Jeff Moden (8/19/2011)
That's because someone made it difficult. See if you understand the following modifications...
Not at all...
It was because someone wanted to turn 1,2,3,4,5,6,7,8,... into 1,2,3,4,1,2,3,4,...
not 0,1,2,3,4,5,6,7,... into 0,1,2,3,4,5,6,7,......
August 19, 2011 at 3:46 am
Wrong syntax - too many brackets and wrong position of comma.
create table xxx
(UserName varchar(256) not null,
DBName varchar(256) not null,
InstanceName varchar(128) not null)
August 18, 2011 at 3:38 am
You are lucky man than J. Celko didn't see you last request, otherwise you would be asked to read his books and learn that you should not do this...
August 18, 2011 at 3:18 am
karthikeyan-444867 (8/18/2011)
yeah..i have also tried the same...Thanks a lot for all your help.is there any way to achieve my requirement without using temporary table/IDENTITY/ROW_NUMBER?
Is any problem with using temporary table/IDENTITY?...
August 18, 2011 at 2:49 am
When you've cleared the file, does search work for other noise words? If not the file you've changed is not the one used by sql server. What I'm trying to...
August 18, 2011 at 2:43 am
Viewing 15 posts - 2,206 through 2,220 (of 2,894 total)