|
|
-
abhIShek BandI Liked 3 Months ago through Blogs | 1 Point
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
-
abhIShek BandI learned 3 Months ago through Blogs | 1 Point
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
|
|
-
abhIShek BandI Liked 5 Months ago through Blogs | 1 Point
During upgradation of a client database from SQL Server 2000 (Compatibility Level 80) to SQL Server 2005 (Compatibility Level 90), I have found that there are changes which need to apply for compatibility level 90, that are still not documented...
|
|
|
|
|
-
abhIShek BandI learned 6 Months ago through Blogs | 1 Point
Have you ever wondered as to which database is first made online when a SQL Server instance starts? When are user databases made available in the startup sequence? When is the tempdb available? Today, I try to find answers to these questions....
|
-
abhIShek BandI Liked 6 Months ago through Blogs | 1 Point
Have you ever wondered as to which database is first made online when a SQL Server instance starts? When are user databases made available in the startup sequence? When is the tempdb available? Today, I try to find answers to these questions....
|
|
|
-
abhIShek BandI Liked 7 Months ago through Blogs | 1 Point
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say –...
|