Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008-r2

How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM?

Using IF ELSE statement based on Count to execute different Insert statements

DateTime fields from SQL Server display incorrectly in Excel

excel sql-server-2008-r2

Import and Export Wizard with Identity Column

A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

How to solve SQL Server Error 1222 i.e Unlock a SQL Server table

How do I find the data directory for a SQL Server instance?

Select query to remove non-numeric characters

Rebuild all indexes in a Database

Is a single SQL Server statement atomic and consistent?

Cannot use UPDATE with OUTPUT clause when a trigger is on the table

How to query for Xml values and attributes from table in SQL Server?

Calculating distance between two points (Latitude, Longitude)

Partition Function COUNT() OVER possible using DISTINCT

Search of table names

Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

SQL Server 2008: How to query all databases sizes?

SQL Server - Create a copy of a database table and place it in the same database?

SQL Update with row_number()

Check if table exists and if it doesn't exist, create it in SQL Server 2008