|
|
-
DURGA PRASAD Commented 10 Months ago through Interview Questions
The below query would also achieve the desired result.
SELECT OBJECT_NAME(ID)
FROM SYSCOMMENTS
WHERE TEXT LIKE '%TableName%'...
|
-
DURGA PRASAD Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Which database object can 'also' be used to maintain Referential Integrity?...
|
-
Which database object can 'also' be used to maintain Referential Integrity?...
|
-
DURGA PRASAD Liked 1 Years ago through Just Learned
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query...
|
-
DURGA PRASAD Learned 1 Years ago through Just Learned
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query...
|
-
DURGA PRASAD Liked 1 Years ago through Just Learned
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query...
|
-
DURGA PRASAD Learned 1 Years ago through Just Learned
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query...
|
-
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
-
DURGA PRASAD Liked 1 Years ago through Just Learned
Todays [Just Learned] tip is:
- CHECKSUM - where you can count hash value
of entire row (or only set of columns) -
horizontal; Useful for creating own
index (for example for long
strings), for validation of changed
values, and ...
|