|
|
-
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
| 12
Learned
| 4
Comments
|
|
During working with replication, encountered with one error to use actual server name for replication. For solution we need to change the SQL Server instance name as actual server name with following,
[CODE]
EXEC sp_dropserver 'Old Server Name'
EXE......
|
|
-
14
Liked
| 14
Learned
| 10
Comments
|
|
Just learned from focus.com's Editors article.In that they have identified Top 10 Largest Databases in the World, Here we have the list.
I)The Library of Congress (LC) boasts more than 130 million items ranging from cook books to colonial newspapers ......
|
|
-
14
Liked
| 13
Learned
| 1
Comments
|
|
From, SQL Server help file,
"An UPDATE, INSERT, or DELETE statement that has an OUTPUT clause will return rows to the client even if the statement encounters errors and is rolled back. The result should not be used if any error occurs when you run th......
|
|