|
|
-
Dattatrey Sindol (Datta) Liked 11 Months ago through Just Learned | 1 Point
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...
|
-
Dattatrey Sindol (Datta) Liked 11 Months ago through Just Learned | 1 Point
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...
|
-
Dattatrey Sindol (Datta) Learned 11 Months ago through Just Learned | 1 Point
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...
|
-
Dattatrey Sindol (Datta) Learned 11 Months ago through Just Learned | 1 Point
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...
|
-
Dattatrey Sindol (Datta) Commented 11 Months ago through Just Learned | 1 Point
Yes Nakul you are right. Actually I was going through some SQL Scripts which were written for SQL Azure as part of one of my new assignments and I found that in few places they used GETDATE() (Script written by one guy) and other places GETUTCDATE() (Sc...
|
-
Dattatrey Sindol (Datta) Commented 11 Months ago through Just Learned | 1 Point
Yes Nakul you are right. Actually I was going through some SQL Scripts which were written for SQL Azure as part of one of my new assignments and I found that in few places they used GETDATE() (Script written by one guy) and other places GETUTCDATE() (Sc...
|
-
Dattatrey Sindol (Datta) Posted 11 Months ago through Just Learned | 5 Points
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...
|
-
Dattatrey Sindol (Datta) Posted 11 Months ago through Just Learned | 5 Points
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...
|
-
Dattatrey Sindol (Datta) knew 11 Months ago through Just Learned | 1 Point
I love the track changes feature in Word. But a similar feature is not available in PowerPoint. The workaround is to post "comments" in PowerPoint. it's not as elegant as "track changes" feature in word but it's OK for now. ...
|
-
Dattatrey Sindol (Datta) knew 11 Months ago through Just Learned | 1 Point
I love the track changes feature in Word. But a similar feature is not available in PowerPoint. The workaround is to post "comments" in PowerPoint. it's not as elegant as "track changes" feature in word but it's OK for now. ...
|