Viewing 15 posts - 166 through 180 (of 188 total)
First, I'll give 3 little whines...
- You made tables in filegroups different than PRIMARY. If you do this, please create those filegroups beforehand.
- Please add after the DDL all necessary...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 24, 2008 at 4:59 am
I'm afraid there isn't a real sweet piece of code... You can get the data from the syscolumns and sysobjects tables and from this make a cursor or similar loop....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 24, 2008 at 4:06 am
sello Moloto (11/18/2008)
I want to set my database property to return a decimal number when I do division .
e'g select 1/10 should return 0.1 instead of 0
how do I...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 18, 2008 at 9:08 am
Lee Hemmings (11/17/2008)
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 17, 2008 at 8:27 am
timscronin (11/14/2008)
orderid shipto locationid
1 acf fcd
2 ...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 14, 2008 at 8:27 am
milan (11/14/2008)
Could you please help me to move data from one table to another? It's a bit tricky.
a. Table A has 2 colums
1.map 2....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 14, 2008 at 7:59 am
timscronin (11/14/2008)
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 14, 2008 at 7:53 am
I don't think a natural join specifically exists in TSQL... And the only thing I can think of what it could mean is a normal join between 2 tables with...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 11, 2008 at 3:58 pm
Are you trying to say you're looking for another job? Or that the company you work for is just positive by design?
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 10, 2008 at 6:18 am
cindy_sinath (11/9/2008)
Categories where 001, 003, 004 are Tests and 002 are sessions. All these codes exists under one field called...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
November 10, 2008 at 6:07 am
Pooja_prasad (10/29/2008)
I know the above syntax but I got to know that there is an insert...set form also. Or is it that it is present only in MySQL and not...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 29, 2008 at 5:39 am
Pooja_prasad (10/29/2008)
insert into contactinfo
...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 29, 2008 at 5:23 am
Of course your table desc and the actual procedure helps, but for testing and understanding purposes you really should put some sample data into a post, using the guidelines in...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 29, 2008 at 5:17 am
Davroche (10/29/2008)
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 29, 2008 at 5:00 am
Arul Manoj (10/22/2008)
Actually my table has below structure:
RowNumber UserId UserNmae TimeDifferenceInMinutes
1 ...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 23, 2008 at 10:12 am
Viewing 15 posts - 166 through 180 (of 188 total)