49 Questions

edx
edx
58 Points
19 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: 282
Total Answered: 2
Total Marked As Answer: 1
Posted On: 09-May-2019 05:47 
 
Ankit tewari
Ankit t...
40 Points
20 Posts
how can Send SMS using  stored procedures from SQL Server 2008 
Views: 8298
Total Answered: 2
Total Marked As Answer: 0
Posted On: 30-Jan-2018 10:35 
 
Liam
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: 8583
Total Answered: 2
Total Marked As Answer: 1
Posted On: 23-Jan-2018 04:35 
 
edx
edx
58 Points
19 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: 9004
Total Answered: 2
Total Marked As Answer: 1
Posted On: 11-Jun-2017 21:50 
 
Kailash Singh
Kailash...
Participant
66 Points
28 Posts
Hi Sir, How to Access SQL server using Static IP ?
Views: 8274
Total Answered: 1
Total Marked As Answer: 0
Posted On: 06-May-2017 03:26 
 
indradaman sharma
indrada...
Participant
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: 8316
Total Answered: 3
Total Marked As Answer: 0
Posted On: 07-Mar-2017 05:53 
 
indradaman sharma
indrada...
Participant
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: 8275
Total Answered: 1
Total Marked As Answer: 0
Posted On: 07-Mar-2017 05:43 
 
developer trilochan
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: 8249
Total Answered: 1
Total Marked As Answer: 0
Posted On: 16-Feb-2017 11:46 
 
Kailash Singh
Kailash...
Participant
66 Points
28 Posts
How to Insert one table record to another table When both tables are in different database & server.?
Views: 8268
Total Answered: 1
Total Marked As Answer: 0
Posted On: 31-Jan-2017 00:14 
 
Rashmi
Rashmi
Member
114 Points
27 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: 8263
Total Answered: 1
Total Marked As Answer: 0
Posted On: 25-Jan-2017 03:26 
 
 Log In to Chat