Blogs about: Sql Tip
Featured Blog
Transactions in Sql Server
To Check any active transactions which is not commited: SELECT * FROM sys.dm_tran_session_transactions /* This work like activity Monitor */ To See all Executing Queries: sp_who2 active DBCC inputbuff… more →
Kamalraaja's Weblog
Transactions in Sql Server
kamalraaja wrote 4 months ago: To Check any active transactions which is not commited: SELECT * FROM sys.dm_tran_session_transactio … more →
How to get last date of a Month in Sql Server
kamalraaja wrote 8 months ago: declare @date varchar(10) set @date=convert(varchar,year(getdate()))+’-'+convert(varchar,(mont … more →
Inserting using one insert statement
kamalraaja wrote 9 months ago: USE YourDB GO INSERT INTO MyTable (FirstCol, SecondCol) SELECT ‘First’ ,1 UNION ALL SELECT ‘Second’ … more →
creating tables from other tables in sql 2005
kamalraaja wrote 9 months ago: Method 1 : INSERT INTO SELECT This method is used when table is already created in the database earl … more →
Some SQL Tips
kamalraaja wrote 1 year ago: How to replace spaces in text stored in sql server with in function or Store Proceduer? declare @nam … more →
How to use Sql Profiler?
kamalraaja wrote 1 year ago: Take some example that some data base updations will be done through one of your screen in the proje … more →
