Quarter Pie Interactive on ‘SQL Server’
Copy Table and Data Across SQL Server Tables
One of my recent projects needed some tables to be moved to a new database from another existing database. The only way I knew its possible is using the Import/Export wizard from the days of SQL Server 2007. Now this server has SQL Server Express Edition which comes with SQL Server Management Studio Express so I had to do it by queries as there was no Wizard for help. The SQL I found to move MS SQL database tables across databases on same server worked and it was as below SELECT * INTO destinationdbname.dbo.tblUsers FROM sourcedbnamecrm.dbo.tblUsers This worked but however it did not ...
» continue readingCustom CRM Solution
ICO Commercial needed a CRM solution to keep their agents and managers updated about every action that happens in the leads they get for different types of services they provide. We built this system very quickly and cost-effectively based on ASP and SQL Server which has login for administrator, managers and agents and they can post update for any action that happens on a lead and everyone concerned with that particular customer is immediately updated. There are various CRM related reports available in the management area.
» continue reading