174 reputation
5
bio website
location Kozhikode, India
age
visits member for 3 years, 1 month
seen Nov 19 '13 at 6:05

Nov
18
awarded  Popular Question
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