Home > Database > MS SQL Server (Page 3)

SQL SERVER – List all the database

EXEC sp_databasesEXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005SELECT nameFROM sys.databasesSELECT nameFROM sys.sysdatabases ----SQL SERVER Un-Documented ProcedureEXEC sp_msForEachDB 'PRINT ''?'''

This Article is TAGGED in , , , , . Read more

How to get notification from database when any transaction on records?

Technologies Used: Visual Studio 2013 Express Sql Server 2008 R2 Express MVC 5 Nuget SqlDependency MSDN SignalR 2.0.1 Nuget Jquery 2.0.3 Nuget Toast Notifications Script to Create Broker & Service: create a user called "GeneralUser" with a password of "dbpassword" in your SQl Server logins. Run the following script in a Sql query pane, to create a message broker\service for

This Article is TAGGED in , , , , , , . Read more

How to import data from MS Excel

If you have data in excel and you want to add data in you database using C# this is useful example. Follow below steps: Step 1: Create database tables to import data [crayon-66068b51d8f8f287681854/] Step 2: Add below namespaces in your project [crayon-66068b51d8f97084906847/] Step 3:  Add below method and send file path to this method as parameters. [crayon-66068b51d8f9b886014062/]  This method get file path

This Article is TAGGED in , , , , . Read more