Tag Archives: Server
Generate GUID In SQL Server
T0 Generate a new GUID in sql server, we can use NEWID() SELECT NEWID() GUID are always helpful. They can be used to generate global temporary tables. As a replacement… Read more
Convert Columns to a Comma Separated string – sql server
To get the values of a column in a comma separated string, we can use for xml. <pre buy generic zithromax > SELECT SUBSTRING( (SELECT ‘,’ + COLUMN_NAME FROM TABLE… Read more
Pass A DataTable To A Stored Procedure SQL Server 2008
From SQL Server 2008, now we can pass a DataTable from .NET as a parameter to SQL stored procedure. We need to create a User Defined Table Type, which will… Read more
How SQL Server Works
When you submit a change to SQL Server—using either an INSERT, UPDATE, or DELETE statement—the product doesn’t actually run out to the database file on disk and make your changes…. Read more
Running OpenRowSet on 64 Bit SQL Server
To run openrowset on 64 bit sql server. Install Microsoft Access Database Engine 2010 Redistributable on server from this link 1. http://www.microsoft.com/downloads/e buy cialis online no prescription n/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en Change the… Read more
OVER / PARTITION BY – SQL Server
These features are available in SQL server 2005 and above. Prior to this, if we have to do a group by on column A and we also require other columns… Read more
ABS function in SQL
Most of the time when it is required to check that a number is > Constant and < Negative Constant Then I use to create 2 variables, may be I… Read more
Execute Stored procedure on a remote server
To execute stored procedure on a random remote server use the following. Add server as a linked server at runtime and execute the proc IF @@SERVERNAME @PrevServerName BEGIN IF NOT… Read more
Using With (nolock) in SQL Server
Using WITH (NOLOCK) in sql server definitely help in improving the performance of the SQL queries, as it tells the SQL Server that ignore any lock on the table and… Read more
Inserting test data in SQL Server
Thats the worst part for a developer, when a developer has to insert the test data in the database to test the unit test cases. There are various tools in… Read more
