Archive for the ‘SQL’ Category
Restore Database MSSMS
When you try to restore a database there are some very tricky stuff you need to know.
Filed under: SQL, windows | Leave a Comment
T-SQL Settings Explained
A list of widely used SQL settings Explained ANSI NULLS QUOTED_IDENTIFIER ARITHMABORT ANSI_DEFAULTS ANSI_WARNINGS DATEFIRST DATEFORMAT NOCOUNT NOEXEC IDENTITY_INSERT IMPLICITY_TRANSACTIONS LANGUAGE ANSI NULLS – Syntax SET ANSI_NULLS {ON | OFF} – Explanation The SQL-92 standard requires that an equals (=) or not equal to (<>) comparison against a null value evaluates to FALSE. When SET […]
Filed under: SQL, tutorials | Leave a Comment
ADD IDENTITY TO COLUMN
If you have an existing table (in my case products) This is the code you ll use to Alter a column and Add Identity to it. This is the Only Solution found on the NET. Even SSIS Cant to this procedure automatically. I guess this is caused due to constrains bound to a table. — […]
Filed under: SQL, tips | 2 Comments
Sql Server 2008 – New Features
If you work with SQL Server on a regular basis, either writing custom queries, designing databases, or optimizing queries, this is a must see video as it covers a number of the enhancements to SQL Server 2008 including: – SQL Management Studio improvements including IntelliSense – New Data Types for just dates or times (no more […]
Filed under: SQL | Leave a Comment
Lets consider a simple table called employee( emp_id, name, salary). Now, suppose that we need to create a gridview with paging. One option is to bring all the data from database and do the paging in client-side and another one is to do selective fetch. In both cases we can use a stored procedure that […]
Filed under: SQL | Leave a Comment
SQL SERVER – Reset sa Password
1.Open the SQL Server express management studio 2.Connect to SQL Server using windows authentication 3.Right click the server name and choose properties 4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode” 5.Click OK and restart SQL Server 6.Go to SQL Server studio management express 7.Expand the server and choose security […]
Filed under: SQL, windows | 5 Comments