edx
68
Points
24
Posts
|
In a table 'Customer', I have an Id column, which is an Identity int.
How can I make it so that the next row inserted will get identity 1000(I think, this is called the identity seed) without dropping and recreating the 'Customer' table?
I want to do this because of some uniqueness issue with an ext ...
Views:
881
Total Answered:
2
Total Marked As Answer:
1
Posted On:
09-May-2019 05:47
|
Ankit t...
40
Points
20
Posts
|
how can Send SMS using stored procedures from SQL Server 2008
Views:
8702
Total Answered:
2
Total Marked As Answer:
0
Posted On:
30-Jan-2018 10:35
|
Liam
2
Points
1
Posts
|
I have following select command (round/truncate):
--Round
SELECT ROUND(100.55555552, 2)
--Truncate
SELECT ROUND(100.55555552, 2, 1)
Both giving trailing zeros
How we can remove trailing zeros?
Views:
11898
Total Answered:
2
Total Marked As Answer:
1
Posted On:
23-Jan-2018 04:35
|
|
edx
68
Points
24
Posts
|
Is it possible to add a column to a table at a specific ordinal position in SQL Server?
For instance, our tables always have CreatedDate, CreatedBy, LastModifiedDate, LastModifiedBy columns at the "end" of each table definition? I'd like the new column to show up in SSMS above these columns.
Views:
11922
Total Answered:
2
Total Marked As Answer:
1
Posted On:
11-Jun-2017 21:50
|
Kailash...
66
Points
28
Posts
|
Hi Sir, How to Access SQL server using Static IP ?
Views:
8651
Total Answered:
1
Total Marked As Answer:
0
Posted On:
06-May-2017 03:26
|
indrada...
54
Points
17
Posts
|
1
A
1
B
1
C
2
A
1
D
2
B
2
c
Select this table so we get below result
1
A
1
1
B
2
1
C
3
2
A
1
1
D
4
2
B
2
2
C
3
Please give me res ...
Views:
8767
Total Answered:
3
Total Marked As Answer:
0
Posted On:
07-Mar-2017 05:53
|
|
indrada...
54
Points
17
Posts
|
This is my first store procedure
CREATE PROCEDURE SP_GetValue1
AS
BEGIN
SELECT CustomerID, CustomerName, UserID, Password, CompanyName, IsVerified, IsActive, InsertedID, InsetedDate, UpdatedID, UpdatedDate, IPAddress
FROM Login_Customer
END
It give me back table with column.
Now i w ...
Views:
8636
Total Answered:
1
Total Marked As Answer:
0
Posted On:
07-Mar-2017 05:43
|
|
develop...
4
Points
2
Posts
|
Delete two table data having single sql query first table id field is work as forign key i am not using forign key constaints. Is it possible to delete without constaints.
Views:
8611
Total Answered:
1
Total Marked As Answer:
0
Posted On:
16-Feb-2017 11:46
|
|
Kailash...
66
Points
28
Posts
|
How to Insert one table record to another table When both tables are in different database & server.?
Views:
8646
Total Answered:
1
Total Marked As Answer:
0
Posted On:
31-Jan-2017 00:14
|
Rashmi
144
Points
32
Posts
|
I have create a procedure with output parameter and trying to execute in asp.net MVC. But unable to get value.
C# Snippet:
public
long
SomeMethod(
long
eventId,
string
userId)
{
long
duplicatedEventId = 0;
var
paramEventId =
new
SqlParameter
(
"@EventId"
, eventId);
paramEvent ...
Views:
8692
Total Answered:
1
Total Marked As Answer:
0
Posted On:
25-Jan-2017 03:26
|