Thank you for the reply, I think scrips are handy to move along servers.
Hi All, I am learning to use CLR coded stored procedures. In a nutshell I have understood that I need to write my code in C# or any other CLR...
Hi Icerni, Hope this script helps you out. Run this script in your database and it will give you out the PrimaryKeyed Table(s),PrimaryKeyColumn(s)...
Hi Icerni,Hope this gives you an insightAccessing Meta Data - System TablesSQL Server stores information about data in system tables. It also...
Thank You Saji.Regards,Surya
Hi All,Well I have recently joined an organization as sql server developer, and I am placed in a project which has got 4 databases, What and how is...
Hi Danny, A quick reply could be, if you are using conditions in the WHERE clause try moving them to the Left Outer join . Try this out and let me...
Hi Danny, Please send me in a basic overview of the table structure so that I could work that out for you. Regards, Surya
Hi Adriaan, Thank You for the quick reply. I tried the way that you have suggestedSELECT .... FROM tbl2 t2 , tbl1 t1 WHERE...
Hi All, I have corrected some basic syntactical mistakes but i am still left with the same syntax error. Here is my corrected code -- I have a...
Hi All, I have a table tbl1 with these columns BodyText (freetext index added to enable search on this column(text datatype) of the table) and...
Separate names with a comma.
