tag:blogger.com,1999:blog-12817902172005009462024-03-12T16:26:33.325-07:00Home of the SQL and MySql ResourcesRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1281790217200500946.post-61290698238047505752010-10-21T01:37:00.001-07:002010-10-21T01:37:34.431-07:00Lunched .NET Community web PortalDear My Friends,<br /><br />I have launch the new .NET Community website to help to all developers and software professionals than more this blog.<br /><br />Please visitor, you can find all latest technologies articles, tips and codesnippet in <a href="http://www.codegain.com">www.codegain.com</a><br /><br />even you can publish your blog or articles and etc in <a href="http://www.codegain.com">www.codegain.com</a><br /><br />I'm planning to open article competition,it will help to all the developers and software professional to show their talent and earn or win free gifts and cash prizes.<br /><br /><br />Thank youRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.com0tag:blogger.com,1999:blog-1281790217200500946.post-90211470727249933142009-05-21T20:24:00.000-07:002009-05-21T20:26:49.254-07:00How to insert records from te one table to another table in SQLHi Guys,<br /><br />Last time i watch in the forums, one gentleman ask the question , how to insert records to one table from the another table in Sql Server. <br /><br />This actually simple. and we can do this two ways.<br /><br />1.normal way<br /><br />insert into desttableName select * from databaseName.dbo.sourceTableName;<br /><br /><br />2.You can use the OpenRowSet also<br /><br />INSERT INTO YourTableName<br /><br />SELECT * <br /><br />FROM OPENROWSET(BULK 'SQLNCLI', 'Server=(local);Trusted_Connection=yes;', 'SELECT Columns FROM Database.Schema.Tablename ORDER BY columns)<br /><br /><br />Thank you<br />Keep It WatchRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.com1tag:blogger.com,1999:blog-1281790217200500946.post-10458962515571420222009-05-04T05:33:00.000-07:002009-05-04T05:38:20.128-07:00how to get how many records entered in day by a user in sql server.Hi Guys,<br /><br />Last time i look at the one fourm there one one question how do know how many records entered in per day by a user.<br /><br />i thought in my mind make a script to that.<br /><br />Script:<br /><br /><span style="font-weight:bold;color:green">SELECT COUNT(*) From Tablebname <br />where CreatedDate=GetDate() and UserName=@UserName;</span><br /><br /> Note:You need keep a column for DateOfCreation in you table.<br /><br />Thank you<br />Keep It Watch.RRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.com0tag:blogger.com,1999:blog-1281790217200500946.post-34475966502528654662009-05-04T05:26:00.000-07:002009-05-04T05:29:02.634-07:00How to select random records in SQl Server.Hi Guys,<br /><br />Most of the developers, asking in forums how to select random records from the database in Sql Server.<br /><br />Here script:<br /><span style="font-weight:bold;color:green"><br />SELECT TOP 5 employeeID, FName,LName from Employee <br />ORDER BY NEWID();<br /></span><br /><br /><br />Thank you<br />Keep It WatchRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.com1tag:blogger.com,1999:blog-1281790217200500946.post-3425798835038110182009-04-24T10:36:00.000-07:002009-04-24T10:38:27.124-07:00WelcomeHi Guys<br /><br />Welcome to my Sql Server and MySql Resource blog.Please keep watch i will update soon useful material here.<br /><br />Thank you<br />Keep It WatchRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.com0