|
|
|
|
-
Manas Ranjan Dash Liked 7 Months ago through Just Learned | 1 Point
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 su...
|
-
Manas Ranjan Dash Learned 7 Months ago through Just Learned | 1 Point
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 su...
|
-
Manas Ranjan Dash Learned 7 Months ago through Just Learned | 1 Point
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend usin...
|
-
Manas Ranjan Dash Liked 7 Months ago through Just Learned | 1 Point
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend usin...
|
-
Manas Ranjan Dash Posted 7 Months ago through Just Learned | 5 Points
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend using 4...
|
-
Manas Ranjan Dash Posted 7 Months ago through Just Learned | 5 Points
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...
|
|
|
-
Manas Ranjan Dash Liked 7 Months ago through Just Learned | 1 Point
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
-
Manas Ranjan Dash Learned 7 Months ago through Just Learned | 1 Point
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|