Generating Identity Column in SELECT statements at runtime There are situations where we need to generate an identity column [run time] seeding 1 when inserting records into staging or another tables. For example, you have a table where you have a primary key and identity has not been set on this primary key column. If you want to insert records into this table on daily basis you need to generate the value for identity column when you are trying to insert records using select statements. There are two easy ways to generate an...
SQL Server Error:53 the network path was not found
ADDITIONAL INFORMATION: Error: Could not open connection to SQL Server Error:53 the network path was not found A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) When you are trying to connect to SQL Server from SSMS you may face this error because...
Content within this application coming from the website listed is being blocked by internet explorer
This error seems like problem with Internet Explorer, but you will be getting this error due to the setting in the Outlook in most of the cases. To over come this error, you need to change the People Pane setting in the outlook. Follow the below steps: 1. Open outlook. 2. Goto to the View tab 3. Click on the People Pane and make it "Off". This works for me. :) ...
Identify Missing Sequence Numbers SQL Server
There are many scenarios where we may in need to identify the missing numbers in the provided range. Here is the quick query which help in identifying using CTE [Common Table Expression]: DECLARE @Test TABLE ( Num INT ) INSERT INTO @Test VALUES (1) INSERT INTO @Test VALUES (2) INSERT INTO @Test VALUES (4) INSERT INTO @Test VALUES (5) INSERT INTO @Test VALUES (8) INSERT INTO @Test VALUES (9) INSERT INTO @Test VALUES (10) --Get the Missing Numbers from the sequence ;WITH Missing (minid, maxid) AS ( SELECT 0 AS minid, 10 UNION ALL SELECT minid + 1, maxid FROM Missing WHERE minid < maxid ) SELECT minid FROM Missing LEFT OUTER JOIN @Test tt on tt.Num = Missing.minid WHERE tt.Num is NULL OPTION (MAXRECURSION 0); Result: minid 0 3 6 7 ...
You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server
If you are facing this error "You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server" when you are running transaction replications, here is the reason behind this. You are trying to insert a row in the secondary server where the table property "NOT FOR REPLICATION" option is enabled. To work around this issue, disable the NOT FOR REPLICATION option for the IDENTITY column. Here is how we can check the value: The "Not For...
Could not load file or assembly '' or one of its dependencies. An attempt was made to load the program with an incorrect format.
Could not load file or assembly '' or one of its dependencies. An attempt was made to load the program with an incorrect format. If you have any VC++ CLI components in your azure web role and you are facing the above error, then this post might be helpful for you to resolve your issue. One of the most common problems reported regarding Windows Azure Web Sites is “Assembly Loading” issue. Two main things you need to verify, This error might be causing because Azure runtime is unable to find the dll/assembly...
Subscribe to:
Posts (Atom)
