Reset table auto increment column in ms sql server

Reset table auto increment column in ms sql server If we want to reset the auto increment value of any table to any other value than default value, we need to use DBCC query. To use DBCC query you must open sql server management studio with Administrator permission. Check the below query: DBCC CHECKIDENT(‘tblUser‘, RESEED, 1000)

recall of sql connectivity in c# asp .net with detailed example

Recall of sql connectivity in c# asp .net with detailed example Hello friend, now I am giving you a example in which we use basic controls with database connectivity. We also use store procedure and configurationamanager to access connectionstring defined (<connectionstrings>) to manipulate data with server. We used a simple form which use basic controls like

Fetching data from two or more tables(Joining of tables)

Selecting data from two or more tables(Joining of tables) Hello Friends, today we will learn how to select data(records) from more than one table. For this purpose we will use joining of tables. Joining simply join one or two or more than two tables by some conditions as per need. One there is a joining between one

create a cursor in ms sql server

create a cursor in ms sql server Cursor is used to fetch records(rows) from any table sequentially and records can be manipulated, calculated as per your need. To create a cursor use this sql query: declare cursor_name cursor for select id from tbl_Category open cursor_name fetch next from cursor_name into @Id while @@fetch_status=0 begin insert into table_name(id) values

introduction of store procedure in mssql server

Hello friend, It is very bad habit and difficult to write separate sql query for each operation in sql query. The best solution for this problem is procedure . Procedure is similar to function which we will learn in next chapter, is collection of code which can be executed at any time. To create a procedure open

insert, delete and update queries using mssql server

Insert Query insert into table_name(column1,column2,column3,column4) values(value1,value2,value3,value4) We can also use design view to insert values into table. If you dont know how to create a table please follow the previous post create a table in mssql server . Just Right click on the Table_name in which you need to insert the table and select open table. Now put the