ASHISH SRIVASTAVA

Tuesday 6 December 2016

Copy All tables with Data in Another Database

CREATE PROCEDURE [dbo].[uspCreateCopyTables]-- GOALTEST,GOAL
-- parameters for the stored procedure here
@toDatabase VARCHAR(100)
,@fromDatabase VARCHAR(100)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
SET NOCOUNT ON;
DECLARE @fullTableList VARCHAR(8000);
DECLARE @idx INT;
DECLARE @tableName VARCHAR(8000);
DECLARE @SQLQuery NVARCHAR(500);
DECLARE @ParameterDefinition NVARCHAR(100);
-- this query gives the list of table name existing in the database.
SELECT @fullTableList = ISNULL(@fullTableList + ',' + TABLE_NAME, TABLE_NAME)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';
SELECT @idx = 1
/* this section splits the table name from comma separated string and copies that table name from
one database to another database*/
IF LEN(@fullTableList) > 1
OR @fullTableList IS NOT NULL
WHILE @idx != 0
BEGIN
SET @idx = CHARINDEX(',', @fullTableList)
IF @idx != 0
SET @tableName = LEFT(@fullTableList, @idx - 1)
ELSE
SET @tableName = @fullTableList
IF (LEN(@tableName) > 0)
SET @SQLQuery = 'SELECT * INTO [' + @toDatabase + '].[dbo].[' + @tableName + '] FROM [' + @fromDatabase + '].[dbo].[' + @tableName + ']'
EXEC (@SQLQuery)
SET @fullTableList = RIGHT(@fullTableList, LEN(@fullTableList) - @idx)
IF LEN(@fullTableList) = 0
BREAK
END
END
GO

Tuesday 29 November 2016

SignalR Examples

ChatHUBS.cs

Code

public void Send(string name, string message) {
// Call the broadcastMessage method to update clients.
Clients.All.broadcastMessage(name, message);
}

Startup.cs

public void Configuration(IAppBuilder app)
{
// For more information on how to configure your application, visit http://go.microsoft.com/fwlink/?LinkID=316888
app.MapSignalR();
}

Htmlpage

<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">
.container {
background-color: #99CCFF;
border: thick solid #808080;
padding: 20px;
margin: 20px;
}
</style>
<meta charset="utf-8" /> </head>
<body>
<div class="container"> <input type="text" id="message" /> <input type="button" id="sendmessage" value="Send" /> <input type="hidden" id="displayname" />
<ul id="discussion"></ul>
</div>
<script src="Scripts/jquery-1.6.4.min.js"></script>
<script src="Scripts/jquery.signalR-2.2.1.min.js"></script>
<script src="signalr/hubs"></script>
<script type="text/javascript">
$(function() {
// Declare a proxy to reference the hub.
var chat = $.connection.chatHub;
// Create a function that the hub can call to broadcast messages.
chat.client.broadcastMessage = function(name, message) {
// Html encode display name and message.
var encodedName = $('<div />').text(name).html();
var encodedMsg = $('<div />').text(message).html();
// Add the message to the page.
$('#discussion').append('<li><strong>' + encodedName + '</strong>: ' + encodedMsg + '</li>');
};
// Get the user name and store it to prepend to messages.
$('#displayname').val(prompt('Enter your name:', ''));
// Set initial focus to message input box.
$('#message').focus();
// Start the connection.
$.connection.hub.start().done(function() {
$('#sendmessage').click(function() {
// Call the Send method on the hub.
chat.server.send($('#displayname').val(), $('#message').val());
// Clear text box and reset focus for next comment.
$('#message').val('').focus();
});
});
});
</script>
</body>
</html>

Hub connect check

<script>
$.connection.hub.start().done(function() {
alert("Hub Connected");
}).fail(function() {
alert("Hub error");
});
</script>

Tuesday 6 December 2016

Copy All tables with Data in Another Database

Tuesday 29 November 2016

SignalR Examples

Upload valid file in C#