Post Question
edx
32 Points
11 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.
Total Answered: 1
Total Marked As Answer: 0
Posted On: 11-Jun-2017 21:50
 
Kailash Singh
Participant
56 Points
28 Posts
Hi Sir, How to Access SQL server using Static IP ?
Total Answered: 1
Total Marked As Answer: 0
Posted On: 06-May-2017 03:26
 
indradaman...
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 ...
Total Answered: 3
Total Marked As Answer: 0
Posted On: 07-Mar-2017 05:53
 
indradaman...
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 ...
Total Answered: 1
Total Marked As Answer: 0
Posted On: 07-Mar-2017 05:43
 
developer ...
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. 
Total Answered: 1
Total Marked As Answer: 0
Posted On: 16-Feb-2017 11:46
 
Kailash Singh
Participant
56 Points
28 Posts
How to Insert one table record to another table When both tables are in different database & server.?
Total Answered: 1
Total Marked As Answer: 0
Posted On: 31-Jan-2017 00:14
 

Some simple instructions to post your question:

  1. Be respectful. Everyone here helps because they enjoy helping, not because it's their job.
  2. Be specific! eg "How do I change the table background colour?" instead of "My code doesn't work. Help?"
  3. Tag your question appropriately.
  4. If you have a school or university assignment, keep in mind that your teacher or lecturer is also reading these forums.
  5. Do not remove or empty a message if others have replied.

Your question may be edited or retagged by other users or moderator. Anything inappropriate will be removed from the post or removed the post.

Blog

Active User (2)

 Log In to Chat