meta user
network profile
| bio | website | |
|---|---|---|
| location | Kozhikode, India | |
| age | ||
| visits | member for | 2 years, 3 months |
| seen | Oct 11 '12 at 8:19 | |
| stats | profile views | 7 |
|
Oct 11 |
comment |
Select query according to date it worked!! thanks a lot.. |
|
Oct 11 |
accepted | Select query according to date |
|
Oct 10 |
asked | Select query according to date |
|
Apr 17 |
awarded | Commentator |
|
Apr 17 |
comment |
Select total number of records from common table expression yes, thats right , i tried it.. i am searching for any other method |
|
Apr 17 |
asked | Select total number of records from common table expression |
|
Apr 16 |
comment |
Manage select results in sql Thank you.. Actually how we can implement paging of selected results is not my question. |
|
Apr 16 |
comment |
Manage select results in sql Thank you.. Actually we need to get the result set according to the page number and me used the second approach. But all the procedures written previously uses the first approach and i don't know why they go for the first method. Thats why i posted it, to know whether the first got any performance advantage over second. |
|
Apr 13 |
accepted | What is the use of creating full text catalog in full text indexing |
|
Apr 13 |
asked | What is the use of creating full text catalog in full text indexing |
|
Apr 13 |
accepted | Manage select results in sql |
|
Apr 13 |
comment |
Manage select results in sql @DForck42 : to select a specified number of records according to page number to show in the front end.. |
|
Apr 12 |
asked | Manage select results in sql |
|
Apr 10 |
comment |
Changing ANSI_NULLS setting on a table Similarly there are some foreign key constraints on other table with the primary key on this table. So there is showing an error like we can't do 'ALTER SWITCH TO'. So in this case i think we have to manually drop those constraints and after creating the new table, create these constraints. Is there any other way to do these things. |
|
Apr 10 |
comment |
Changing ANSI_NULLS setting on a table I am creating the new table by using the script table as option in SSMS for the particular table. In that case the name of constraints like primary key and foreign key needs to be changed manually. Is any other opton to get rid off this manual editing.. |
|
Apr 9 |
comment |
Changing ANSI_NULLS setting on a table we have got around 100 tables, So we have to do this thing for all the tables. Is there any option to do it more simply like in any one step configuration or any method to automate this thing..:) |
|
Apr 9 |
comment |
Changing ANSI_NULLS setting on a table thank you very much... working perfectly.. |
|
Apr 9 |
awarded | Scholar |
|
Apr 9 |
accepted | Changing ANSI_NULLS setting on a table |
|
Apr 9 |
awarded | Supporter |
