Execute this with Precaution
USE YourDataBaseName
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where type = ‘p’
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
exec(‘drop procedure [‘ + @procName+’]’)
fetch next from cur into @procName
end
close cur
deallocate cur
EXEC sp_MSforeachtable @command1 = “DROP TABLE [?]”
Here is the script to count all the number of records on each table on a MSSQL Server:
SELECT sc.name +’.’+ ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,ta.name
ORDER BY SUM(pa.rows) DESC
Hope it helps.
God Bless!
Thanks,
Thomie
Have you ever thought that you want to connect to create an application that can talk via LAN? Then TCP is one of the mode that you can choose one. Here are the codes from MSDN that can help you:
TCPListen – This is used when you want to create a server like application.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Text;
using System.Threading.Tasks;
namespace TCPListen
{
class Program
{
static void Main(string[] args)
{
TcpListener server = null;
try
{
// Set the TcpListener on port 13000.
Int32 port = 13000;
IPAddress localAddr = IPAddress.Parse("127.0.0.1");
// TcpListener server = new TcpListener(port);
server = new TcpListener(localAddr, port);
// Start listening for client requests.
server.Start();
// Buffer for reading data
Byte[] bytes = new Byte[256];
String data = null;
// Enter the listening loop.
while (true)
{
Console.Write("Waiting for a connection... ");
// Perform a blocking call to accept requests.
// You could also user server.AcceptSocket() here.
TcpClient client = server.AcceptTcpClient();
Console.WriteLine("Connected!");
data = null;
// Get a stream object for reading and writing
NetworkStream stream = client.GetStream();
int i;
// Loop to receive all the data sent by the client.
while ((i = stream.Read(bytes, 0, bytes.Length)) != 0)
{
// Translate data bytes to a ASCII string.
data = System.Text.Encoding.ASCII.GetString(bytes, 0, i);
Console.WriteLine("Received: {0}", data);
// Process the data sent by the client.
data = data.ToUpper();
byte[] msg = System.Text.Encoding.ASCII.GetBytes(data);
// Send back a response.
stream.Write(msg, 0, msg.Length);
Console.WriteLine("Sent: {0}", data);
}
// Shutdown and end connection
client.Close();
}
}
catch (SocketException e)
{
Console.WriteLine("SocketException: {0}", e);
}
finally
{
// Stop listening for new clients.
server.Stop();
}
Console.WriteLine("\nHit enter to continue...");
Console.Read();
}
}
}
TCPClient – As the name suggest it will be used to create the client that will connect to our server.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Text;
using System.Threading.Tasks;
namespace TCPListen
{
class Program
{
static void Main(string[] args)
{
TcpListener server = null;
try
{
// Set the TcpListener on port 13000.
Int32 port = 13000;
IPAddress localAddr = IPAddress.Parse("127.0.0.1");
// TcpListener server = new TcpListener(port);
server = new TcpListener(localAddr, port);
// Start listening for client requests.
server.Start();
// Buffer for reading data
Byte[] bytes = new Byte[256];
String data = null;
// Enter the listening loop.
while (true)
{
Console.Write("Waiting for a connection... ");
// Perform a blocking call to accept requests.
// You could also user server.AcceptSocket() here.
TcpClient client = server.AcceptTcpClient();
Console.WriteLine("Connected!");
data = null;
// Get a stream object for reading and writing
NetworkStream stream = client.GetStream();
int i;
// Loop to receive all the data sent by the client.
while ((i = stream.Read(bytes, 0, bytes.Length)) != 0)
{
// Translate data bytes to a ASCII string.
data = System.Text.Encoding.ASCII.GetString(bytes, 0, i);
Console.WriteLine("Received: {0}", data);
// Process the data sent by the client.
data = data.ToUpper();
byte[] msg = System.Text.Encoding.ASCII.GetBytes(data);
// Send back a response.
stream.Write(msg, 0, msg.Length);
Console.WriteLine("Sent: {0}", data);
}
// Shutdown and end connection
client.Close();
}
}
catch (SocketException e)
{
Console.WriteLine("SocketException: {0}", e);
}
finally
{
// Stop listening for new clients.
server.Stop();
}
Console.WriteLine("\nHit enter to continue...");
Console.Read();
}
}
}
God Bless!
Thanks,
Thomie
Hi There,
We are glad to invite you to our first Free service product, OpenCast. OpenCast is an online broadcasting websites that aim to help people broadcast freely and openly. The website is created using ASP.Net MVC, Entity Framework, SignalR, & OpenTok.
Feel Free to register now at http://opencast.info
God Bless!
Thanks,
Thomie
Have you ever wonder how can you get your location height above sea level? We’ll I have been one of those who wonders. Having the knowledge on how high your location is have advantages. One of the most common advantages is the probability of having a flood on your area. So I’ve search the net and found this website. http://www.daftlogic.com/sandbox-google-maps-find-altitude.htm
You just need to find your location using the embeded google map and click. And you will get the height on feet. Thats easy.
If you want to know what is the query corresponding to the change you’ve done to a table (or other object) in designer mode, use Generate Change Script (Table Designer → Generate Change Script… or the very first icon, with a diskette and a script, in Table Designer toolbar) command.
I have been searching for a perfect Auto SMS Sending application that will fit my very need.
Basic Needs
Added Features
Therefore, if your looking for such app I will be recommending Auto SMS Sender by DRC InfoTech. Its free but with adds. The adds may annoy some of you but thinking of the features that it offers, I’ll say that its worthit.
In PHP they are calling coders differently:
Baker when they are using CakePHP. An
How about in ASP .Net? What would they call people who are using WebForms, MVC, or Other MS Products? Would they call MVCaretakers if your using MVC because your taking carefully all the coding so that it is coded separately so that it can be easily tested via Unit Test?
How about you? What would they call it?
PowerMenu is a tiny but powerful application I wrote back in 1998 that adds “Always On Top”, “Transparency” and “Minimize To Tray” to the windows control menu.
Prequisites
Instructions
Hi,
This error, Exception 0xc0000006 (disk error while paging) has occurred, occurred when some improper turning off of your VMWare. In order to fix this you will need to delete the Suspended Session you need to delete or rename the *.vmss file – this is the virtual equivalent of a power-outage in a real machine.
via Source
Thanks,
Thomie
Truncating all tables is not easy by default on MSSQL so I have search the net and found one. Just open up a new query and use the following codes:
Use databaseName
GOEXEC sp_MSForEachTable ‘TRUNCATE TABLE ?’
GO
It will truncate all the tables under the databaseName DB.
God Bless!
Thanks,
Thomie
httpv://www.youtube.com/watch?v=0xwzItqYmII
I Can Only Image – Mercy Me
c/o http://www.elyricsworld.com/i_can_only_imagine_lyrics_mercy_me.html
What it will be like
When I walk
By your side
I can only imagine
What my eyes will see
When your face
Is before me
I can only imagine
[Chorus:]
Surrounded by Your glory, what will my heart feel
Will I dance for you Jesus or in awe of you be still
Will I stand in your presence or to my knees will I fall
Will I sing hallelujah, will I be able to speak at all
I can only imagine
I can only imagine
When that day comes
And I find myself
Standing in the Son
I can only imagine
When all I will do
Is forever
Forever worship You
I can only imagine
[Chorus]
I can only imagine [x2]
I can only imagine
When all I will do
Is forever, forever worship you
Do you have some regular expression that you want to test online? Then this online tool is for you,
First you will fill up the regular expression and then you will be given two textbox to test it. Thats it.
Regular Expression Online Tool
Regular Expression Online Tool Link : http://tools.netshiftmedia.com/regexlibrary/
httpv://www.youtube.com/watch?v=cjhxOv9YDag
Who Am I
c/o https://castingcrowns.com/node/643
Who am I, that the Lord of all the earth
Would care to know my name
Would care to feel my hurt?
Who am I, that the bright and morning star
Would choose to light the way
For my ever wondering heart?
Not because of who I am
But because of what You’ve done
Not because of what I’ve done
But because of who You are
I am a flower quickly fading
Here today and gone tomorrow
A wave tossed in the ocean
A vapor in the wind
Still You hear me when I’m calling
Lord You catch me when I’m falling
And You told me who I am
I am Yours, I am Yours
Who am I, that the eyes that see our sin
Would look on me with love
And watch me rise again?
Who am I, that the voice that calmed the sea
Would call out through the rain
And calm the storm in me?
Not because of who I am
But because what of You’ve done
Not because of what I’ve done
But because of who You are
I am a flower quickly fading
Here today and gone tomorrow
A wave tossed in the ocean
A vapor in the wind
Still You hear me when I’m calling
Lord You catch me when I’m falling
And You told me who I am
I am Yours
Not because of who I am
But because of what You’ve done
Not because of what I’ve done
But because of who You are
I am a flower quickly fading
Here today and gone tomorrow
A wave tossed in the ocean
A vapor in the wind
Still You hear me when I’m calling
Lord You catch me when I’m falling
You told me who I am
I am Yours, I am Yours, I am Yours
Whom shall I fear?
Whom shall I fear?
‘Cause I am Yours, I am Yours
Name: FullCalendar
Description: Most users find developing their own calendar UI not that quite easy but with jQuery FullCalendar you make it easy and fast!
Some of Specifications:
Demo: http://arshaw.com/fullcalendar/
Download: http://arshaw.com/fullcalendar/download/
Check out this video
httpv://www.youtube.com/watch?v=bdhFdeNCe1g&playnext=1&list=PL20D504D2F9CAC3E7&feature=results_video
<select class=”dropdown”>
<option value=”a” attribute=”b“>c</option>
</select>
$(“.dropdown”).live(“change”, function () {
//to get b
var attribute_value= ($(‘option:selected’, this).attr(‘attribute’));
});
After creating your database just apply these
EXEC sp_estimate_data_compression_savings ‘dbo’,
‘Table_Name’, NULL, NULL, ‘PAGE’
AND
ALTER TABLE Datamart_DB
REBUILD WITH (DATA_COMPRESSION = PAGE)
1. Atleast 18years old
2. 1 Government ID
3. PHP 220
-120pesos card
-100 intial deposit