|
|
-
|
|
All of us know the importance of using regular expressions to filter your results or check some specific rules if it exists or not for example to check if the inserted email in the correct format or to check if the inserted string has numbers or not ..Etc and of course you can use regular expression......
|
|
-
|
|
Both of these functions are similar which allow you to replace a null value of a column with any expression belong to the same data type of this column except in one point, COALESCE has ability in case you need to pass a list of expressions to be replaced when the value comes NULL.
<span style="lin......
|
|
-
|
|
In case you have a database with .mdf file and without having the .ldf file of database so to restore this database or reattach it again do the following:
First open SSMS and right click in Database folder in object explorer and choose Attach….
<span style="line-height: 115%; font-famil......
|
|
-
|
|
Sql server 2005/2008 support Unicode characters so you can present your data in any language so for example if your Database collation is (a Latin) and you want to store Arabic language words ,you need to define Unicode data type columns like(nchar,nvarchar,ntext) to stored your data properly and to......
|
|
-
|
|
My friend has faced this problem against some queries so the cause of this problem as described in above title related to the Collation.So He has a table with columns with different collation at Column level for example a Table called "Students" with "FirstName" and "LastName" columns and each of th......
|
|
-
|
|
SQL Server is a backend system and its size limited by the Hard disk.
SQL Server History:
SQL 4.2 (oct 92).
SQL 6.0 (jun 95).
<span style="font-family: Wingdings; mso-fareast-font-family: Wingdings; ms......
|
|
-
|
|
I have read some articles written about how some products like Office 2010 by default support not only Hijri Date but also support UmAlQura Date and this good news.
This article show you some points related to Arabic language (which is my mother tongue) with Sql Server. In general Sql server deals......
|
|
-
|
|
You can assign value to a variable by using SET or SELECT statement and almost they work the same except that a SELECT statement has the ability to have the source value come from a column within the SELECT statement.Let's see these examples to clarify the difference between the two statements:
US......
|
|