|
|
-
Alpesh Patel Liked 2 Months ago through Blogs
Insert a value in table which has only Identity column automatically without specifying any hard value for that column. No identity_insert ON/OFF.....
|
-
Alpesh Patel Commented 3 Months ago through Blogs
Hi,
insert into @tblStoreWithResultSetsData
EXEC Usp_FetchRecords
WITH RESULT SETS
(
( [Emp Id] int,
[Emp Name] varchar(6), -- as a proof of concept,
-- change the dataType size to 6.
-- Records wil...
|
-
Alpesh Patel Liked 4 Months ago through Just Learned
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Alpesh Patel Learned 4 Months ago through Just Learned
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Alpesh Patel Posted 4 Months ago through Just Learned
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**To ...
|
|
|
-
Alpesh Patel Liked 4 Months ago through Blogs
All developers know, that it is very important to encapsulate code in classes and
methods to be able to reuse bits and pieces for other purposes than they were originally
made for. The same goes for t-sql development, by usin...
|
-
Alpesh Patel refreshed 4 Months ago through Blogs
All developers know, that it is very important to encapsulate code in classes and
methods to be able to reuse bits and pieces for other purposes than they were originally
made for. The same goes for t-sql development, by usin...
|
-
Alpesh Patel Liked 4 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Alpesh Patel Learned 4 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|