Biportal.cz Website Review

In the past, I have written several tutorials on reporting services (see SSRS). I have thoroughly detailed how reports can be just about experience and training, I can not help you much anymore. One thing I have ... Read More »SQL Synonym is a command that is in SQL Server since the SQL Server 2005 version. This feature is useful for making it very convenient because we do not have to write it so much, and it is also useful if we work in database, ... Read more »It's just a bunch of disordered data. Conversely, a clustered index table is better structured in a balanced tree. The primary key is itself a clustered index and should have every table. A table arranged in a balanced tree much better within the data model performs on queries ... Read More »The daily bread db admina is to track the condition of its database and SQL Server instance. It is often stated in the policy that some columns must have a certain data type - for example, we may not use (n) varchar (max) for certain reasons and we need to obtain a list of columns and data types in our database ... Read More »Operations above date data types are very frequent, and we often need to get a date or some other information that comes out of the date using SQL functions - such as the week, month, year, last day of the month, and so on. Today's date - GETDATE (), SYSDATETIME () Today's date and time to query realization can be obtained in two ways. First. SQL ERROR - CONVERSION FAILED WHEN CONVERTING THE VARCHAR VALUE TO DATA TYPE INT. type int prints SQL Server when we try to convert the value that is stored as the varchar (text) data type to the INTEGER data type. This may not be a problem if we have numbers stored as varchar, but the problem arises if we get between these numbers