| Recent Answers from Jwalant Natvarlal Soneji |
 |
2008-08-29 SQL qn: Dear Dante, I would surely try to answer the question, but please state clearly that which tables you want to merge and what is the final output expected. Also, the columns name shown in the sample code...
|
2008-08-18 triggers: Dear Oliver, You can create trigger on insert or update to update the result value in the records being inserted/updated. The query can be done using CASE keyword. For example: To update value of result...
|
2008-08-12 How to retrieve only the date part: Dear R. J. Premnath, The datepart is the in-built function that can be used to retrieve the part of the supplied date. The part can be day, month or year or even a time related item like seconds, milliseconds...
|
2008-08-08 Setting up a local server with SQL Server Management 2005: Dear Chris, Please use the SQL Authentication instead of Windows Authentication. This will allow you to enter credentials of your user in the database. If it does not workout then please list down...
|
2008-08-01 MSSQL Rep. Services - Custom Database: Dear Mazen, I have a little reporting services exposure, however regarding storing the the layout and customization in database can be done. For this thing to work, you may have to use the asp.net/html...
|
| More Answers for "MS SQL Server" |