|
|
-
|
|
Synonyms word says all. To hide the actual name or object from the user.
Using this feature you can hide the linked server objects and directly use it in you database.
To do that follow the steps
1. Create link server.
2. Create synonums and provide ...
|
|
-
|
|
The Format is the new function to format string.
i.e. If you wish to format date in you desire format then.
SELECT FORMAT(sysdatetime(),'yyyyMMdd')...
|
|
-
|
|
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERIC(@...
|
|
-
|
|
I just learned how to setup a RSS subscription on stackoverflow tags.
There are couple of ways:
1) Just hover your mouse over the tag to see the "RSS" button:
2) Scroll to the bottom of the page to see a RSS link:
And If you know the tagname, here's ...
|
|
-
|
|
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
|
-
|
|
Whenever you have a filtered index you just might find that it's not used when its columns are compared to a variable.
The thing is, SQL Server will always make an Excecution Plan that would work with any values for those variable (including the values ...
|
|
-
|
|
Both `SP_who` and `SP_who2` provides information about the current processes/sessions/users in an SQL servert instance.
- `SP_WHO`:
`SP_WHO` provides information like Session ID, Logged in User id , Host name, session status, blocking ...
|
|
-
|
|
There are 2 Set Options available to only parse the SQL Statements.
> 1.
SET PARSEONLY ON;
GO
SELECT * FROM TableName;
GO
SET PARSEONLY OFF;
GO
> 1.
SET NOEXEC ON;
GO
SELECT * FROM TableName;
GO
SET NOEXEC OFF
> 1. Option only give schema of Tabl...
|
|
-
|
|
I just learned how to unhide formula bar in Excel 2013. View Tab > check "Formula Bar" checkbox. ...
|
|
-
|
|
There is no implicit conversion on assignment from the sql_variant data type to other, but there is implicit conversion to sql_variant.
SQL_VARIANT is a data type that stores values of various SQL Server-supported data types.
ODBC does not fully suppo...
|
|