|
|
-
15
Liked
| 13
Learned
| 2
Comments
|
|
Yesterday, in PASS summit. SQL Server 2012 has been announced. Denali is going to be named as SQL Server 2012 and will be released in first half of next year.......
|
|
-
15
Liked
| 12
Learned
| 5
Comments
|
|
In SQL Server, 'Go N' will execute the bunch of commands within the batch 'N' times
[code]
Create Table #Temp(SerialNo int identity Primary key, Product varchar(500))
go
Declare @Product varchar(500)='Mouse'
insert into #Temp(Product)
select @......
|
|
-
15
Liked
| 15
Learned
| 6
Comments
|
|
Do you know we can get the definition of all the database programmable objects using a single query only?
You can get the definition of procedure, view, trigger and function using following query:
[code]
SELECT OBJECT_NAME(object_id),
def......
|
|
-
14
Liked
| 10
Learned
| 3
Comments
|
|
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only sin...
|
|
-
14
Liked
| 11
Learned
| 2
Comments
|
|
I recently saw the following code:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[TableName]')
AND type in (N'U'))
DROP TABLE [dbo].[TableName];
However, this is more complicated than needed. You can just...
|
|
-
14
Liked
| 16
Learned
| 3
Comments
|
|
All of us like Keyboard Shortcuts and use it frequently but memorizing them might be painful and we get to remember them after we use it over a period of time. I just found a very easy way to learn and remember the Keyboard Shortcuts in SQL Server Manag...
|
|
-
|
|
The Regex functions are useful for changing the format of existing strings, for example, suppose you want to display Phone no in (ddd) ddd-dddd format instead of ddd-ddd-dddd. To do this, Right click on the required textbox --> click expression... and e...
|
|
-
14
Liked
| 11
Learned
| 3
Comments
|
|
Today I just learn from ABHISHEK DEY Post
If you are working with VS 2010 (any Edition) and cannot open your 2010 solution on VS 2008 then just follow these 3 Steps:
For .sln:
1. Open the solution file in your favorite text editor (ex:...
|
|
-
14
Liked
| 14
Learned
| 0
Comments
|
|
CAPTCHA stands for Completely Automated Public Turing test to tell Computers and Humans Apart,......
|
|
-
14
Liked
| 12
Learned
| 3
Comments
|
|
In my previous post, I showed how to find whether the request came from Mobile or PC. But later my requirement is extended to find whether the request came from IPAD or not also. For this. We can use Request.UserAgent, If it has the word "ipad", it mean......
|
|