|
|
-
|
|
I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :)
Here is the code.
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, refe...
|
|
-
|
|
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context me...
|
|
-
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...
|
|
-
|
|
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying Syst...
|
|
-
|
|
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
Initially thought it's like a cheat code. But its about mastering the basics. In MSD...
|
|
-
|
|
Hello devs,
Today i have watched this tutorial video of NDC 2012, Brad presented 3 topics
1. Knockoutjs with html5
2. Asp .Net Web API
3. SignalR
session contain introduction and demonstration of all three.
Resource: http://github.co...
|
|
-
|
|
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
|
-
|
|
In earlier versions of Reporting Services running in native mode, SQL Server 2005 Report Builder could be started using the following URLS:
Full trust :- http:///reportserver/reportbuilder/reportbuilder.application
Partial trust :- htt...
|
|
-
|
|
In earlier versions of Reporting Services running in native mode, SQL Server 2005 Report Builder could be started using the following URLS:
Full trust :- http:///reportserver/reportbuilder/reportbuilder.application
Partial trust :- http:...
|
|
-
|
|
SYSDATETIME(), SYSDATETIMEOFFSET(), SYSUTCDATETIME(), CURRENT_TIMESTAMP, GETDATE(), and GETUTCDATE() functions yield the same result on SQL Azure irrespective of the primary data center. And all of them return the UTC date/time.
**Note**: Here we are t...
|
|